1.20 ms (31.79%)
2
SELECT a0_ . id AS id_0 , a0_ . text AS text_1 , a0_ . style AS style_2 , a0_ . dismissable AS dismissable_3 , a0_ . display_from AS display_from_4 , a0_ . display_until AS display_until_5 , a0_ . target AS target_6 FROM alert a0_ WHERE (a0_ . display_from IS NULL OR a0_ . display_from < = ? ) AND (a0_ . display_until IS NULL OR a0_ . display_until > = ? ) ORDER BY a0_ . id ASC LIMIT 5
Parameters :
[
"2026-02-27 12:21:51 "
"2026-02-27 12:21:51 "
]
SELECT a0_ . id AS id_0 , a0_ . text AS text_1 , a0_ . style AS style_2 , a0_ . dismissable AS dismissable_3 , a0_ . display_from AS display_from_4 , a0_ . display_until AS display_until_5 , a0_ . target AS target_6 FROM alert a0_ WHERE (a0_ . display_from IS NULL OR a0_ . display_from < = '2026-02-27 12:21:51' ) AND (a0_ . display_until IS NULL OR a0_ . display_until > = '2026-02-27 12:21:51' ) ORDER BY a0_ . id ASC LIMIT 5 ;
Copy
0.58 ms (15.29%)
1
SELECT t0 . id AS id_1 , t0 . date_listed AS date_listed_2 , t0 . date_sold AS date_sold_3 , t0 . price AS price_4 , t0 . warranty AS warranty_5 , t0 . postage AS postage_6 , t0 . item_id AS item_id_7 , t0 . customer_id AS customer_id_8 FROM listing t0 WHERE t0 . item_id = ?
SELECT t0 . id AS id_1 , t0 . date_listed AS date_listed_2 , t0 . date_sold AS date_sold_3 , t0 . price AS price_4 , t0 . warranty AS warranty_5 , t0 . postage AS postage_6 , t0 . item_id AS item_id_7 , t0 . customer_id AS customer_id_8 FROM listing t0 WHERE t0 . item_id = 22 ;
Copy
0.55 ms (14.44%)
1
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . position AS position_3 , t0 . caption AS caption_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . privacy AS privacy_7 , t0 . gallery_id AS gallery_id_8 FROM image t0 WHERE t0 . gallery_id = ? ORDER BY t0 . position ASC
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . position AS position_3 , t0 . caption AS caption_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . privacy AS privacy_7 , t0 . gallery_id AS gallery_id_8 FROM image t0 WHERE t0 . gallery_id = 38 ORDER BY t0 . position ASC ;
Copy
0.42 ms (11.16%)
1
SELECT l0_ . id AS id_0 , l0_ . date_listed AS date_listed_1 , l0_ . date_sold AS date_sold_2 , l0_ . price AS price_3 , l0_ . warranty AS warranty_4 , l0_ . postage AS postage_5 , l0_ . item_id AS item_id_6 , l0_ . customer_id AS customer_id_7 FROM listing l0_ WHERE l0_ . item_id = ? AND l0_ . date_sold IS NULL
SELECT l0_ . id AS id_0 , l0_ . date_listed AS date_listed_1 , l0_ . date_sold AS date_sold_2 , l0_ . price AS price_3 , l0_ . warranty AS warranty_4 , l0_ . postage AS postage_5 , l0_ . item_id AS item_id_6 , l0_ . customer_id AS customer_id_7 FROM listing l0_ WHERE l0_ . item_id = 22 AND l0_ . date_sold IS NULL ;
Copy
0.38 ms (10.08%)
1
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . item_code AS item_code_3 , t0 . opened_at AS opened_at_4 , t0 . legacy_code AS legacy_code_5 , t0 . access_key AS access_key_6 , t0 . brand AS brand_7 , t0 . model AS model_8 , t0 . title AS title_9 , t0 . picture AS picture_10 , t0 . description AS description_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . date AS date_15 , t0 . date_accuracy AS date_accuracy_16 , t0 . date_estimated AS date_estimated_17 , t0 . gallery_id AS gallery_id_18 FROM item t0 WHERE t0 . item_code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . item_code AS item_code_3 , t0 . opened_at AS opened_at_4 , t0 . legacy_code AS legacy_code_5 , t0 . access_key AS access_key_6 , t0 . brand AS brand_7 , t0 . model AS model_8 , t0 . title AS title_9 , t0 . picture AS picture_10 , t0 . description AS description_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . date AS date_15 , t0 . date_accuracy AS date_accuracy_16 , t0 . date_estimated AS date_estimated_17 , t0 . gallery_id AS gallery_id_18 FROM item t0 WHERE t0 . item_code = 'PETD7' LIMIT 1 ;
Copy
0.34 ms (9.04%)
1
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . type AS type_3 , t0 . performed_by AS performed_by_4 , t0 . title AS title_5 , t0 . summary AS summary_6 , t0 . actions AS actions_7 , t0 . conclusions AS conclusions_8 , t0 . notes AS notes_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . privacy AS privacy_12 , t0 . item_id AS item_id_13 , t0 . gallery_id AS gallery_id_14 FROM intervention t0 WHERE t0 . item_id = ? ORDER BY t0 . date ASC
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . type AS type_3 , t0 . performed_by AS performed_by_4 , t0 . title AS title_5 , t0 . summary AS summary_6 , t0 . actions AS actions_7 , t0 . conclusions AS conclusions_8 , t0 . notes AS notes_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . privacy AS privacy_12 , t0 . item_id AS item_id_13 , t0 . gallery_id AS gallery_id_14 FROM intervention t0 WHERE t0 . item_id = 22 ORDER BY t0 . date ASC ;
Copy
0.31 ms (8.20%)
1
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . direction AS direction_3 , t0 . currency AS currency_4 , t0 . rate AS rate_5 , t0 . amount AS amount_6 , t0 . reference AS reference_7 , t0 . item_id AS item_id_8 , t0 . intervention_id AS intervention_id_9 FROM cashflow t0 WHERE t0 . item_id = ? AND t0 . intervention_id IS NULL ORDER BY t0 . date ASC
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . direction AS direction_3 , t0 . currency AS currency_4 , t0 . rate AS rate_5 , t0 . amount AS amount_6 , t0 . reference AS reference_7 , t0 . item_id AS item_id_8 , t0 . intervention_id AS intervention_id_9 FROM cashflow t0 WHERE t0 . item_id = 22 AND t0 . intervention_id IS NULL ORDER BY t0 . date ASC ;
Copy