SHOW FULL COLUMNS FROM `xf_settings` [ RunTime:0.001404s ]
SELECT `value`,`key_name` FROM `xf_settings` [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `xf_product_categories` [ RunTime:0.000852s ]
SELECT * FROM `xf_product_categories` WHERE `parent_id` = '0' AND `status` = 1 ORDER BY `is_recommend` DESC,`sort` ASC,`id` ASC LIMIT 12 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `xf_products` [ RunTime:0.000940s ]
SELECT `p`.*,`s`.`shop_name`,s.status shop_status,c.name category_name FROM `xf_products` `p` LEFT JOIN `xf_shops` `s` ON `s`.`id`=`p`.`shop_id` LEFT JOIN `xf_product_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`status` = '2' AND `s`.`status` = '1' AND `p`.`deleted_at` IS NULL ORDER BY `p`.`published_at` DESC,`p`.`id` DESC LIMIT 8 [ RunTime:0.000570s ]
SELECT `id` FROM `xf_product_categories` WHERE `parent_id` = '3' AND `status` = 1 [ RunTime:0.000236s ]
SELECT `p`.*,`s`.`shop_name`,s.status shop_status,c.name category_name FROM `xf_products` `p` LEFT JOIN `xf_shops` `s` ON `s`.`id`=`p`.`shop_id` LEFT JOIN `xf_product_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`status` = '2' AND `s`.`status` = '1' AND `p`.`deleted_at` IS NULL AND `p`.`category_id` IN ('3','26','27','28','29','30','31') ORDER BY `p`.`is_recommend` DESC,`p`.`published_at` DESC,`p`.`id` DESC LIMIT 4 [ RunTime:0.000437s ]
SELECT `id` FROM `xf_product_categories` WHERE `parent_id` = '4' AND `status` = 1 [ RunTime:0.000279s ]
SELECT `p`.*,`s`.`shop_name`,s.status shop_status,c.name category_name FROM `xf_products` `p` LEFT JOIN `xf_shops` `s` ON `s`.`id`=`p`.`shop_id` LEFT JOIN `xf_product_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`status` = '2' AND `s`.`status` = '1' AND `p`.`deleted_at` IS NULL AND `p`.`category_id` IN ('4','32','33','34','35','36','37') ORDER BY `p`.`is_recommend` DESC,`p`.`published_at` DESC,`p`.`id` DESC LIMIT 4 [ RunTime:0.000342s ]
SELECT `id` FROM `xf_product_categories` WHERE `parent_id` = '8' AND `status` = 1 [ RunTime:0.000198s ]
SELECT `p`.*,`s`.`shop_name`,s.status shop_status,c.name category_name FROM `xf_products` `p` LEFT JOIN `xf_shops` `s` ON `s`.`id`=`p`.`shop_id` LEFT JOIN `xf_product_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`status` = '2' AND `s`.`status` = '1' AND `p`.`deleted_at` IS NULL AND `p`.`category_id` IN ('8','56','57','58','59','60','61') ORDER BY `p`.`is_recommend` DESC,`p`.`published_at` DESC,`p`.`id` DESC LIMIT 4 [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `xf_categories` [ RunTime:0.000716s ]
SELECT * FROM `xf_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000280s ]
SELECT * FROM `xf_product_categories` WHERE `status` = 1 ORDER BY `parent_id` ASC,`sort` ASC,`id` ASC [ RunTime:0.000356s ]