|
0.0003 s
|
|
|
|
0.0001 s
|
|
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 1))
Params: blog/lala-curio-events/paris-blog.html, blog/lala-curio-events/paris-blog.html/
|
|
0.0009 s
|
|
SHOW TABLE STATUS LIKE 'core_session'
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `core_session`.`session_data` FROM `core_session` WHERE (session_id = :session_id) AND (session_expires > :session_expires)
Params: 6lvjfucnni3gnhkdtqn68eitm5, 1560901278
|
|
0.0003 s
|
SELECT
EXPLAIN
|
SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL)
Params: 1, 2019-06-18 23:41:18
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `core_translate`.`string`, `core_translate`.`translate` FROM `core_translate` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC
Params: en_US, 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category')
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='252')
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id=3) AND (entity_attribute.attribute_set_id = '3') ORDER BY entity_attribute.sort_order ASC
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `attr_table`.* FROM `catalog_category_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
|
|
|
0.0002 s
|
|
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?)
Params: 6lvjfucnni3gnhkdtqn68eitm5, 2019-06-18 23:41:18, 2019-06-18 23:41:18, 0, 1
|
|
0.0019 s
|
|
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =252)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `attr_table`.* FROM `catalog_category_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '252') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('252', '246', '244', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (252, 246, 244, 2)) AND (t_d.attribute_id IN ('58', '61')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d`
LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (252, 246, 244, 2)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d`
LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (252, 246, 244, 2)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d`
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (252, 246, 244, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `a`.`attribute_id`, `t`.* FROM `eav_attribute` AS `a`
INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (entity_type_code = :catalog_category) AND (attribute_code = :is_active)
Params: catalog_category, is_active
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
Params: 42, 1, 1, 1/2/244/246/252/%
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, alothemesdefault
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, default
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, catalog_category_layered_nochildren
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, STORE_english
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, THEME_frontend_alogg_default
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, catalog_category_view
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, MAP_popup
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, SHORTCUT_popup
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, SHORTCUT_uk_popup
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, catalog_category_default
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, CATEGORY_252
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, customer_logged_out
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('244', '246', '252')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (244, 246, 252)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/244') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/246') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/252') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `main_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_for_sort_by = 1)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =246)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `attr_table`.* FROM `catalog_category_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '246') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '246') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '246') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '246') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '246') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='support-mobile') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 7
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id)
Params: 2
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2')
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163'))
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `a`.`attribute_id`, `t`.* FROM `eav_attribute` AS `a`
INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (entity_type_code = :entity_type_code) AND (attribute_code = :attribute_code)
Params: catalog_category, is_active
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `d`.`entity_id` FROM `catalog_category_entity_int` AS `d`
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id WHERE (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (d.entity_id IN ('3', '15', '29', '30', '34', '37', '38', '39', '57', '58', '59', '60', '61', '62', '66', '67', '69', '70', '71', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '148', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '162', '163', '164', '167', '168', '169', '170', '171', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '202', '204', '205', '206', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '240', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '257', '258', '260')) AND (IF(c.value_id > 0, c.value, d.value) = :cond)
Params: 42, 1, 0, 0
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163'))
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1)
LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163')) AND (`e`.`entity_id` NOT IN('58', '59', '61', '62', '112', '175', '199', '255')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
|
|
0.0002 s
|
SELECT
EXPLAIN
|
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (3, 15, 29, 30, 34, 37, 38, 39, 57, 60, 66, 67, 69, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 111, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 150, 151, 152, 153, 154, 155, 156, 157, 158, 161, 162, 163, 211, 213, 214, 215, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 257, 258)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`='151') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 151
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='image') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 20
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_bottom') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 8
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='newsletter') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 30
|
|
0.0001 s
|
SELECT
EXPLAIN
|
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='paypal') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
![[TR]](http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/skin/frontend/alogg/default/images/fam_book_open.png)