| 1 |
267.74 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.id = 2;
|
| 2 |
14.95 ms |
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = ? LIMIT 1
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = '5407' LIMIT 1;
|
| 3 |
0.51 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.met_people AS met_people_3, t0.stocked_items AS stocked_items_4, t0.comment AS comment_5, t0.week_number AS week_number_6, t0.token AS token_7, t0.state AS state_8, t0.year AS year_9, t0.client_id AS client_id_10 FROM visit t0 WHERE t0.client_id = ? ORDER BY t0.id DESC
SELECT t0.id AS id_1, t0.date AS date_2, t0.met_people AS met_people_3, t0.stocked_items AS stocked_items_4, t0.comment AS comment_5, t0.week_number AS week_number_6, t0.token AS token_7, t0.state AS state_8, t0.year AS year_9, t0.client_id AS client_id_10 FROM visit t0 WHERE t0.client_id = 563 ORDER BY t0.id DESC;
|
| 4 |
7.18 ms |
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = ?
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = '5407';
|
| 5 |
1.50 ms |
SELECT t0.id AS id_1, t0.no AS no_2, t0.description AS description_3, t0.unit_price AS unit_price_4, t0.gen_prod_posting_group AS gen_prod_posting_group_5, t0.item_category_code AS item_category_code_6, t0.brand AS brand_7, t0.inventory_field AS inventory_field_8, t0.description2 AS description2_9, t0.qty_on_sales_order AS qty_on_sales_order_10, t0.qty_on_purch_order AS qty_on_purch_order_11, t0.sales_qty AS sales_qty_12, t0.purchases_qty AS purchases_qty_13, t0.model AS model_14, t0.consigned AS consigned_15 FROM item t0 WHERE t0.no IN (NULL)
SELECT t0.id AS id_1, t0.no AS no_2, t0.description AS description_3, t0.unit_price AS unit_price_4, t0.gen_prod_posting_group AS gen_prod_posting_group_5, t0.item_category_code AS item_category_code_6, t0.brand AS brand_7, t0.inventory_field AS inventory_field_8, t0.description2 AS description2_9, t0.qty_on_sales_order AS qty_on_sales_order_10, t0.qty_on_purch_order AS qty_on_purch_order_11, t0.sales_qty AS sales_qty_12, t0.purchases_qty AS purchases_qty_13, t0.model AS model_14, t0.consigned AS consigned_15 FROM item t0 WHERE t0.no IN (NULL);
|
| 6 |
1.13 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.sales_person_code = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.sales_person_code = '15' LIMIT 1;
|