SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003408s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.036968s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002109s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002387s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016674s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002515s ]
SELECT * FROM `stock_search` WHERE `partno` = '3013' LIMIT 1 [ RunTime:0.121059s ]
UPDATE `stock_search` SET `count` = 6408 , `updatetime` = '2026-03-16 23:19:59' WHERE `partno` = '3013' [ RunTime:0.016301s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.028128s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.013894s ]
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.052809s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002372s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '3013%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.091017s ]
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 '3013%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.162463s ]
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 ('11992702','19596385','19595757','19595756','19595219','19595218','19594657','19594656','18990503','18866691','17605552','17605418','17604440','15443109','14753428','14697730','14274202','14252966','13221077','13175154') ORDER BY FIELD(s.id, 11992702,19596385,19595757,19595756,19595219,19595218,19594657,19594656,18990503,18866691,17605552,17605418,17604440,15443109,14753428,14697730,14274202,14252966,13221077,13175154) [ RunTime:0.114898s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992702 LIMIT 4 [ RunTime:0.034856s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992702 ORDER BY `minOrder` ASC [ RunTime:0.025002s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11992702 ORDER BY `unit` DESC [ RunTime:0.026313s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.034365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11992702 LIMIT 2 [ RunTime:0.051250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992702 ORDER BY `minOrder` ASC [ RunTime:0.052765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596385 LIMIT 4 [ RunTime:0.052099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596385 ORDER BY `minOrder` ASC [ RunTime:0.056605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596385 ORDER BY `unit` DESC [ RunTime:0.032734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596385 LIMIT 2 [ RunTime:0.008418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596385 ORDER BY `minOrder` ASC [ RunTime:0.012812s ]
select * from pdf where partno='3013-0-15-15-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.040323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595757 LIMIT 4 [ RunTime:0.007680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595757 ORDER BY `minOrder` ASC [ RunTime:0.026078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595757 ORDER BY `unit` DESC [ RunTime:0.003164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595757 LIMIT 2 [ RunTime:0.018276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595757 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
select * from pdf where partno='3013-0-15-80-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595756 LIMIT 4 [ RunTime:0.008191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595756 ORDER BY `minOrder` ASC [ RunTime:0.012936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595756 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595756 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595756 ORDER BY `minOrder` ASC [ RunTime:0.003605s ]
select * from pdf where partno='3013-0-15-01-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595219 LIMIT 4 [ RunTime:0.013140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595219 ORDER BY `minOrder` ASC [ RunTime:0.008925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595219 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595219 LIMIT 2 [ RunTime:0.014074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595219 ORDER BY `minOrder` ASC [ RunTime:0.008121s ]
select * from pdf where partno='3013-0-15-80-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595218 LIMIT 4 [ RunTime:0.006113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595218 ORDER BY `minOrder` ASC [ RunTime:0.008292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595218 ORDER BY `unit` DESC [ RunTime:0.013588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595218 LIMIT 2 [ RunTime:0.003233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595218 ORDER BY `minOrder` ASC [ RunTime:0.006979s ]
select * from pdf where partno='3013-0-15-01-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594657 LIMIT 4 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594657 ORDER BY `minOrder` ASC [ RunTime:0.003064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594657 ORDER BY `unit` DESC [ RunTime:0.010303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594657 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594657 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
select * from pdf where partno='3013-0-15-80-32-84-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594656 LIMIT 4 [ RunTime:0.003108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594656 ORDER BY `minOrder` ASC [ RunTime:0.007179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594656 ORDER BY `unit` DESC [ RunTime:0.003290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594656 LIMIT 2 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594656 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
select * from pdf where partno='3013-0-15-01-32-02-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990503 LIMIT 4 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990503 ORDER BY `minOrder` ASC [ RunTime:0.013801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18990503 ORDER BY `unit` DESC [ RunTime:0.003835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18990503 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990503 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866691 LIMIT 4 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866691 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866691 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866691 LIMIT 2 [ RunTime:0.001454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866691 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17605552 LIMIT 4 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17605552 ORDER BY `minOrder` ASC [ RunTime:0.002920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17605552 ORDER BY `unit` DESC [ RunTime:0.002383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17605552 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17605552 ORDER BY `minOrder` ASC [ RunTime:0.008049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17605418 LIMIT 4 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17605418 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17605418 ORDER BY `unit` DESC [ RunTime:0.011628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17605418 LIMIT 2 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17605418 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17604440 LIMIT 4 [ RunTime:0.012284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17604440 ORDER BY `minOrder` ASC [ RunTime:0.006543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17604440 ORDER BY `unit` DESC [ RunTime:0.028404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17604440 LIMIT 2 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17604440 ORDER BY `minOrder` ASC [ RunTime:0.009285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443109 LIMIT 4 [ RunTime:0.033501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443109 ORDER BY `minOrder` ASC [ RunTime:0.021227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443109 ORDER BY `unit` DESC [ RunTime:0.038856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443109 LIMIT 2 [ RunTime:0.027474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443109 ORDER BY `minOrder` ASC [ RunTime:0.088972s ]
select * from pdf where partno='3013-0-15-15-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.051764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14753428 LIMIT 4 [ RunTime:0.051498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14753428 ORDER BY `minOrder` ASC [ RunTime:0.051691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14753428 ORDER BY `unit` DESC [ RunTime:0.051561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14753428 LIMIT 2 [ RunTime:0.051065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14753428 ORDER BY `minOrder` ASC [ RunTime:0.051456s ]
select * from pdf where partno='30137-20' and brandshort='Littelfuse/Commercial Vehicle Products' limit 1 [ RunTime:0.053964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697730 LIMIT 4 [ RunTime:0.051770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697730 ORDER BY `minOrder` ASC [ RunTime:0.051375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697730 ORDER BY `unit` DESC [ RunTime:0.051443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697730 LIMIT 2 [ RunTime:0.050962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697730 ORDER BY `minOrder` ASC [ RunTime:0.051030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274202 LIMIT 4 [ RunTime:0.051496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274202 ORDER BY `minOrder` ASC [ RunTime:0.050885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274202 ORDER BY `unit` DESC [ RunTime:0.237529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274202 LIMIT 2 [ RunTime:0.197203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274202 ORDER BY `minOrder` ASC [ RunTime:0.099593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252966 LIMIT 4 [ RunTime:0.196935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252966 ORDER BY `minOrder` ASC [ RunTime:0.037584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14252966 ORDER BY `unit` DESC [ RunTime:0.055959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14252966 LIMIT 2 [ RunTime:0.029206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252966 ORDER BY `minOrder` ASC [ RunTime:0.075973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13221077 LIMIT 4 [ RunTime:0.035581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13221077 ORDER BY `minOrder` ASC [ RunTime:0.079665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13221077 ORDER BY `unit` DESC [ RunTime:0.053139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13221077 LIMIT 2 [ RunTime:0.054008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13221077 ORDER BY `minOrder` ASC [ RunTime:0.028487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175154 LIMIT 4 [ RunTime:0.029052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175154 ORDER BY `minOrder` ASC [ RunTime:0.102303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175154 ORDER BY `unit` DESC [ RunTime:0.117318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175154 LIMIT 2 [ RunTime:0.122491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175154 ORDER BY `minOrder` ASC [ RunTime:0.025887s ]
select * from pdf where partno='3013W3PXK99A10X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.077924s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '3013%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.059039s ]