1
0.64 ms
SELECT t0 . email AS email_1 , t0 . first_name AS first_name_2 , t0 . last_name AS last_name_3 , t0 . roles AS roles_4 , t0 . password AS password_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . id AS id_8 , t0 . erp_id AS erp_id_9 , t0 . is_active AS is_active_10 FROM user t0 WHERE t0 . id = ?
SELECT t0 . email AS email_1 , t0 . first_name AS first_name_2 , t0 . last_name AS last_name_3 , t0 . roles AS roles_4 , t0 . password AS password_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . id AS id_8 , t0 . erp_id AS erp_id_9 , t0 . is_active AS is_active_10 FROM user t0 WHERE t0 . id = 1 ;
Copy
2
0.72 ms
SELECT t0 . visit_number AS visit_number_1 , t0 . has_application AS has_application_2 , t0 . lw_send AS lw_send_3 , t0 . lw_retry_count AS lw_retry_count_4 , t0 . lw_remark AS lw_remark_5 , t0 . id AS id_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . base_price AS base_price_9 , t0 . final_price AS final_price_10 , t0 . offer_status_id AS offer_status_id_11 , t0 . sale_place_id AS sale_place_id_12 , t0 . user_id AS user_id_13 FROM offer t0 WHERE t0 . id = ?
SELECT t0 . visit_number AS visit_number_1 , t0 . has_application AS has_application_2 , t0 . lw_send AS lw_send_3 , t0 . lw_retry_count AS lw_retry_count_4 , t0 . lw_remark AS lw_remark_5 , t0 . id AS id_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . base_price AS base_price_9 , t0 . final_price AS final_price_10 , t0 . offer_status_id AS offer_status_id_11 , t0 . sale_place_id AS sale_place_id_12 , t0 . user_id AS user_id_13 FROM offer t0 WHERE t0 . id = 237 ;
Copy
3
0.53 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM offer_status t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM offer_status t0 WHERE t0 . id = 3 ;
Copy
4
0.41 ms
SELECT t0 . id AS id_1 , t0 . offer_id AS offer_id_2 , t0 . eye_examination_id AS eye_examination_id_3 FROM offer_item t0 WHERE t0 . offer_id = ?
SELECT t0 . id AS id_1 , t0 . offer_id AS offer_id_2 , t0 . eye_examination_id AS eye_examination_id_3 FROM offer_item t0 WHERE t0 . offer_id = 237 ;
Copy
5
0.70 ms
SELECT t0 . sku AS sku_1 , t0 . name AS name_2 , t0 . quantity AS quantity_3 , t0 . id AS id_4 , t0 . base_price AS base_price_5 , t0 . final_price AS final_price_6 , t0 . offer_item_id AS offer_item_id_7 FROM offer_item_item t0 WHERE t0 . offer_item_id = ?
SELECT t0 . sku AS sku_1 , t0 . name AS name_2 , t0 . quantity AS quantity_3 , t0 . id AS id_4 , t0 . base_price AS base_price_5 , t0 . final_price AS final_price_6 , t0 . offer_item_id AS offer_item_id_7 FROM offer_item_item t0 WHERE t0 . offer_item_id = 237 ;
Copy
6
0.52 ms
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = ?
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = 685 ;
Copy
7
0.46 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 1 ;
Copy
8
0.40 ms
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = ?
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = 700 ;
Copy
9
0.40 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 34 ;
Copy
10
0.37 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 12 ;
Copy
11
0.32 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 13 ;
Copy
12
0.33 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 9 ;
Copy
13
0.39 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 11 ;
Copy
14
0.47 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 23 ;
Copy
15
0.42 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 10 ;
Copy
16
0.43 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 30 ;
Copy
17
0.47 ms
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = ?
SELECT t0 . label AS label_1 , t0 . value AS value_2 , t0 . id AS id_3 , t0 . product_attribute_type_id AS product_attribute_type_id_4 , t0 . offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0 . offer_item_item_id = 701 ;
Copy
18
0.97 ms
SELECT t0 . first_name AS first_name_1 , t0 . last_name AS last_name_2 , t0 . phone AS phone_3 , t0 . prescription_issue_date AS prescription_issue_date_4 , t0 . comment AS comment_5 , t0 . package_number AS package_number_6 , t0 . has_prism_to_the_distance AS has_prism_to_the_distance_7 , t0 . has_prism_for_near_vision AS has_prism_for_near_vision_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . id AS id_11 , t0 . oculist_id AS oculist_id_12 , t0 . eye_examination_type_id AS eye_examination_type_id_13 FROM eye_examination t0 WHERE t0 . id = ?
SELECT t0 . first_name AS first_name_1 , t0 . last_name AS last_name_2 , t0 . phone AS phone_3 , t0 . prescription_issue_date AS prescription_issue_date_4 , t0 . comment AS comment_5 , t0 . package_number AS package_number_6 , t0 . has_prism_to_the_distance AS has_prism_to_the_distance_7 , t0 . has_prism_for_near_vision AS has_prism_for_near_vision_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . id AS id_11 , t0 . oculist_id AS oculist_id_12 , t0 . eye_examination_type_id AS eye_examination_type_id_13 FROM eye_examination t0 WHERE t0 . id = 510 ;
Copy
19
0.99 ms
SELECT t0 . power AS power_1 , t0 . cylinder AS cylinder_2 , t0 . axis AS axis_3 , t0 . addition AS addition_4 , t0 . prism1 AS prism1_5 , t0 . prism_direction1 AS prism_direction1_6 , t0 . prism2 AS prism2_7 , t0 . prism_direction2 AS prism_direction2_8 , t0 . pd AS pd_9 , t0 . oc_height AS oc_height_10 , t0 . eye AS eye_11 , t0 . correction_type AS correction_type_12 , t0 . id AS id_13 , t0 . eye_examination_id AS eye_examination_id_14 FROM eye_examination_item t0 WHERE t0 . eye_examination_id = ?
SELECT t0 . power AS power_1 , t0 . cylinder AS cylinder_2 , t0 . axis AS axis_3 , t0 . addition AS addition_4 , t0 . prism1 AS prism1_5 , t0 . prism_direction1 AS prism_direction1_6 , t0 . prism2 AS prism2_7 , t0 . prism_direction2 AS prism_direction2_8 , t0 . pd AS pd_9 , t0 . oc_height AS oc_height_10 , t0 . eye AS eye_11 , t0 . correction_type AS correction_type_12 , t0 . id AS id_13 , t0 . eye_examination_id AS eye_examination_id_14 FROM eye_examination_item t0 WHERE t0 . eye_examination_id = 510 ;
Copy
20
0.80 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 2 ;
Copy
21
0.38 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 4 ;
Copy
22
0.41 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 5 ;
Copy
23
0.32 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 21 ;
Copy
24
0.32 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 7 ;
Copy
25
0.32 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 8 ;
Copy
26
0.46 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 35 ;
Copy
27
0.48 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0 . id = 39 ;
Copy
28
1.25 ms
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . sort_order AS sort_order_7 , t0 . visibility AS visibility_8 FROM product_price_type t0 WHERE t0 . is_active = ? AND t0 . visibility IN (? , ? ) ORDER BY t0 . sort_order ASC
Parameters :
[
1
"Show "
"Include in base price "
]
SELECT t0 . name AS name_1 , t0 . is_active AS is_active_2 , t0 . code AS code_3 , t0 . id AS id_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . sort_order AS sort_order_7 , t0 . visibility AS visibility_8 FROM product_price_type t0 WHERE t0 . is_active = 1 AND t0 . visibility IN ('Show' , 'Include in base price' ) ORDER BY t0 . sort_order ASC ;
Copy