sulje
Cart

https://meccofi.mydevfactory.com/blog

  • Controller Module: Magefan_Blog
  • Controller Class: Magefan\Blog\Controller\Index\Index
  • Controller Action Name: execute

Database Queries

Nimi Arvo
Executed 95 queries in 0.062 s
Total Queries 95
Insert queries 0
Update queries 1
Read queries 94
Delete queries 0
Tapahtumat 2

Top 5 - Slowest Queries

Query Time (ms) 
              SET NAMES utf8
9.799E-5 
              SELECT RELEASE_LOCK(?);
0.000144 
              commit
0.00014901 
              SELECT GET_LOCK(?, ?);
0.00017691 
              SELECT RELEASE_LOCK(?);
0.00018597

All Queries

Query Time (ms) 
              connect
0.00065804 
              SET NAMES utf8
9.799E-5 
              SELECT `store_website`.* FROM `store_website`
0.00032902 
              SELECT `store_group`.* FROM `store_group`
0.00026393 
              SELECT `store`.* FROM `store`
0.00035214 
              SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')
0.00052714 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('blog', 'blog/')) AND (`store_id` IN ('1'))
0.00058389 
              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
 LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('blog', 'blog/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)
0.000489 
              SELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC
0.00047398 
              SELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC
0.00044513 
              SELECT `stripe_account`.* FROM `stripe_account` WHERE (`stripe_account`.`secret_key`='5019875dbc8498db66c046f9ca36113fe18f39ba5c4852a0ac1243ae95ad0c71')
0.00050688 
              begin
0.00022197 
              UPDATE `stripe_account` SET `is_valid` = ? WHERE (id=3)
0.00046992 
              commit
0.00014901 
              SELECT COUNT(*) FROM `stripe_customers` AS `main_table` WHERE (`session_id` = 'hfvcph2i32pin732qb8hl6besu') AND ((`pk` = 'pk_live_51SQ4XoEQhpkV25H3GqHUxNYPTPnrp66C8wr6gGvy7fW1OA1hSJdK794pNmEiRY2cgD1FaebjJ6lTihnYeQ1gcNhn00Vx66HU8g') OR (`pk` IS NULL))
0.00075412 
              SELECT `layout_update`.`xml`, `layout_update`.`handle` FROM `layout_update`
 INNER JOIN `layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.theme_id = :theme_id) AND (link.is_temporary = 0) ORDER BY `layout_update`.`sort_order` ASC
0.00064778 
              SELECT COUNT(DISTINCT main_table.post_id) FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (`include_in_recent` = '1') AND (store_table.store_id IN('1', 0))
0.00099683 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2')
0.00055885 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '2')
0.00052691 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.0016191 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '2') LIMIT 1
0.00045085 
              SELECT `main_table`.* FROM `checkout_agreement` AS `main_table`
 INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id WHERE (store_table_1.store_id IN ('1', 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id`
0.00070405 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='page_menu') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00075197 
              SELECT `main_table`.* FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (`include_in_recent` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`post_id` ORDER BY publish_time DESC, main_table.post_id DESC
 LIMIT 10
0.00142002 
              SELECT `cps`.* FROM `magefan_blog_post_store` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3'))
0.00057411 
              SELECT `cps`.* FROM `magefan_blog_post_category` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3'))
0.00056005 
              SELECT `cps`.* FROM `magefan_blog_post_tag` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3'))
0.0003438 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00695205 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.00077391 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00071883 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.000422 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('8')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00054407 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8'))
0.00033879 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00053906 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.00027108 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.0004642 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.00029016 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('8')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00048399 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8'))
0.00031614 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00052285 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.00030494 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00045609 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('9'))
0.00034189 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('8', '9')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00065088 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8', '9'))
0.00026298 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`main_table`.`category_id` IN('8')) AND (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00044298 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8'))
0.00028992 
              SELECT GET_LOCK(?, ?);
0.00032091 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
 INNER JOIN `magefan_blog_category_store` AS `store_table` ON main_table.category_id = store_table.category_id WHERE (`is_active` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`category_id` ORDER BY position DESC
0.00085998 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8', '9'))
0.00044394 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
0.00049996 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8', '9'))
0.00036097 
              SELECT COUNT(DISTINCT main_table.post_id, main_table.post_id) FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id
 INNER JOIN `magefan_blog_post_category` AS `category_table` ON main_table.post_id = category_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (store_table.store_id IN('1', 0)) AND (category_table.category_id IN('8'))
0.00073981 
              SELECT `main_table`.* FROM `magefan_blog_category` AS `main_table`
0.00029302 
              SELECT `cps`.* FROM `magefan_blog_category_store` AS `cps` WHERE (cps.category_id IN ('8', '9'))
0.000283 
              SELECT COUNT(DISTINCT main_table.post_id, main_table.post_id) FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id
 INNER JOIN `magefan_blog_post_category` AS `category_table` ON main_table.post_id = category_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (store_table.store_id IN('1', 0)) AND (category_table.category_id IN('9'))
0.00054598 
              SELECT RELEASE_LOCK(?);
0.00020599 
              SELECT GET_LOCK(?, ?);
0.00023699 
              SELECT `main_table`.* FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (`main_table`.`post_id` IN(0)) AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`post_id` ORDER BY publish_time DESC, main_table.post_id DESC
0.0006032 
              SELECT RELEASE_LOCK(?);
0.00022507 
              SELECT GET_LOCK(?, ?);
0.00017691 
              SELECT `main_table`.* FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`post_id` ORDER BY views_count DESC
 LIMIT 2
0.0013051 
              SELECT `cps`.* FROM `magefan_blog_post_store` AS `cps` WHERE (cps.post_id IN ('15', '7'))
0.000458 
              SELECT `cps`.* FROM `magefan_blog_post_category` AS `cps` WHERE (cps.post_id IN ('15', '7'))
0.00041914 
              SELECT `cps`.* FROM `magefan_blog_post_tag` AS `cps` WHERE (cps.post_id IN ('15', '7'))
0.00030303 
              SELECT RELEASE_LOCK(?);
0.00022197 
              SELECT GET_LOCK(?, ?);
0.00024295 
              SELECT `main_table`.* FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:18') AND (store_table.store_id IN('1', 0)) GROUP BY CONCAT(YEAR(main_table.publish_time),"-",MONTH(main_table.publish_time)),
	`main_table`.`post_id` ORDER BY publish_time DESC, main_table.post_id DESC
0.00155902 
              SELECT `cps`.* FROM `magefan_blog_post_store` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3', '16', '18', '17', '13', '8', '12', '2', '14'))
0.00048804 
              SELECT `cps`.* FROM `magefan_blog_post_category` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3', '16', '18', '17', '13', '8', '12', '2', '14'))
0.00043988 
              SELECT `cps`.* FROM `magefan_blog_post_tag` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6', '4', '9', '15', '10', '3', '16', '18', '17', '13', '8', '12', '2', '14'))
0.00025487 
              SELECT RELEASE_LOCK(?);
0.000144 
              SELECT GET_LOCK(?, ?);
0.00019002 
              SELECT `main_table`.*, count(main_table.tag_id) AS `count` FROM `magefan_blog_tag` AS `main_table`
 LEFT JOIN `magefan_blog_post_tag` AS `pt` ON main_table.tag_id = pt.tag_id
 LEFT JOIN `magefan_blog_post` AS `p` ON p.post_id = pt.post_id
 LEFT JOIN `magefan_blog_post_store` AS `ps` ON p.post_id = ps.post_id
 INNER JOIN `magefan_blog_tag_store` AS `store_table` ON main_table.tag_id = store_table.tag_id WHERE (`main_table`.`is_active` = '1') AND (ps.store_id IN (0, 1)) AND (main_table.is_active = 1) AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`tag_id`,
	`main_table`.`tag_id` ORDER BY `count` DESC
 LIMIT 50
0.00687599 
              SELECT RELEASE_LOCK(?);
0.00029683 
              SELECT GET_LOCK(?, ?);
0.00024581 
              SELECT RELEASE_LOCK(?);
0.00018597 
              SELECT `cms_block`.`block_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_top') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00057793 
              SELECT `cms_block`.`block_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.00055099 
              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '51')
0.0004251 
              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
0.00050902 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =33)
0.00039601 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 33)
0.00039291 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00105381 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '33') LIMIT 1
0.00037599 
              SELECT `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 (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level)
0.00076699 
              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `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)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('10', '11', '12', '19', '20', '22', '4', '5')) ORDER BY `e`.`position` ASC
0.00122499 
              SELECT `t_d`.`attribute_id`, `e`.`entity_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`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 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 (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (43, 41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 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 (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 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 (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (51)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
0.0017612 
              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =21)
0.00042701 
              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 21)
0.00032902 
              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC
0.00116301 
              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '21') LIMIT 1
0.00045896 
              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
0.00044799 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer_links') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.00058699 
              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='payment') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
0.0005002 
              SELECT `main_table`.* FROM `magefan_blog_post` AS `main_table`
 INNER JOIN `magefan_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2026-11-04 16:55:19') AND (`include_in_recent` = '1') AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`post_id` ORDER BY publish_time DESC, main_table.post_id DESC
 LIMIT 5
0.00180006 
              SELECT `cps`.* FROM `magefan_blog_post_store` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6'))
0.0007 
              SELECT `cps`.* FROM `magefan_blog_post_category` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6'))
0.00050092 
              SELECT `cps`.* FROM `magefan_blog_post_tag` AS `cps` WHERE (cps.post_id IN ('19', '11', '5', '7', '6'))
0.00034308
Developer
2.4.5
0.89 s
14.00 MB
95 q / 0.062 s
Return to Site