SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001559s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002625s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001650s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.217' ) [ RunTime:0.004768s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001204s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000245s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002062s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000204s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000819s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001148s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002526s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 8160,20 [ RunTime:0.052406s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('12229467','11149229','11169729','12231500','10483911','11418371','11161336','11944281','11230026','11999698','11946270','11533664','11495142','12136529','11229231','12230593','11167304','11482067','3653','6896') ORDER BY FIELD(s.id, 12229467,11149229,11169729,12231500,10483911,11418371,11161336,11944281,11230026,11999698,11946270,11533664,11495142,12136529,11229231,12230593,11167304,11482067,3653,6896) [ RunTime:0.012785s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12229467 LIMIT 4 [ RunTime:0.009853s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229467 ORDER BY `minOrder` ASC [ RunTime:0.009230s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12229467 ORDER BY `unit` DESC [ RunTime:0.009626s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12229467 LIMIT 2 [ RunTime:0.010513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229467 ORDER BY `minOrder` ASC [ RunTime:0.004525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11149229 LIMIT 4 [ RunTime:0.012061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149229 ORDER BY `minOrder` ASC [ RunTime:0.007104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11149229 ORDER BY `unit` DESC [ RunTime:0.002038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11149229 LIMIT 2 [ RunTime:0.007740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149229 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11169729 LIMIT 4 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11169729 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11169729 ORDER BY `unit` DESC [ RunTime:0.001052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11169729 LIMIT 2 [ RunTime:0.011748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11169729 ORDER BY `minOrder` ASC [ RunTime:0.003553s ]
select * from pdf where partno='RNF14FTD22K1' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12231500 LIMIT 4 [ RunTime:0.018339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231500 ORDER BY `minOrder` ASC [ RunTime:0.009947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12231500 ORDER BY `unit` DESC [ RunTime:0.009392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12231500 LIMIT 2 [ RunTime:0.011497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231500 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
select * from pdf where partno='HSMH-A100-L00J1' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.031813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10483911 LIMIT 4 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10483911 ORDER BY `minOrder` ASC [ RunTime:0.004762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10483911 ORDER BY `unit` DESC [ RunTime:0.008103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10483911 LIMIT 2 [ RunTime:0.017492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10483911 ORDER BY `minOrder` ASC [ RunTime:0.015273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418371 LIMIT 4 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418371 ORDER BY `minOrder` ASC [ RunTime:0.013568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418371 ORDER BY `unit` DESC [ RunTime:0.010300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418371 LIMIT 2 [ RunTime:0.004575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418371 ORDER BY `minOrder` ASC [ RunTime:0.004622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11161336 LIMIT 4 [ RunTime:0.009613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11161336 ORDER BY `minOrder` ASC [ RunTime:0.004747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11161336 ORDER BY `unit` DESC [ RunTime:0.005595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11161336 LIMIT 2 [ RunTime:0.003326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11161336 ORDER BY `minOrder` ASC [ RunTime:0.005217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944281 LIMIT 4 [ RunTime:0.006406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944281 ORDER BY `minOrder` ASC [ RunTime:0.009726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944281 ORDER BY `unit` DESC [ RunTime:0.006227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944281 LIMIT 2 [ RunTime:0.001033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944281 ORDER BY `minOrder` ASC [ RunTime:0.003879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11230026 LIMIT 4 [ RunTime:0.002210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230026 ORDER BY `minOrder` ASC [ RunTime:0.011326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11230026 ORDER BY `unit` DESC [ RunTime:0.012577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11230026 LIMIT 2 [ RunTime:0.002209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230026 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='HSML-A101-S00J1' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.003867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11999698 LIMIT 4 [ RunTime:0.015369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11999698 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11999698 ORDER BY `unit` DESC [ RunTime:0.008666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11999698 LIMIT 2 [ RunTime:0.010399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11999698 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11946270 LIMIT 4 [ RunTime:0.011566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11946270 ORDER BY `minOrder` ASC [ RunTime:0.009624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11946270 ORDER BY `unit` DESC [ RunTime:0.005709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11946270 LIMIT 2 [ RunTime:0.014661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11946270 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='MMZ1005S800CT000' and brandshort='TDK Corporation' limit 1 [ RunTime:0.004494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533664 LIMIT 4 [ RunTime:0.007352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533664 ORDER BY `minOrder` ASC [ RunTime:0.005899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11533664 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11533664 LIMIT 2 [ RunTime:0.005640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533664 ORDER BY `minOrder` ASC [ RunTime:0.007995s ]
select * from pdf where partno='0022152066' and brandshort='Molex' limit 1 [ RunTime:0.004612s ]
select foldpath,foldpath2,filename from pdf_file where id=823799 limit 1 [ RunTime:0.001448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495142 LIMIT 4 [ RunTime:0.001912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495142 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495142 ORDER BY `unit` DESC [ RunTime:0.008416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495142 LIMIT 2 [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495142 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12136529 LIMIT 4 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12136529 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12136529 ORDER BY `unit` DESC [ RunTime:0.003175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12136529 LIMIT 2 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12136529 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11229231 LIMIT 4 [ RunTime:0.004277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229231 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11229231 ORDER BY `unit` DESC [ RunTime:0.000756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11229231 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229231 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12230593 LIMIT 4 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12230593 ORDER BY `minOrder` ASC [ RunTime:0.004089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12230593 ORDER BY `unit` DESC [ RunTime:0.001474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12230593 LIMIT 2 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12230593 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11167304 LIMIT 4 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11167304 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11167304 ORDER BY `unit` DESC [ RunTime:0.000934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11167304 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11167304 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='CF14JT3K30' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.002640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482067 LIMIT 4 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482067 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482067 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482067 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482067 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
select * from pdf where partno='2169465012' and brandshort='Molex' limit 1 [ RunTime:0.001877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3653 LIMIT 4 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3653 ORDER BY `minOrder` ASC [ RunTime:0.001770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3653 ORDER BY `unit` DESC [ RunTime:0.002135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3653 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3653 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87439-0600' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.011836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6896 LIMIT 4 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6896 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6896 ORDER BY `unit` DESC [ RunTime:0.003197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6896 LIMIT 2 [ RunTime:0.001419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6896 ORDER BY `minOrder` ASC [ RunTime:0.003326s ]
select * from pdf where partno='BEH-001T-P0.6' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.004296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BEH-001T-P0.6' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.000972s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001800s ]