SHOW FULL COLUMNS FROM `xf_settings` [ RunTime:0.001840s ]
SELECT `value`,`key_name` FROM `xf_settings` [ RunTime:0.001174s ]
SHOW FULL COLUMNS FROM `xf_products` [ RunTime:0.001914s ]
SELECT `p`.*,`s`.`shop_name`,s.logo shop_logo,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`.`id` = '30' LIMIT 1 [ RunTime:0.002423s ]
SHOW FULL COLUMNS FROM `xf_product_images` [ RunTime:0.001637s ]
SELECT * FROM `xf_product_images` WHERE `product_id` = '30' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001152s ]
SHOW FULL COLUMNS FROM `xf_product_specs` [ RunTime:0.001951s ]
SELECT * FROM `xf_product_specs` WHERE `product_id` = '30' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001826s ]
SHOW FULL COLUMNS FROM `xf_product_skus` [ RunTime:0.003554s ]
SELECT * FROM `xf_product_skus` WHERE `product_id` = '30' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001711s ]
SELECT `p`.*,`s`.`shop_name`,s.logo shop_logo,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`.`id` <> '30' AND `p`.`category_id` = '35' ORDER BY `p`.`published_at` DESC,`p`.`id` DESC LIMIT 4 [ RunTime:0.006900s ]
SHOW FULL COLUMNS FROM `xf_categories` [ RunTime:0.001673s ]
SELECT * FROM `xf_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000964s ]
SHOW FULL COLUMNS FROM `xf_product_categories` [ RunTime:0.001691s ]
SELECT * FROM `xf_product_categories` WHERE `status` = 1 ORDER BY `parent_id` ASC,`sort` ASC,`id` ASC [ RunTime:0.001109s ]