We use cookies to operate this website and to improve its usability. Full details of what cookies are, why we use them and how you can manage them can be found by reading our
Privacy & Cookies page. Please note that by using this site you are consenting to the use of cookies.
[ DB ] CONNECT:[ UseTime:0.014338s ] mysql:host=47.111.145.171;dbname=demo_shanghaiamt;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.010101s ]
[ SQL ] SELECT * FROM `product` WHERE `status` = 1 AND `recommend` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 10 [ RunTime:0.009722s ]
[ SQL ] SHOW COLUMNS FROM `product_category` [ RunTime:0.009945s ]
[ SQL ] SELECT * FROM `product_category` WHERE `pid` = 0 [ RunTime:0.009561s ]
[ SQL ] SELECT * FROM `product` WHERE `recommend` = 1 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.009771s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product_category` `pc` LEFT JOIN `product` `p` ON `p`.`category_id`=`pc`.`id` LEFT JOIN `exhibitor` `e` ON `e`.`id`=`p`.`exhibitor_id` WHERE `p`.`status` = 1 AND `e`.`status` = 1 AND `p`.`expo_id` = '8' [ RunTime:0.009491s ]
[ SQL ] SELECT `p`.`image`,`p`.`title_cn`,`p`.`title_en`,`e`.`company_cn`,`e`.`company_en`,`e`.`booth_num`,`p`.`id`,`p`.`exhibitor_id` FROM `product_category` `pc` LEFT JOIN `product` `p` ON `p`.`category_id`=`pc`.`id` LEFT JOIN `exhibitor` `e` ON `e`.`id`=`p`.`exhibitor_id` WHERE `p`.`status` = 1 AND `e`.`status` = 1 AND `p`.`expo_id` = '8' ORDER BY `p`.`id` DESC LIMIT 120,30 [ RunTime:0.010100s ]
[ SQL ] SHOW COLUMNS FROM `exhibitor` [ RunTime:0.010107s ]
[ SQL ] SELECT country_id,count(country_id) as total FROM `exhibitor` WHERE `expo_id` = 8 AND `country_id` > 0 AND `status` = 1 GROUP BY `country_id` ORDER BY `total` DESC [ RunTime:0.009529s ]
