SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001401s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001540s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001585s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001357s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.001661s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002313s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003749s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002226s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000935s ]
UPDATE `stock_search` SET `count` = 1620 , `updatetime` = '2026-06-06 19:51:10' WHERE `partno` = '210' [ RunTime:0.001403s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000286s ]
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.001998s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001779s ]
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.433131s ]
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 3000,20 [ RunTime:0.075465s ]
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 ('32879675','32879674','32879425','32879424','32879423','32879422','32879421','32879420','32879419','32879418','32879395','32879394','32879393','32879392','32879391','32879390','32879389','32879388','32879387','32879386') ORDER BY FIELD(s.id, 32879675,32879674,32879425,32879424,32879423,32879422,32879421,32879420,32879419,32879418,32879395,32879394,32879393,32879392,32879391,32879390,32879389,32879388,32879387,32879386) [ RunTime:0.002468s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879675 LIMIT 4 [ RunTime:0.006448s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879675 ORDER BY `minOrder` ASC [ RunTime:0.010735s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879675 ORDER BY `unit` DESC [ RunTime:0.006192s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879675 LIMIT 2 [ RunTime:0.031087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879675 ORDER BY `minOrder` ASC [ RunTime:0.004508s ]
select * from pdf where partno='210-12ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019987s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879674 LIMIT 4 [ RunTime:0.011397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879674 ORDER BY `minOrder` ASC [ RunTime:0.015255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879674 ORDER BY `unit` DESC [ RunTime:0.032121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879674 LIMIT 2 [ RunTime:0.012826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879674 ORDER BY `minOrder` ASC [ RunTime:0.005906s ]
select * from pdf where partno='210-12LPS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12LPS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.030932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879425 LIMIT 4 [ RunTime:0.037941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879425 ORDER BY `minOrder` ASC [ RunTime:0.015255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879425 ORDER BY `unit` DESC [ RunTime:0.017405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879425 LIMIT 2 [ RunTime:0.023790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879425 ORDER BY `minOrder` ASC [ RunTime:0.016555s ]
select * from pdf where partno='210-10MSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879424 LIMIT 4 [ RunTime:0.017446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879424 ORDER BY `minOrder` ASC [ RunTime:0.013593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879424 ORDER BY `unit` DESC [ RunTime:0.007715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879424 LIMIT 2 [ RunTime:0.009443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879424 ORDER BY `minOrder` ASC [ RunTime:0.005787s ]
select * from pdf where partno='210-10LPSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879423 LIMIT 4 [ RunTime:0.011043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879423 ORDER BY `minOrder` ASC [ RunTime:0.001775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879423 ORDER BY `unit` DESC [ RunTime:0.003956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879423 LIMIT 2 [ RunTime:0.004341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879423 ORDER BY `minOrder` ASC [ RunTime:0.009746s ]
select * from pdf where partno='210-10MSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879422 LIMIT 4 [ RunTime:0.013328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879422 ORDER BY `minOrder` ASC [ RunTime:0.004654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879422 ORDER BY `unit` DESC [ RunTime:0.005717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879422 LIMIT 2 [ RunTime:0.006342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879422 ORDER BY `minOrder` ASC [ RunTime:0.008309s ]
select * from pdf where partno='210-10LPSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879421 LIMIT 4 [ RunTime:0.011384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879421 ORDER BY `minOrder` ASC [ RunTime:0.008927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879421 ORDER BY `unit` DESC [ RunTime:0.007929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879421 LIMIT 2 [ RunTime:0.011208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879421 ORDER BY `minOrder` ASC [ RunTime:0.002533s ]
select * from pdf where partno='210-10MSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879420 LIMIT 4 [ RunTime:0.004962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879420 ORDER BY `minOrder` ASC [ RunTime:0.001258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879420 ORDER BY `unit` DESC [ RunTime:0.002197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879420 LIMIT 2 [ RunTime:0.003770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879420 ORDER BY `minOrder` ASC [ RunTime:0.001928s ]
select * from pdf where partno='210-10LPSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879419 LIMIT 4 [ RunTime:0.005472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879419 ORDER BY `minOrder` ASC [ RunTime:0.001201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879419 ORDER BY `unit` DESC [ RunTime:0.005453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879419 LIMIT 2 [ RunTime:0.009847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879419 ORDER BY `minOrder` ASC [ RunTime:0.001954s ]
select * from pdf where partno='210-10MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879418 LIMIT 4 [ RunTime:0.010986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879418 ORDER BY `minOrder` ASC [ RunTime:0.042217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879418 ORDER BY `unit` DESC [ RunTime:0.052830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879418 LIMIT 2 [ RunTime:0.045500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879418 ORDER BY `minOrder` ASC [ RunTime:0.024906s ]
select * from pdf where partno='210-10LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.046062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.064625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879395 LIMIT 4 [ RunTime:0.109622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879395 ORDER BY `minOrder` ASC [ RunTime:0.023547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879395 ORDER BY `unit` DESC [ RunTime:0.057612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879395 LIMIT 2 [ RunTime:0.013917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879395 ORDER BY `minOrder` ASC [ RunTime:0.018299s ]
select * from pdf where partno='210-10ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879394 LIMIT 4 [ RunTime:0.022867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879394 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879394 ORDER BY `unit` DESC [ RunTime:0.009170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879394 LIMIT 2 [ RunTime:0.006493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879394 ORDER BY `minOrder` ASC [ RunTime:0.002603s ]
select * from pdf where partno='210-10MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879393 LIMIT 4 [ RunTime:0.005589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879393 ORDER BY `minOrder` ASC [ RunTime:0.006364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879393 ORDER BY `unit` DESC [ RunTime:0.002400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879393 LIMIT 2 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879393 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
select * from pdf where partno='210-10LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879392 LIMIT 4 [ RunTime:0.009669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879392 ORDER BY `minOrder` ASC [ RunTime:0.004415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879392 ORDER BY `unit` DESC [ RunTime:0.008796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879392 LIMIT 2 [ RunTime:0.002765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879392 ORDER BY `minOrder` ASC [ RunTime:0.005014s ]
select * from pdf where partno='210-10ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879391 LIMIT 4 [ RunTime:0.004649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879391 ORDER BY `minOrder` ASC [ RunTime:0.004066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879391 ORDER BY `unit` DESC [ RunTime:0.006641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879391 LIMIT 2 [ RunTime:0.010054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879391 ORDER BY `minOrder` ASC [ RunTime:0.001931s ]
select * from pdf where partno='210-10MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879390 LIMIT 4 [ RunTime:0.019691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879390 ORDER BY `minOrder` ASC [ RunTime:0.004095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879390 ORDER BY `unit` DESC [ RunTime:0.002574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879390 LIMIT 2 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879390 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
select * from pdf where partno='210-10LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879389 LIMIT 4 [ RunTime:0.004113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879389 ORDER BY `minOrder` ASC [ RunTime:0.002914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879389 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879389 LIMIT 2 [ RunTime:0.006104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879389 ORDER BY `minOrder` ASC [ RunTime:0.004509s ]
select * from pdf where partno='210-10ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879388 LIMIT 4 [ RunTime:0.013294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879388 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879388 ORDER BY `unit` DESC [ RunTime:0.010170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879388 LIMIT 2 [ RunTime:0.006789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879388 ORDER BY `minOrder` ASC [ RunTime:0.009815s ]
select * from pdf where partno='210-10MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879387 LIMIT 4 [ RunTime:0.002365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879387 ORDER BY `minOrder` ASC [ RunTime:0.002319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879387 ORDER BY `unit` DESC [ RunTime:0.003485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879387 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879387 ORDER BY `minOrder` ASC [ RunTime:0.004369s ]
select * from pdf where partno='210-10LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879386 LIMIT 4 [ RunTime:0.002452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879386 ORDER BY `minOrder` ASC [ RunTime:0.000942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879386 ORDER BY `unit` DESC [ RunTime:0.003019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879386 LIMIT 2 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879386 ORDER BY `minOrder` ASC [ RunTime:0.001642s ]
select * from pdf where partno='210-10ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004940s ]
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.069212s ]