1.14 ms (20.54%)
|
1 |
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.number AS number_2, j0_.url_used AS url_used_3, j0_.time AS time_4, j0_.nav_token AS nav_token_5, j0_.origin AS origin_6 FROM jump j0_ WHERE j0_.nav_token = ?
Parameters: [
"0992cbcae035961ff227dab11d278f69dbfc0fa2"
]
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.number AS number_2, j0_.url_used AS url_used_3, j0_.time AS time_4, j0_.nav_token AS nav_token_5, j0_.origin AS origin_6 FROM jump j0_ WHERE j0_.nav_token = '0992cbcae035961ff227dab11d278f69dbfc0fa2';
|
0.95 ms (17.02%)
|
1 |
SELECT c0_.id AS id_0, c0_.creation_date AS creation_date_1, c0_.creation_time AS creation_time_2, c0_.order_number AS order_number_3, c0_.purchase_date AS purchase_date_4, c0_.purchase_time AS purchase_time_5, c0_.total_products AS total_products_6, c0_.total_shipping AS total_shipping_7, c0_.commission AS commission_8, c0_.payment_type AS payment_type_9, c0_.payment_order AS payment_order_10, c0_.payment_gateway AS payment_gateway_11, c0_.payment_auth AS payment_auth_12, c0_.payment_status AS payment_status_13, c0_.courier AS courier_14, c0_.shipping_status AS shipping_status_15, c0_.sha AS sha_16, c0_.currency AS currency_17, c0_.status AS status_18, c0_.lang AS lang_19, c0_.items_details AS items_details_20, c0_.transaction_id AS transaction_id_21, c0_.connection_status AS connection_status_22, c0_.promo_code AS promo_code_23, c0_.sale_person_id AS sale_person_id_24, c0_.client_id AS client_id_25, c0_.shipping_address_id AS shipping_address_id_26 FROM cart c0_ WHERE c0_.sha = ?
Parameters: [
"db61982aa39c3d86f938c36a05813fe85b65610a"
]
SELECT c0_.id AS id_0, c0_.creation_date AS creation_date_1, c0_.creation_time AS creation_time_2, c0_.order_number AS order_number_3, c0_.purchase_date AS purchase_date_4, c0_.purchase_time AS purchase_time_5, c0_.total_products AS total_products_6, c0_.total_shipping AS total_shipping_7, c0_.commission AS commission_8, c0_.payment_type AS payment_type_9, c0_.payment_order AS payment_order_10, c0_.payment_gateway AS payment_gateway_11, c0_.payment_auth AS payment_auth_12, c0_.payment_status AS payment_status_13, c0_.courier AS courier_14, c0_.shipping_status AS shipping_status_15, c0_.sha AS sha_16, c0_.currency AS currency_17, c0_.status AS status_18, c0_.lang AS lang_19, c0_.items_details AS items_details_20, c0_.transaction_id AS transaction_id_21, c0_.connection_status AS connection_status_22, c0_.promo_code AS promo_code_23, c0_.sale_person_id AS sale_person_id_24, c0_.client_id AS client_id_25, c0_.shipping_address_id AS shipping_address_id_26 FROM cart c0_ WHERE c0_.sha = 'db61982aa39c3d86f938c36a05813fe85b65610a';
|
0.64 ms (11.60%)
|
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.additional_description AS additional_description_3, t0.stock AS stock_4, t0.layout_type AS layout_type_5, t0.status AS status_6, t0.data AS data_7, t0.location AS location_8, t0.notes AS notes_9, t0.is_new_piece AS is_new_piece_10, t0.palomita AS palomita_11, t0.require_agreed_shipping AS require_agreed_shipping_12, t0.product_id AS product_id_13, t0.main_picture_id AS main_picture_id_14, t0.square_picture_id AS square_picture_id_15 FROM variant t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.additional_description AS additional_description_3, t0.stock AS stock_4, t0.layout_type AS layout_type_5, t0.status AS status_6, t0.data AS data_7, t0.location AS location_8, t0.notes AS notes_9, t0.is_new_piece AS is_new_piece_10, t0.palomita AS palomita_11, t0.require_agreed_shipping AS require_agreed_shipping_12, t0.product_id AS product_id_13, t0.main_picture_id AS main_picture_id_14, t0.square_picture_id AS square_picture_id_15 FROM variant t0 WHERE t0.product_id = 3;
|
0.61 ms (10.89%)
|
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.labels AS labels_4, t0.priority AS priority_5 FROM tag t0 INNER JOIN tag_product ON t0.id = tag_product.tag_id WHERE tag_product.product_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.labels AS labels_4, t0.priority AS priority_5 FROM tag t0 INNER JOIN tag_product ON t0.id = tag_product.tag_id WHERE tag_product.product_id = 3;
|
0.55 ms (9.84%)
|
2 |
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.price AS price_3, t0.increase_coefficient AS increase_coefficient_4, t0.discount_coefficient AS discount_coefficient_5, t0.shipping_coefficient AS shipping_coefficient_6, t0.variant_id AS variant_id_7 FROM price t0 WHERE t0.variant_id = ?
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.price AS price_3, t0.increase_coefficient AS increase_coefficient_4, t0.discount_coefficient AS discount_coefficient_5, t0.shipping_coefficient AS shipping_coefficient_6, t0.variant_id AS variant_id_7 FROM price t0 WHERE t0.variant_id = 3;
|
0.52 ms (9.43%)
|
2 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.alt AS alt_4, t0.time AS time_5, t0.variant_id AS variant_id_6 FROM picture t0 WHERE t0.variant_id = ?
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.alt AS alt_4, t0.time AS time_5, t0.variant_id AS variant_id_6 FROM picture t0 WHERE t0.variant_id = 3;
|
0.37 ms (6.71%)
|
1 |
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.url = ?
Parameters: [
"bulldog-london"
]
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.url = 'bulldog-london';
|
0.30 ms (5.43%)
|
1 |
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.id = ?
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.id = '19';
|
0.21 ms (3.72%)
|
1 |
INSERT INTO jump (token, number, url_used, time, nav_token, origin) VALUES (?, ?, ?, ?, ?, ?)
Parameters: [
"db61982aa39c3d86f938c36a05813fe85b65610a"
2
"/productos/bulldog-london"
"1774736010"
"0992cbcae035961ff227dab11d278f69dbfc0fa2"
"no-set"
]
INSERT INTO jump (token, number, url_used, time, nav_token, origin) VALUES ('db61982aa39c3d86f938c36a05813fe85b65610a', 2, '/productos/bulldog-london', '1774736010', '0992cbcae035961ff227dab11d278f69dbfc0fa2', 'no-set');
|
0.14 ms (2.59%)
|
1 |
"COMMIT"
|
0.12 ms (2.23%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|