SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001548s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002018s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.170' ) [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002539s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001566s ]
SELECT * FROM `stock_search` WHERE `partno` = '5015' LIMIT 1 [ RunTime:0.000697s ]
UPDATE `stock_search` SET `count` = 4854 , `updatetime` = '2026-03-07 09:16:55' WHERE `partno` = '5015' [ RunTime:0.002458s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000224s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000189s ]
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.000330s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001177s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '5015%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.001762s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '5015%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.001514s ]
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 ('12794323','12794297','12794282','12794157','12794084','12793610','12782434','12782279','12782198','12781927','12781679','12781455','12781434','12781199','12781131','12780688','12780564','12016812','11611638','11611565') ORDER BY FIELD(s.id, 12794323,12794297,12794282,12794157,12794084,12793610,12782434,12782279,12782198,12781927,12781679,12781455,12781434,12781199,12781131,12780688,12780564,12016812,11611638,11611565) [ RunTime:0.006709s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794323 LIMIT 4 [ RunTime:0.002458s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794323 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794323 ORDER BY `unit` DESC [ RunTime:0.002713s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794323 LIMIT 2 [ RunTime:0.001474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794323 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794297 LIMIT 4 [ RunTime:0.007009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794297 ORDER BY `minOrder` ASC [ RunTime:0.010817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794297 ORDER BY `unit` DESC [ RunTime:0.022873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794297 LIMIT 2 [ RunTime:0.018531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794297 ORDER BY `minOrder` ASC [ RunTime:0.022738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794282 LIMIT 4 [ RunTime:0.010875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794282 ORDER BY `minOrder` ASC [ RunTime:0.025262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794282 ORDER BY `unit` DESC [ RunTime:0.017499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794282 LIMIT 2 [ RunTime:0.013799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794282 ORDER BY `minOrder` ASC [ RunTime:0.017335s ]
select * from pdf where partno='5015912411' and brandshort='Molex' limit 1 [ RunTime:0.005482s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.034352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794157 LIMIT 4 [ RunTime:0.014342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794157 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794157 ORDER BY `unit` DESC [ RunTime:0.000453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794157 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794157 ORDER BY `minOrder` ASC [ RunTime:0.003515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794084 LIMIT 4 [ RunTime:0.017300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794084 ORDER BY `minOrder` ASC [ RunTime:0.003493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794084 ORDER BY `unit` DESC [ RunTime:0.013078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794084 LIMIT 2 [ RunTime:0.005350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794084 ORDER BY `minOrder` ASC [ RunTime:0.004640s ]
select * from pdf where partno='5015911011' and brandshort='Molex' limit 1 [ RunTime:0.008377s ]
select foldpath,foldpath2,filename from pdf_file where id=852981 limit 1 [ RunTime:0.010788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793610 LIMIT 4 [ RunTime:0.008322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793610 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793610 ORDER BY `unit` DESC [ RunTime:0.016147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793610 LIMIT 2 [ RunTime:0.006356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793610 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782434 LIMIT 4 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782434 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782434 ORDER BY `unit` DESC [ RunTime:0.004796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782434 LIMIT 2 [ RunTime:0.008695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782434 ORDER BY `minOrder` ASC [ RunTime:0.000177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782279 LIMIT 4 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782279 ORDER BY `minOrder` ASC [ RunTime:0.006904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782279 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782279 LIMIT 2 [ RunTime:0.005331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782279 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782198 LIMIT 4 [ RunTime:0.010984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782198 ORDER BY `minOrder` ASC [ RunTime:0.001092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782198 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782198 LIMIT 2 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782198 ORDER BY `minOrder` ASC [ RunTime:0.001560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781927 LIMIT 4 [ RunTime:0.011894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781927 ORDER BY `minOrder` ASC [ RunTime:0.012641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781927 ORDER BY `unit` DESC [ RunTime:0.006842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781927 LIMIT 2 [ RunTime:0.003193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781927 ORDER BY `minOrder` ASC [ RunTime:0.007254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781679 LIMIT 4 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781679 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781679 ORDER BY `unit` DESC [ RunTime:0.007143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781679 LIMIT 2 [ RunTime:0.012887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781679 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781455 LIMIT 4 [ RunTime:0.005583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781455 ORDER BY `minOrder` ASC [ RunTime:0.004866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781455 ORDER BY `unit` DESC [ RunTime:0.001185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781455 LIMIT 2 [ RunTime:0.009026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781455 ORDER BY `minOrder` ASC [ RunTime:0.008452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781434 LIMIT 4 [ RunTime:0.002499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781434 ORDER BY `minOrder` ASC [ RunTime:0.001708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781434 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781434 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781434 ORDER BY `minOrder` ASC [ RunTime:0.002627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781199 LIMIT 4 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781199 ORDER BY `minOrder` ASC [ RunTime:0.004901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781199 ORDER BY `unit` DESC [ RunTime:0.009279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781199 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781199 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='5015912211' and brandshort='Molex' limit 1 [ RunTime:0.008729s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.003390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781131 LIMIT 4 [ RunTime:0.003837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781131 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781131 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781131 LIMIT 2 [ RunTime:0.003609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781131 ORDER BY `minOrder` ASC [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780688 LIMIT 4 [ RunTime:0.005235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780688 ORDER BY `minOrder` ASC [ RunTime:0.008937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780688 ORDER BY `unit` DESC [ RunTime:0.002498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780688 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780688 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
select * from pdf where partno='5015915411' and brandshort='Molex' limit 1 [ RunTime:0.001006s ]
select foldpath,foldpath2,filename from pdf_file where id=852983 limit 1 [ RunTime:0.003037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780564 LIMIT 4 [ RunTime:0.001090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780564 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780564 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780564 LIMIT 2 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780564 ORDER BY `minOrder` ASC [ RunTime:0.000157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016812 LIMIT 4 [ RunTime:0.007973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016812 ORDER BY `minOrder` ASC [ RunTime:0.003044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12016812 ORDER BY `unit` DESC [ RunTime:0.000254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12016812 LIMIT 2 [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016812 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611638 LIMIT 4 [ RunTime:0.012425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611638 ORDER BY `minOrder` ASC [ RunTime:0.001920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611638 ORDER BY `unit` DESC [ RunTime:0.001042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611638 LIMIT 2 [ RunTime:0.008034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611638 ORDER BY `minOrder` ASC [ RunTime:0.000184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611565 LIMIT 4 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611565 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611565 ORDER BY `unit` DESC [ RunTime:0.006712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611565 LIMIT 2 [ RunTime:0.003877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611565 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '5015%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002094s ]