1
2.75 ms
SELECT t0 . id AS id_1 , t0 . date_creation AS date_creation_2 , t0 . entity_state AS entity_state_3 , t0 . label AS label_4 , t0 . billing_address AS billing_address_5 , t0 . shipping_address AS shipping_address_6 , t0 . first_name AS first_name_7 , t0 . last_name AS last_name_8 , t0 . phone AS phone_9 , t0 . email AS email_10 , t0 . bank_account AS bank_account_11 , t0 . document_quotation_header AS document_quotation_header_12 , t0 . document_quotation_footer AS document_quotation_footer_13 , t0 . document_invoice_header AS document_invoice_header_14 , t0 . document_invoice_footer AS document_invoice_footer_15 , t0 . currency AS currency_16 , t0 . subdomain AS subdomain_17 , t0 . logo AS logo_18 , t0 . date_start AS date_start_19 , t0 . date_end AS date_end_20 , t0 . active AS active_21 FROM dm_lib_purchaser t0 WHERE t0 . entity_state IN (? , ? , ? , ? ) AND t0 . active = ? AND t0 . subdomain = ? LIMIT 1
Parameters :
[
"new "
"update "
"valid "
"archive "
1
"subotai "
]
SELECT t0 . id AS id_1 , t0 . date_creation AS date_creation_2 , t0 . entity_state AS entity_state_3 , t0 . label AS label_4 , t0 . billing_address AS billing_address_5 , t0 . shipping_address AS shipping_address_6 , t0 . first_name AS first_name_7 , t0 . last_name AS last_name_8 , t0 . phone AS phone_9 , t0 . email AS email_10 , t0 . bank_account AS bank_account_11 , t0 . document_quotation_header AS document_quotation_header_12 , t0 . document_quotation_footer AS document_quotation_footer_13 , t0 . document_invoice_header AS document_invoice_header_14 , t0 . document_invoice_footer AS document_invoice_footer_15 , t0 . currency AS currency_16 , t0 . subdomain AS subdomain_17 , t0 . logo AS logo_18 , t0 . date_start AS date_start_19 , t0 . date_end AS date_end_20 , t0 . active AS active_21 FROM dm_lib_purchaser t0 WHERE t0 . entity_state IN ('new' , 'update' , 'valid' , 'archive' ) AND t0 . active = 1 AND t0 . subdomain = 'subotai' LIMIT 1 ;
Copy
2
0.63 ms
SELECT t0 . id AS id_1 , t0 . date_creation AS date_creation_2 , t0 . entity_type AS entity_type_3 , t0 . value AS value_4 , t0 . description AS description_5 , t0 . css_class AS css_class_6 , t0 . active AS active_7 FROM dm_site_param t0 WHERE t0 . entity_type IN (? , ? )
Parameters :
[
"image_login_support "
"support_introduction "
]
SELECT t0 . id AS id_1 , t0 . date_creation AS date_creation_2 , t0 . entity_type AS entity_type_3 , t0 . value AS value_4 , t0 . description AS description_5 , t0 . css_class AS css_class_6 , t0 . active AS active_7 FROM dm_site_param t0 WHERE t0 . entity_type IN ('image_login_support' , 'support_introduction' );
Copy
3
0.79 ms
SELECT d0_ . id AS id_0 , d0_ . date_creation AS date_creation_1 , d0_ . entity_type AS entity_type_2 , d0_ . label AS label_3 , d0_ . hourly_rate AS hourly_rate_4 , d0_ . color AS color_5 , d0_ . icon AS icon_6 , d0_ . date_start AS date_start_7 , d0_ . date_end AS date_end_8 , d0_ . active AS active_9 , d0_ . purchaser_id AS purchaser_id_10 FROM dm_lib_task_category d0_ WHERE d0_ . active = 1 AND d0_ . entity_type = ? AND (d0_ . date_start IS NULL OR d0_ . date_start < = ? ) AND (d0_ . date_end IS NULL OR d0_ . date_end > = ? ) AND d0_ . purchaser_id = ? ORDER BY d0_ . label ASC
Parameters :
[
"ticket "
"2025-12-06 "
"2025-12-06 "
2
]
SELECT d0_ . id AS id_0 , d0_ . date_creation AS date_creation_1 , d0_ . entity_type AS entity_type_2 , d0_ . label AS label_3 , d0_ . hourly_rate AS hourly_rate_4 , d0_ . color AS color_5 , d0_ . icon AS icon_6 , d0_ . date_start AS date_start_7 , d0_ . date_end AS date_end_8 , d0_ . active AS active_9 , d0_ . purchaser_id AS purchaser_id_10 FROM dm_lib_task_category d0_ WHERE d0_ . active = 1 AND d0_ . entity_type = 'ticket' AND (d0_ . date_start IS NULL OR d0_ . date_start < = '2025-12-06' ) AND (d0_ . date_end IS NULL OR d0_ . date_end > = '2025-12-06' ) AND d0_ . purchaser_id = 2 ORDER BY d0_ . label ASC ;
Copy
4
0.52 ms
SELECT d0_ . id AS id_0 , d0_ . date_creation AS date_creation_1 , d0_ . label AS label_2 , d0_ . color AS color_3 , d0_ . date_start AS date_start_4 , d0_ . date_end AS date_end_5 , d0_ . active AS active_6 , d0_ . position AS position_7 FROM dm_lib_generic_priority d0_ WHERE d0_ . active = 1 ORDER BY d0_ . position ASC
SELECT d0_ . id AS id_0 , d0_ . date_creation AS date_creation_1 , d0_ . label AS label_2 , d0_ . color AS color_3 , d0_ . date_start AS date_start_4 , d0_ . date_end AS date_end_5 , d0_ . active AS active_6 , d0_ . position AS position_7 FROM dm_lib_generic_priority d0_ WHERE d0_ . active = 1 ORDER BY d0_ . position ASC ;
Copy