SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003392s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000523s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002240s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.002092s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002458s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003918s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002266s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.014121s ]
UPDATE `stock_search` SET `count` = 528 , `updatetime` = '2026-06-05 01:59:03' WHERE `partno` = '210' [ RunTime:0.001750s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002581s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002890s ]
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.008370s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002156s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.231771s ]
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 '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 400,20 [ RunTime:0.041646s ]
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 ('13315631','10752787','32304854','32296632','13315014','10831967','13325976','12898843','10892557','10750963','12613274','13314773','11928056','10961629','32256983','13316335','10825251','14399116','11496218','10755327') ORDER BY FIELD(s.id, 13315631,10752787,32304854,32296632,13315014,10831967,13325976,12898843,10892557,10750963,12613274,13314773,11928056,10961629,32256983,13316335,10825251,14399116,11496218,10755327) [ RunTime:0.005329s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315631 LIMIT 4 [ RunTime:0.006539s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315631 ORDER BY `minOrder` ASC [ RunTime:0.002460s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315631 ORDER BY `unit` DESC [ RunTime:0.001695s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315631 LIMIT 2 [ RunTime:0.007047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315631 ORDER BY `minOrder` ASC [ RunTime:0.010748s ]
select * from pdf where partno='2100-440-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.019852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10752787 LIMIT 4 [ RunTime:0.012033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752787 ORDER BY `minOrder` ASC [ RunTime:0.038352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10752787 ORDER BY `unit` DESC [ RunTime:0.028868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10752787 LIMIT 2 [ RunTime:0.057656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752787 ORDER BY `minOrder` ASC [ RunTime:0.018714s ]
select * from pdf where partno='21005211-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.005099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304854 LIMIT 4 [ RunTime:0.016635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304854 ORDER BY `minOrder` ASC [ RunTime:0.015870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304854 ORDER BY `unit` DESC [ RunTime:0.005909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304854 LIMIT 2 [ RunTime:0.020717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304854 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
select * from pdf where partno='2108912-1' and brandshort='te connectivity' limit 1 [ RunTime:0.021796s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108912-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.052592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296632 LIMIT 4 [ RunTime:0.031573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296632 ORDER BY `minOrder` ASC [ RunTime:0.037433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296632 ORDER BY `unit` DESC [ RunTime:0.027083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296632 LIMIT 2 [ RunTime:0.016367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296632 ORDER BY `minOrder` ASC [ RunTime:0.010960s ]
select * from pdf where partno='2108912-1' and brandshort='te connectivity' limit 1 [ RunTime:0.011014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108912-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.011887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315014 LIMIT 4 [ RunTime:0.019113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315014 ORDER BY `minOrder` ASC [ RunTime:0.030078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315014 ORDER BY `unit` DESC [ RunTime:0.020062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315014 LIMIT 2 [ RunTime:0.043288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315014 ORDER BY `minOrder` ASC [ RunTime:0.016872s ]
select * from pdf where partno='2102T-632-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.014228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10831967 LIMIT 4 [ RunTime:0.010763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831967 ORDER BY `minOrder` ASC [ RunTime:0.011836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10831967 ORDER BY `unit` DESC [ RunTime:0.009502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10831967 LIMIT 2 [ RunTime:0.008976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831967 ORDER BY `minOrder` ASC [ RunTime:0.011705s ]
select * from pdf where partno='21005311-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.011212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325976 LIMIT 4 [ RunTime:0.014393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325976 ORDER BY `minOrder` ASC [ RunTime:0.004721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325976 ORDER BY `unit` DESC [ RunTime:0.005570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325976 LIMIT 2 [ RunTime:0.003842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325976 ORDER BY `minOrder` ASC [ RunTime:0.015882s ]
select * from pdf where partno='21006' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12898843 LIMIT 4 [ RunTime:0.048782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898843 ORDER BY `minOrder` ASC [ RunTime:0.023102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12898843 ORDER BY `unit` DESC [ RunTime:0.009809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12898843 LIMIT 2 [ RunTime:0.043612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898843 ORDER BY `minOrder` ASC [ RunTime:0.019354s ]
select * from pdf where partno='21033022000' and brandshort='HARTING' limit 1 [ RunTime:0.021302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10892557 LIMIT 4 [ RunTime:0.011334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892557 ORDER BY `minOrder` ASC [ RunTime:0.028012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10892557 ORDER BY `unit` DESC [ RunTime:0.029865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10892557 LIMIT 2 [ RunTime:0.045338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892557 ORDER BY `minOrder` ASC [ RunTime:0.026386s ]
select * from pdf where partno='21033214501' and brandshort='HARTING' limit 1 [ RunTime:0.019972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10750963 LIMIT 4 [ RunTime:0.022224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750963 ORDER BY `minOrder` ASC [ RunTime:0.010726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10750963 ORDER BY `unit` DESC [ RunTime:0.010843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10750963 LIMIT 2 [ RunTime:0.039502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750963 ORDER BY `minOrder` ASC [ RunTime:0.035255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613274 LIMIT 4 [ RunTime:0.020336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613274 ORDER BY `minOrder` ASC [ RunTime:0.008493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613274 ORDER BY `unit` DESC [ RunTime:0.019254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613274 LIMIT 2 [ RunTime:0.009780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613274 ORDER BY `minOrder` ASC [ RunTime:0.008210s ]
select * from pdf where partno='2103171-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314773 LIMIT 4 [ RunTime:0.019143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314773 ORDER BY `minOrder` ASC [ RunTime:0.005144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314773 ORDER BY `unit` DESC [ RunTime:0.006477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314773 LIMIT 2 [ RunTime:0.007866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314773 ORDER BY `minOrder` ASC [ RunTime:0.010461s ]
select * from pdf where partno='2108-632-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.016561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11928056 LIMIT 4 [ RunTime:0.013575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928056 ORDER BY `minOrder` ASC [ RunTime:0.014058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11928056 ORDER BY `unit` DESC [ RunTime:0.012039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11928056 LIMIT 2 [ RunTime:0.012589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928056 ORDER BY `minOrder` ASC [ RunTime:0.016416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10961629 LIMIT 4 [ RunTime:0.035560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10961629 ORDER BY `minOrder` ASC [ RunTime:0.024991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10961629 ORDER BY `unit` DESC [ RunTime:0.014351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10961629 LIMIT 2 [ RunTime:0.004931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10961629 ORDER BY `minOrder` ASC [ RunTime:0.006146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256983 LIMIT 4 [ RunTime:0.019861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256983 ORDER BY `minOrder` ASC [ RunTime:0.009540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256983 ORDER BY `unit` DESC [ RunTime:0.007540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256983 LIMIT 2 [ RunTime:0.017770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256983 ORDER BY `minOrder` ASC [ RunTime:0.013752s ]
select * from pdf where partno='210-13-308-41-001000' and brandshort='mill-max' limit 1 [ RunTime:0.009762s ]
select foldpath,foldpath2,filename from pdf_file where id=1493894 limit 1 [ RunTime:0.005346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-13-308-41-001000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.007165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316335 LIMIT 4 [ RunTime:0.014200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316335 ORDER BY `minOrder` ASC [ RunTime:0.004168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316335 ORDER BY `unit` DESC [ RunTime:0.007543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316335 LIMIT 2 [ RunTime:0.007458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316335 ORDER BY `minOrder` ASC [ RunTime:0.010236s ]
select * from pdf where partno='2106-632-B-5' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.003710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825251 LIMIT 4 [ RunTime:0.010667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825251 ORDER BY `minOrder` ASC [ RunTime:0.008346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10825251 ORDER BY `unit` DESC [ RunTime:0.008410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10825251 LIMIT 2 [ RunTime:0.007344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825251 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14399116 LIMIT 4 [ RunTime:0.009948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399116 ORDER BY `minOrder` ASC [ RunTime:0.012720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14399116 ORDER BY `unit` DESC [ RunTime:0.005985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14399116 LIMIT 2 [ RunTime:0.017541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399116 ORDER BY `minOrder` ASC [ RunTime:0.009171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496218 LIMIT 4 [ RunTime:0.015732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496218 ORDER BY `minOrder` ASC [ RunTime:0.016255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496218 ORDER BY `unit` DESC [ RunTime:0.006684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496218 LIMIT 2 [ RunTime:0.019067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496218 ORDER BY `minOrder` ASC [ RunTime:0.008865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755327 LIMIT 4 [ RunTime:0.009010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.003556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10755327 ORDER BY `unit` DESC [ RunTime:0.012344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10755327 LIMIT 2 [ RunTime:0.015227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.006008s ]
select * from pdf where partno='21021511305' and brandshort='HARTING' limit 1 [ RunTime:0.003357s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.041674s ]