[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_nav` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_nav` WHERE ( pid=0 and isdel=0 and hide=1 ) ORDER BY `id` ASC,`sort` ASC LIMIT 0,4 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_news` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_news` WHERE ( pid=38 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_news` WHERE ( pid=40 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_news` WHERE ( pid=41 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_news` WHERE ( pid=44 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_slider` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_slider` WHERE ( type=6 ) ORDER BY `sort` DESC,`id` DESC LIMIT 0,2 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_type` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `yb_type` WHERE ( hide=1 and pid=19 ) ORDER BY `sort` DESC,`id` DESC LIMIT 0,2 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_goodsnav` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=0 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=103 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=107 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=108 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=109 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=110 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=111 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=112 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=123 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_cart` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_cart` WHERE ( cus_id=0 and isbuy=0 and isdel=0 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_users` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_users` WHERE ( id=0 ) LIMIT 1 [ RunTime:0.015625s ]
[ SQL ] SHOW COLUMNS FROM `yb_goods` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( isdel=0 and hide=1 and type=1 and id=120 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( isdel=0 and hide=1 and type=1 and id=108 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( isdel=0 and hide=1 and type=2 and id=140 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_news` WHERE ( isPass=1 and isDel=0 and pid=44 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_goodscombo` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goodscombo` WHERE ( hide=1 and barcode='LA-JWYS-M712-1.8CT' and synccode=20220419161700324 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goodscombo` WHERE ( hide=1 and synccode=20220419161700324 and cp_gg<>'' ) GROUP BY `cp_gg` ORDER BY `id` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id` FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and barcode='LA-JWYS-M712-1.4CT' ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `id` FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and barcode='LA-JWYS-M712-1.6CT' ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `id` FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and barcode='LA-JWYS-M712-1.8CT' ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goodscombo` WHERE ( hide=1 and synccode=20220419161700324 and cp_cz<>'' and cp_gg='1.8米' ) GROUP BY `cp_cz` ORDER BY `id` ASC [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `yb_goodscombo` WHERE ( hide=1 and synccode=20220419161700324 and cp_ys<>'' ) ORDER BY `id` ASC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_match` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `yb_match` WHERE ( pass=1 and type=1 and id=488 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `yb_matchlist` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_matchlist` WHERE ( mid=488 and cid<>13266 ) GROUP BY `bignav` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_matchlist` WHERE ( mid=488 and bignav=108 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_matchlist` WHERE ( mid=488 and bignav=108 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and id=13265 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and id=13264 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and id=13304 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and pinpid=140 and goodsid=120 ) ORDER BY `issy` DESC,`isjp` DESC,`isnew` DESC,`isrm` DESC,`sort` DESC LIMIT 0,9 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` WHERE ( isdel=0 and ispass=1 and issale=1 and goodsid=120 ) ORDER BY `isrm` DESC,`hits` DESC,`issy` DESC,`isjp` DESC,`isnew` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.015625s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_property` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_property` WHERE ( hide=1 and id in (1,2,21,22,23,24,25,26) ) ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_goodscomment` [ RunTime:0.000000s ]
[ SQL ] SELECT AVG(`score`) AS tp_avg FROM `yb_goodscomment` WHERE ( g_id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT * FROM `yb_goodscomment` WHERE ( g_id=13266 ) [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_goodscomment` WHERE ( g_id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yb_order_mx` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_order_mx` WHERE ( cp_id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.cp_type in(3) ) ORDER BY `a`.`id` DESC LIMIT 0,6 [ RunTime:0.000000s ]
[ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=108 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `title` FROM `yb_property` WHERE ( id=11 ) LIMIT 1 [ RunTime:0.015625s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_2` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_21` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_22` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_23` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_24` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_25` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `title` FROM `yb_property` WHERE ( id=11 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_2` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_21` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_22` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_23` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_24` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_25` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
[ SQL ] SELECT `cs_26` FROM `yb_goods` WHERE ( id=13266 ) LIMIT 1 [ RunTime:0.000000s ]