[ DB ] CONNECT:[ UseTime:0.001174s ] mysql:host=rm-bp1kz74dm2gx1nss9.mysql.rds.aliyuncs.com;port=3306;dbname=ipeh_trz_qs--prod;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_system_hook` [ RunTime:0.000888s ]
[ SQL ] SELECT `name`,`status` FROM `tp_system_hook` WHERE `status` = 1 [ RunTime:0.000535s ]
[ SQL ] SHOW COLUMNS FROM `tp_system_plugins` [ RunTime:0.000775s ]
[ SQL ] SELECT `name`,`status` FROM `tp_system_plugins` WHERE `status` = 2 [ RunTime:0.000493s ]
[ SQL ] SHOW COLUMNS FROM `tp_system_hook_plugins` [ RunTime:0.000740s ]
[ SQL ] SELECT `hook`,`plugins` FROM `tp_system_hook_plugins` WHERE `status` = 1 ORDER BY `sort` [ RunTime:0.000515s ]
[ SQL ] SHOW COLUMNS FROM `tp_system_module` [ RunTime:0.000774s ]
[ SQL ] SELECT * FROM `tp_system_module` WHERE `name` = 'datatrade' AND `status` = 2 LIMIT 1 [ RunTime:0.000618s ]
[ SQL ] SHOW COLUMNS FROM `tp_data_product_industry` [ RunTime:0.000728s ]
[ SQL ] SELECT `data_product_id` FROM `tp_data_product_industry` WHERE `industry_id` = 35 [ RunTime:0.000468s ]
[ SQL ] SHOW COLUMNS FROM `tp_data_product` [ RunTime:0.000883s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_data_product` WHERE `status` = 10 AND `show_site` = 'zh-cn' AND `check_status` = 1 AND `is_on_sell` = 1 AND `id` IN (77954,77955,77956,77958,77957,77960,77962,77975,77977,77978) AND `genre_id` = 59 [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `tp_data_product` WHERE `status` = 10 AND `show_site` = 'zh-cn' AND `check_status` = 1 AND `is_on_sell` = 1 AND `id` IN (77954,77955,77956,77958,77957,77960,77962,77975,77977,77978) AND `genre_id` = 59 ORDER BY `is_recommend` DESC,`sort_id` DESC,`created_at` DESC LIMIT 0,12 [ RunTime:0.001054s ]
[ SQL ] SHOW COLUMNS FROM `tp_industry` [ RunTime:0.000754s ]
[ SQL ] SELECT `tp_industry`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`data_product_id` AS `pivot__data_product_id`,`pivot`.`industry_id` AS `pivot__industry_id` FROM `tp_industry` INNER JOIN `tp_data_product_industry` `pivot` ON `pivot`.`industry_id`=`tp_industry`.`id` WHERE `pivot`.`data_product_id` IN (77978,77977,77975,77960,77957) [ RunTime:0.000607s ]
[ SQL ] SHOW COLUMNS FROM `tp_genre` [ RunTime:0.000735s ]
[ SQL ] SELECT `name` FROM `tp_genre` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000474s ]
[ SQL ] SHOW COLUMNS FROM `tp_data_provider` [ RunTime:0.000705s ]
[ SQL ] SELECT `name` FROM `tp_data_provider` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SHOW COLUMNS FROM `tp_data_product_img` [ RunTime:0.000678s ]
[ SQL ] SELECT `img_path` FROM `tp_data_product_img` WHERE `data_product_id` = 77978 AND `is_base` = 1 LIMIT 1 [ RunTime:0.000511s ]
[ SQL ] SHOW COLUMNS FROM `tp_data_product_spec` [ RunTime:0.000834s ]
[ SQL ] SELECT `spec_name` FROM `tp_data_product_spec` WHERE `is_main` = 1 AND `data_product_id` = 77978 LIMIT 1 [ RunTime:0.000459s ]
[ SQL ] SELECT `name` FROM `tp_genre` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000505s ]
[ SQL ] SELECT `name` FROM `tp_data_provider` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000527s ]
[ SQL ] SELECT `img_path` FROM `tp_data_product_img` WHERE `data_product_id` = 77977 AND `is_base` = 1 LIMIT 1 [ RunTime:0.000516s ]
[ SQL ] SELECT `spec_name` FROM `tp_data_product_spec` WHERE `is_main` = 1 AND `data_product_id` = 77977 LIMIT 1 [ RunTime:0.000490s ]
[ SQL ] SELECT `name` FROM `tp_genre` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000453s ]
[ SQL ] SELECT `name` FROM `tp_data_provider` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000477s ]
[ SQL ] SELECT `img_path` FROM `tp_data_product_img` WHERE `data_product_id` = 77975 AND `is_base` = 1 LIMIT 1 [ RunTime:0.000483s ]
[ SQL ] SELECT `spec_name` FROM `tp_data_product_spec` WHERE `is_main` = 1 AND `data_product_id` = 77975 LIMIT 1 [ RunTime:0.000485s ]
[ SQL ] SELECT `name` FROM `tp_genre` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] SELECT `name` FROM `tp_data_provider` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000480s ]
[ SQL ] SELECT `img_path` FROM `tp_data_product_img` WHERE `data_product_id` = 77960 AND `is_base` = 1 LIMIT 1 [ RunTime:0.000510s ]
[ SQL ] SELECT `spec_name` FROM `tp_data_product_spec` WHERE `is_main` = 1 AND `data_product_id` = 77960 LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SELECT `name` FROM `tp_genre` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000502s ]
[ SQL ] SELECT `name` FROM `tp_data_provider` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SELECT `img_path` FROM `tp_data_product_img` WHERE `data_product_id` = 77957 AND `is_base` = 1 LIMIT 1 [ RunTime:0.000510s ]
[ SQL ] SELECT `spec_name` FROM `tp_data_product_spec` WHERE `is_main` = 1 AND `data_product_id` = 77957 LIMIT 1 [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `tp_genre` WHERE ( type = 10 and isuse = 1 ) ORDER BY `serial` ASC [ RunTime:0.000568s ]
[ SQL ] SELECT * FROM `tp_industry` WHERE ( type = 10 and isuse = 1 ) ORDER BY `serial` ASC [ RunTime:0.000554s ]
