SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002452s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003136s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002559s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.147' ) [ RunTime:0.007785s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001862s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000766s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (2475,2518,2568) AND `id` > 799 [ RunTime:0.023359s ]
SELECT `id`,`typeid`,`name`,`typestr`,`order_number`,`productnum` FROM `product_type` WHERE `id` IN (49,50,51,52,53) OR `typeid` IN (49,50,51,52,53) ORDER BY `order_number` ASC [ RunTime:0.005720s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002592s ]
SELECT * FROM `stock` WHERE `categoryid` IN (608,711,720,676,644,49,615,50,671,696,645,721,646,718,722,621,51,665,698,674,643,647,52,723,648,675,636,724,53,699,725,673,700,649,623,650,701,604,669,726,727,651,702,667,603,703,611,668,652,728,653,612,666,704,729,730,613,654,705,670,614,655,706,661,731,707,672,732,656,605,616,708,733,663,657,617,664,734,709,658,735,710,618,659,662,619,736,660,695,737,677,712,620,738,606,713,678,622,679,739,714,610,740,715,680,741,681,624,716,682,717,742,625,683,626,697,627,719,684,685,628,686,629,630,687,688,631,689,632,690,633,691,634,635,692,693,607,637,694,638,639,640,641,642,609) ORDER BY `id` DESC LIMIT 24 [ RunTime:0.013504s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '608' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.013283s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '615' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004051s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '621' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000803s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '643' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001501s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '636' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.009129s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '623' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004604s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '604' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003860s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '603' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001677s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '611' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004359s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '644' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.004163s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '645' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003066s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '646' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.009364s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '647' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002157s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '648' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.014870s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '649' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.006285s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '650' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004152s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '651' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003463s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '652' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001943s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '676' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.002718s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '671' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001196s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '665' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.015144s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '674' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.010020s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '675' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.007682s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '673' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001008s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '669' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.011381s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '667' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.001445s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '668' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.006399s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '711' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.017592s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '696' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003578s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '718' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003327s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '698' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000885s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '699' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.006964s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '700' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.030880s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '701' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.012038s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '702' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.012310s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '703' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.005018s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '720' ORDER BY `s`.`id` DESC LIMIT 5 [ RunTime:0.010252s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '721' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.009380s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '722' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004989s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '723' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.000590s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '724' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.013125s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '725' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.011086s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '726' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.003208s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '727' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002605s ]
SELECT `s`.`id`,s.partno name,`s`.`categoryid`,`s`.`imgurl`,s.minOrderPrice as marketPrice,`u`.`city` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` WHERE `s`.`categoryid` = '728' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.004484s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.001437s ]
SELECT `id`,`typeid`,`title` FROM `news` WHERE `typeid` <> 433 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.004472s ]
SHOW FULL COLUMNS FROM `stock_brand` [ RunTime:0.001497s ]
SELECT `id`,`brandshort`,`Logo`,`LogoNew` FROM `stock_brand` WHERE ( ( `type` = 1 OR `type` = 3 ) ) LIMIT 20 [ RunTime:0.012395s ]