SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002122s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000643s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003555s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002153s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000332s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (2475,2518,2568) AND `id` > 799 [ RunTime:0.004500s ]
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.001644s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002449s ]
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.005991s ]
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.000926s ]
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.000711s ]
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.000707s ]
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.000847s ]
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.000683s ]
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.000773s ]
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.000596s ]
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.000534s ]
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.000497s ]
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.000527s ]
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.000491s ]
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.000622s ]
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.000577s ]
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.000601s ]
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.000591s ]
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.000508s ]
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.000499s ]
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.000494s ]
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.000655s ]
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.000672s ]
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.000573s ]
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.000529s ]
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.000535s ]
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.000535s ]
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.000530s ]
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.000495s ]
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.000492s ]
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.000810s ]
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.000833s ]
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.000637s ]
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.000601s ]
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.000618s ]
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.000606s ]
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.000585s ]
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.000582s ]
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.000604s ]
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.000665s ]
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.000637s ]
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.000589s ]
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.000644s ]
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.000619s ]
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.000593s ]
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.000581s ]
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.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` = '728' ORDER BY `s`.`id` DESC LIMIT 10 [ RunTime:0.002303s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.002083s ]
SELECT `id`,`typeid`,`title` FROM `news` WHERE `typeid` <> 433 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `stock_brand` [ RunTime:0.002133s ]
SELECT `id`,`brandshort`,`Logo`,`LogoNew` FROM `stock_brand` WHERE ( ( `type` = 1 OR `type` = 3 ) ) LIMIT 20 [ RunTime:0.000663s ]