23.29 ms (22.94%)
|
59 |
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.included_by WHERE marketplace_includes.code = ?
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.included_by WHERE marketplace_includes.code = 10147;
|
22.42 ms (22.08%)
|
59 |
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.excluded_by WHERE marketplace_excludes.code = ?
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.excluded_by WHERE marketplace_excludes.code = 10147;
|
21.97 ms (21.64%)
|
59 |
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.code WHERE marketplace_includes.included_by = ?
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.code WHERE marketplace_includes.included_by = 10147;
|
21.93 ms (21.60%)
|
59 |
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.code WHERE marketplace_excludes.excluded_by = ?
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.code WHERE marketplace_excludes.excluded_by = 10147;
|
9.56 ms (9.41%)
|
20 |
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN company_variants_marketplace ON t0.code = company_variants_marketplace.marketplace WHERE company_variants_marketplace.variant = ?
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN company_variants_marketplace ON t0.code = company_variants_marketplace.marketplace WHERE company_variants_marketplace.variant = 11;
|
1.87 ms (1.84%)
|
1 |
SELECT m0_.code AS code_0, m0_.sort_order AS sort_order_1, m0_.hid AS hid_2, m0_.name AS name_3, m0_.description AS description_4, m0_.text AS text_5, m0_.created AS created_6, m0_.changed AS changed_7, m0_.ip AS ip_8, m1_.code AS code_9, m1_.sort_order AS sort_order_10, m1_.hid AS hid_11, m1_.choosable AS choosable_12, m1_.name AS name_13, m1_.description AS description_14, m1_.text AS text_15, m1_.price_excl_vat AS price_excl_vat_16, m1_.price_incl_vat AS price_incl_vat_17, m1_.price_description AS price_description_18, m1_.created AS created_19, m1_.changed AS changed_20, m1_.ip AS ip_21 FROM marketplace_category m0_ LEFT JOIN marketplaces_categories m2_ ON m0_.code = m2_.category_code LEFT JOIN marketplace m1_ ON m1_.code = m2_.marketplace_code ORDER BY m0_.sort_order ASC, m1_.sort_order ASC
SELECT m0_.code AS code_0, m0_.sort_order AS sort_order_1, m0_.hid AS hid_2, m0_.name AS name_3, m0_.description AS description_4, m0_.text AS text_5, m0_.created AS created_6, m0_.changed AS changed_7, m0_.ip AS ip_8, m1_.code AS code_9, m1_.sort_order AS sort_order_10, m1_.hid AS hid_11, m1_.choosable AS choosable_12, m1_.name AS name_13, m1_.description AS description_14, m1_.text AS text_15, m1_.price_excl_vat AS price_excl_vat_16, m1_.price_incl_vat AS price_incl_vat_17, m1_.price_description AS price_description_18, m1_.created AS created_19, m1_.changed AS changed_20, m1_.ip AS ip_21 FROM marketplace_category m0_ LEFT JOIN marketplaces_categories m2_ ON m0_.code = m2_.category_code LEFT JOIN marketplace m1_ ON m1_.code = m2_.marketplace_code ORDER BY m0_.sort_order ASC, m1_.sort_order ASC;
|
0.50 ms (0.50%)
|
1 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.created AS created_3, t0.changed AS changed_4, t0.ip AS ip_5 FROM company_variants t0 ORDER BY t0.code ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.created AS created_3, t0.changed AS changed_4, t0.ip AS ip_5 FROM company_variants t0 ORDER BY t0.code ASC;
|