SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002187s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002048s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001375s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.002959s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001200s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005087s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003521s ]
SELECT * FROM `stock_search` WHERE `partno` = '5015' LIMIT 1 [ RunTime:0.035547s ]
UPDATE `stock_search` SET `count` = 11375 , `updatetime` = '2026-04-25 06:54:47' WHERE `partno` = '5015' [ RunTime:0.006958s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000780s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000532s ]
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.003070s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001778s ]
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.000515s ]
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.004331s ]
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.019872s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794323 LIMIT 4 [ RunTime:0.005024s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794323 ORDER BY `minOrder` ASC [ RunTime:0.002727s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794323 ORDER BY `unit` DESC [ RunTime:0.012623s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794323 LIMIT 2 [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794323 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794297 LIMIT 4 [ RunTime:0.010620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794297 ORDER BY `minOrder` ASC [ RunTime:0.004582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794297 ORDER BY `unit` DESC [ RunTime:0.025055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794297 LIMIT 2 [ RunTime:0.017863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794297 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794282 LIMIT 4 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794282 ORDER BY `minOrder` ASC [ RunTime:0.003512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794282 ORDER BY `unit` DESC [ RunTime:0.071158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794282 LIMIT 2 [ RunTime:0.001932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794282 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='5015912411' and brandshort='Molex' limit 1 [ RunTime:0.016625s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.010750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794157 LIMIT 4 [ RunTime:0.007815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794157 ORDER BY `minOrder` ASC [ RunTime:0.009974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794157 ORDER BY `unit` DESC [ RunTime:0.004278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794157 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794157 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794084 LIMIT 4 [ RunTime:0.021012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794084 ORDER BY `minOrder` ASC [ RunTime:0.018209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794084 ORDER BY `unit` DESC [ RunTime:0.029087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794084 LIMIT 2 [ RunTime:0.013161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794084 ORDER BY `minOrder` ASC [ RunTime:0.008200s ]
select * from pdf where partno='5015911011' and brandshort='Molex' limit 1 [ RunTime:0.001390s ]
select foldpath,foldpath2,filename from pdf_file where id=852981 limit 1 [ RunTime:0.003789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793610 LIMIT 4 [ RunTime:0.011844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793610 ORDER BY `minOrder` ASC [ RunTime:0.008385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793610 ORDER BY `unit` DESC [ RunTime:0.001064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793610 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793610 ORDER BY `minOrder` ASC [ RunTime:0.007754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782434 LIMIT 4 [ RunTime:0.013394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782434 ORDER BY `minOrder` ASC [ RunTime:0.003196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782434 ORDER BY `unit` DESC [ RunTime:0.007959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782434 LIMIT 2 [ RunTime:0.005761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782434 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782279 LIMIT 4 [ RunTime:0.001621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782279 ORDER BY `minOrder` ASC [ RunTime:0.010962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782279 ORDER BY `unit` DESC [ RunTime:0.024374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782279 LIMIT 2 [ RunTime:0.025907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782279 ORDER BY `minOrder` ASC [ RunTime:0.012959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782198 LIMIT 4 [ RunTime:0.021647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782198 ORDER BY `minOrder` ASC [ RunTime:0.039834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782198 ORDER BY `unit` DESC [ RunTime:0.001156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782198 LIMIT 2 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782198 ORDER BY `minOrder` ASC [ RunTime:0.012718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781927 LIMIT 4 [ RunTime:0.006290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781927 ORDER BY `minOrder` ASC [ RunTime:0.005260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781927 ORDER BY `unit` DESC [ RunTime:0.014150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781927 LIMIT 2 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781927 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781679 LIMIT 4 [ RunTime:0.006259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781679 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781679 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781679 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781679 ORDER BY `minOrder` ASC [ RunTime:0.009732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781455 LIMIT 4 [ RunTime:0.038902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781455 ORDER BY `minOrder` ASC [ RunTime:0.014949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781455 ORDER BY `unit` DESC [ RunTime:0.038766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781455 LIMIT 2 [ RunTime:0.034811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781455 ORDER BY `minOrder` ASC [ RunTime:0.003384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781434 LIMIT 4 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781434 ORDER BY `minOrder` ASC [ RunTime:0.019340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781434 ORDER BY `unit` DESC [ RunTime:0.001511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781434 LIMIT 2 [ RunTime:0.009517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781434 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781199 LIMIT 4 [ RunTime:0.032298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781199 ORDER BY `minOrder` ASC [ RunTime:0.003186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781199 ORDER BY `unit` DESC [ RunTime:0.115436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781199 LIMIT 2 [ RunTime:0.008389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781199 ORDER BY `minOrder` ASC [ RunTime:0.002409s ]
select * from pdf where partno='5015912211' and brandshort='Molex' limit 1 [ RunTime:0.001076s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.005455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781131 LIMIT 4 [ RunTime:0.013700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781131 ORDER BY `minOrder` ASC [ RunTime:0.004305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781131 ORDER BY `unit` DESC [ RunTime:0.007256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781131 LIMIT 2 [ RunTime:0.001897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781131 ORDER BY `minOrder` ASC [ RunTime:0.007079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780688 LIMIT 4 [ RunTime:0.009342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780688 ORDER BY `minOrder` ASC [ RunTime:0.018305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780688 ORDER BY `unit` DESC [ RunTime:0.013349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780688 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780688 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='5015915411' and brandshort='Molex' limit 1 [ RunTime:0.002361s ]
select foldpath,foldpath2,filename from pdf_file where id=852983 limit 1 [ RunTime:0.051348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780564 LIMIT 4 [ RunTime:0.049417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780564 ORDER BY `minOrder` ASC [ RunTime:0.020303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780564 ORDER BY `unit` DESC [ RunTime:0.004929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780564 LIMIT 2 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780564 ORDER BY `minOrder` ASC [ RunTime:0.002609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016812 LIMIT 4 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016812 ORDER BY `minOrder` ASC [ RunTime:0.005043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12016812 ORDER BY `unit` DESC [ RunTime:0.003786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12016812 LIMIT 2 [ RunTime:0.007975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016812 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611638 LIMIT 4 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611638 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611638 ORDER BY `unit` DESC [ RunTime:0.001224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611638 LIMIT 2 [ RunTime:0.002060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611638 ORDER BY `minOrder` ASC [ RunTime:0.001611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611565 LIMIT 4 [ RunTime:0.001702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611565 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611565 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611565 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611565 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
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.000615s ]