[ DB ] CONNECT:[ UseTime:0.009189s ] mysql:host=database-1.cm7muvhyh9j7.us-east-2.rds.amazonaws.com;port=3306;dbname=edifier_web_foreign;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `site` [ RunTime:0.008764s ]
[ SQL ] SELECT * FROM `site` WHERE `status` = 1 [ RunTime:0.019438s ]
[ SQL ] SHOW COLUMNS FROM `language` [ RunTime:0.011330s ]
[ SQL ] SELECT `mark` FROM `language` WHERE `status` = 1 [ RunTime:0.011158s ]
[ SQL ] SHOW COLUMNS FROM `media` [ RunTime:0.011323s ]
[ SQL ] SELECT * FROM `media` WHERE `siteid` = 66 [ RunTime:0.007103s ]
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.006485s ]
[ SQL ] SELECT `value` FROM `config` WHERE `siteid` = 66 AND `name` = 'recommended' LIMIT 1 [ RunTime:0.038545s ]
[ SQL ] SELECT `value` FROM `config` WHERE `siteid` = 66 AND `name` = 'email_img1' LIMIT 1 [ RunTime:0.043911s ]
[ SQL ] SELECT `value` FROM `config` WHERE `siteid` = 66 AND `name` = 'email_img_webp' LIMIT 1 [ RunTime:0.052124s ]
[ SQL ] SELECT `value` FROM `config` WHERE `siteid` = 66 AND `name` = 'show_newsletter' LIMIT 1 [ RunTime:0.055767s ]
[ SQL ] SELECT `name`,`value` FROM `config` WHERE `siteid` = 66 [ RunTime:0.075763s ]
[ SQL ] SELECT * FROM `site` WHERE `sitedir` = 'ca' LIMIT 1 [ RunTime:0.006349s ]
[ SQL ] SHOW COLUMNS FROM `cache` [ RunTime:0.006778s ]
[ SQL ] SELECT * FROM `cache` WHERE `key` = 'ProductDetail_data_true-wireless-earbuds_w320tn_66' ORDER BY `id` DESC [ RunTime:0.011328s ]
[ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.008366s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.007059s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.009275s ]
[ SQL ] SELECT `product`.`id`,`product`.`catid`,`product`.`productdir`,`product`.`thumb`,`product`.`video_url`,`product`.`attr`,`product`.`background1`,`product`.`background2`,`product`.`updatetime`,`product`.`thumb_webp`,`product`.`spec_highlight`,`product_data`.`seotitle`,`product_data`.`keywords`,`product_data`.`description`,`product_data`.`canonical`,`product_data`.`shop_link`,`product_data`.`is_shop`,`product_data`.`title`,`product_data`.`content`,`product_data`.`intro`,`product_data`.`product_des`,`product_data`.`tags`,`category`.`catdir` FROM `product` LEFT JOIN `product_data` ON `product`.`id`=`product_data`.`did` LEFT JOIN `category` ON `product`.`catid`=`category`.`id` WHERE `product`.`sites` = 66 AND `product`.`status` = 1 AND `product`.`productdir` = 'w320tn' AND `product`.`catid` = 6 LIMIT 1 [ RunTime:0.541617s ]
[ SQL ] SHOW COLUMNS FROM `product_attr` [ RunTime:0.024881s ]
[ SQL ] SELECT `a`.`id`,`a`.`attr_type`,`a`.`name`,`a`.`bgcolor`,`a`.`textcolor`,`a`.`value`,`a`.`image`,`a`.`other_data`,`a`.`remake`,`a`.`alt`,`a`.`listorder`,`a`.`video_image_url`,`a`.`video_image_mobile_url`,`a`.`media_type`,`a`.`relate_id`,`a`.`image_webp`,`b`.`spec_name`,`b`.`lang_code`,`c`.`group_name`,c.lang_code as group_lang_code,ifnull(c.listorder, 9999) as group_listorder,case when a.value = "" then 0 else 1 end as value_show,ifnull(b.spec_group_id, 0) as spec_group_id FROM `product_attr` `a` LEFT JOIN `product_spec` `b` ON `a`.`relate_id`=b.id and b.delete_time is null LEFT JOIN `product_spec_group` `c` ON `b`.`spec_group_id`=c.id and c.delete_time is null WHERE `a`.`did` = 8583 AND `a`.`attr_type` = 'Specification' ORDER BY `value_show` DESC,`group_listorder` ASC,`c`.`id` ASC,`b`.`id` ASC,`a`.`listorder` ASC,`a`.`id` ASC [ RunTime:5.087301s ]
[ SQL ] SHOW COLUMNS FROM `product_sku` [ RunTime:0.009249s ]
[ SQL ] SELECT * FROM `product_sku` WHERE `product_id` = 8583 [ RunTime:0.007355s ]
[ SQL ] SELECT * FROM `site` WHERE ( `alone` = 1 AND `private` = 1 AND `status` = 1 ) OR `sitedir` = 'global' [ RunTime:0.008638s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.006081s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005447s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.007439s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.007905s ]
[ SQL ] SELECT * FROM `cache` WHERE `key` = 'hreflang_ProductDetail_data_true-wireless-earbuds_w320tn_82' ORDER BY `id` DESC [ RunTime:0.007784s ]
[ SQL ] SELECT `product`.`id`,`product`.`catid`,`product`.`productdir` FROM `product` LEFT JOIN `product_data` ON `product`.`id`=`product_data`.`did` LEFT JOIN `category` ON `product`.`catid`=`category`.`id` WHERE `product`.`sites` = 82 AND `product`.`status` = 1 AND `product`.`productdir` = 'w320tn' AND `product`.`catid` = 6 LIMIT 1 [ RunTime:0.350258s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005504s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.006173s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005560s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.002594s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.006737s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.009806s ]
[ SQL ] SELECT * FROM `cache` WHERE `key` = 'hreflang_ProductDetail_data_true-wireless-earbuds_w320tn_111' ORDER BY `id` DESC [ RunTime:0.001740s ]
[ SQL ] SELECT `product`.`id`,`product`.`catid`,`product`.`productdir` FROM `product` LEFT JOIN `product_data` ON `product`.`id`=`product_data`.`did` LEFT JOIN `category` ON `product`.`catid`=`category`.`id` WHERE `product`.`sites` = 111 AND `product`.`status` = 1 AND `product`.`productdir` = 'w320tn' AND `product`.`catid` = 6 LIMIT 1 [ RunTime:0.109872s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005362s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.001959s ]
[ SQL ] SELECT * FROM `cache` WHERE `key` = 'hreflang_ProductDetail_data_true-wireless-earbuds_w320tn_124' ORDER BY `id` DESC [ RunTime:0.007322s ]
[ SQL ] SELECT `product`.`id`,`product`.`catid`,`product`.`productdir` FROM `product` LEFT JOIN `product_data` ON `product`.`id`=`product_data`.`did` LEFT JOIN `category` ON `product`.`catid`=`category`.`id` WHERE `product`.`sites` = 124 AND `product`.`status` = 1 AND `product`.`productdir` = 'w320tn' AND `product`.`catid` = 6 LIMIT 1 [ RunTime:0.155008s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.003244s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.004304s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.008051s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.007625s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.004623s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.006468s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.004932s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005347s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.004768s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.009574s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.005202s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.006732s ]
[ SQL ] SELECT * FROM `category` WHERE `catdir` = 'true-wireless-earbuds' LIMIT 1 [ RunTime:0.004975s ]
