[ BEHAVIOR ] Run app\common\behavior\AppEnd @app_end [ RunTime:0.006952s ]
[ DB ] CONNECT:[ UseTime:0.022665s ] mysql:host=127.0.0.1;port=3306;dbname=db_2022_seemete;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tbl_product_category` [ RunTime:0.001853s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.002375s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 16 [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` IN (16,38) ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.000691s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.000601s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `path` LIKE '16-38-%' ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.000790s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tbl_product_category` WHERE `pid` = 38 LIMIT 1 [ RunTime:0.000453s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.000583s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_idx` [ RunTime:0.001289s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `id` FROM `tbl_product_category` WHERE `path` LIKE '16-38-%' AND `leaf` = 1 ) t2 ON t1.`catid`=t2.`id` LIMIT 1 [ RunTime:0.013897s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.000786s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product` [ RunTime:0.001473s ]
[ SQL ] SELECT `t1`.*,idx.`brandid`,idx.`catid` FROM `tbl_product` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `id` FROM `tbl_product_category` WHERE `path` LIKE '16-38-%' AND `leaf` = 1 ) t2 ON t1.`catid`=t2.`id` ORDER BY `id` ASC LIMIT 20,10 ) t2 ON (t1.`id`=t2.`id`) LEFT JOIN `tbl_product_idx` `idx` ON (t1.`id`=idx.`prodid`) [ RunTime:0.010796s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_discount` [ RunTime:0.001404s ]
[ SQL ] SELECT * FROM `tbl_product_discount` WHERE `status` = 1 ORDER BY `type` ASC [ RunTime:0.000781s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` = 38 [ RunTime:0.000596s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_brand` [ RunTime:0.001489s ]
[ SQL ] SELECT * FROM `tbl_product_brand` `t1` INNER JOIN `tbl_product_brand_data` `t2` ON (t1.id=t2.brandid AND t2.langid = 1) WHERE `id` IN (41,338,67) [ RunTime:0.002455s ]
[ SQL ] SELECT * FROM `tbl_product_category` `t1` INNER JOIN `tbl_product_category_data` `t2` ON (t1.id=t2.catid AND t2.langid = 1) WHERE `id` IN (276) [ RunTime:0.000594s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_price` [ RunTime:0.001465s ]
[ SQL ] SELECT * FROM `tbl_product_price` WHERE `prodid` IN (1082233,1082234,1082235,1082236,1082237,1082238,1082239,1082240,1082241,1082242) ORDER BY `prodid` ASC, `qty` ASC [ RunTime:0.002854s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_gallery` [ RunTime:0.001649s ]
[ SQL ] SELECT * FROM `tbl_product_gallery` WHERE `prodid` IN (1082233,1082234,1082235,1082236,1082237,1082238,1082239,1082240,1082241,1082242) ORDER BY `sort` ASC, `id` ASC [ RunTime:0.001836s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_attach` [ RunTime:0.001375s ]
[ SQL ] SELECT * FROM `tbl_product_attach` WHERE `prodid` IN (1082233,1082234,1082235,1082236,1082237,1082238,1082239,1082240,1082241,1082242) ORDER BY `sort` ASC, `id` ASC [ RunTime:0.001775s ]
[ SQL ] SHOW COLUMNS FROM `tbl_product_data` [ RunTime:0.001378s ]
[ SQL ] SELECT * FROM `tbl_product_data` WHERE `prodid` IN (1082233,1082234,1082235,1082236,1082237,1082238,1082239,1082240,1082241,1082242) [ RunTime:0.001136s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tbl_product_category` WHERE `pid` = 38 LIMIT 1 [ RunTime:0.000377s ]
[ DB ] CONNECT:[ UseTime:0.014765s ] mysql:host=127.0.0.1;port=3306;dbname=db_2022_seemete;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tbl_ad` [ RunTime:0.002650s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tbl_ad` WHERE `posid` = 2 AND `status` = 1 AND `starttime` <= 1715833817 AND `endtime` >= 1715833817 AND `langid` = 1 LIMIT 1 [ RunTime:0.001416s ]
[ SQL ] SELECT * FROM `tbl_ad` WHERE `posid` = 2 AND `status` = 1 AND `starttime` <= 1715833817 AND `endtime` >= 1715833817 AND `langid` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.000469s ]
[ SQL ] SHOW COLUMNS FROM `tbl_navigate` [ RunTime:0.001768s ]
[ SQL ] SELECT * FROM `tbl_navigate` WHERE `status` = 1 AND `langid` = 1 ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.001807s ]
[ SQL ] SHOW COLUMNS FROM `tbl_category` [ RunTime:0.001789s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 20 AND `langid` = 1 [ RunTime:0.001540s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 41 AND `langid` = 1 [ RunTime:0.000640s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 17 AND `langid` = 1 [ RunTime:0.000598s ]
[ SQL ] SELECT * FROM `tbl_navigate` WHERE `status` = 1 AND `langid` = 1 ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 20 AND `langid` = 1 [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 41 AND `langid` = 1 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 17 AND `langid` = 1 [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'shopping-guide' AND `langid` = 1 LIMIT 1 [ RunTime:0.000894s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 2 AND `langid` = 1 [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `depth` <= 3 AND `path` LIKE '1-2-%' AND `langid` = 1 ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.000728s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 6 AND `langid` = 1 [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 7 AND `langid` = 1 [ RunTime:0.000461s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 8 AND `langid` = 1 [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 10 AND `langid` = 1 [ RunTime:0.000486s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'pay-distribution' AND `langid` = 1 LIMIT 1 [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 3 AND `langid` = 1 [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `depth` <= 3 AND `path` LIKE '1-3-%' AND `langid` = 1 ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.000591s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 11 AND `langid` = 1 [ RunTime:0.000663s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'after-sales-service' AND `langid` = 1 LIMIT 1 [ RunTime:0.000754s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 4 AND `langid` = 1 [ RunTime:0.000715s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `depth` <= 3 AND `path` LIKE '1-4-%' AND `langid` = 1 ORDER BY `pid` ASC, `sort` ASC, `id` ASC [ RunTime:0.008941s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 14 AND `langid` = 1 [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 15 AND `langid` = 1 [ RunTime:0.000656s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'recruitment' AND `langid` = 1 LIMIT 1 [ RunTime:0.000812s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 16 AND `langid` = 1 [ RunTime:0.001074s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'company-profile' AND `langid` = 1 LIMIT 1 [ RunTime:0.000618s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 17 AND `langid` = 1 [ RunTime:0.001006s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `urlname` = 'qualification-honors' AND `langid` = 1 LIMIT 1 [ RunTime:0.000666s ]
[ SQL ] SELECT * FROM `tbl_category` WHERE `id` = 18 AND `langid` = 1 [ RunTime:0.000929s ]
[ SQL ] SHOW COLUMNS FROM `tbl_log_exec` [ RunTime:0.001724s ]