SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002376s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=258&srecordnum=7529' [ RunTime:0.005980s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002246s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001431s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001900s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.005053s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001523s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001564s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000717s ]
UPDATE `stock_search` SET `count` = 5150 , `updatetime` = '2026-06-08 22:49:08' WHERE `partno` = '210' [ RunTime:0.010123s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.007556s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000251s ]
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.000458s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001600s ]
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.100494s ]
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 5140,20 [ RunTime:0.079132s ]
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 ('32879002','32878992','32878991','32878990','32878989','32878988','32878987','32878986','32878985','32878966','32878965','32878964','32878963','32878962','32878961','32878960','32878959','32878958','32878957','32878956') ORDER BY FIELD(s.id, 32879002,32878992,32878991,32878990,32878989,32878988,32878987,32878986,32878985,32878966,32878965,32878964,32878963,32878962,32878961,32878960,32878959,32878958,32878957,32878956) [ RunTime:0.022736s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879002 LIMIT 4 [ RunTime:0.009062s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879002 ORDER BY `minOrder` ASC [ RunTime:0.034584s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879002 ORDER BY `unit` DESC [ RunTime:0.002641s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879002 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879002 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
select * from pdf where partno='210-8ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004863s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-8ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878992 LIMIT 4 [ RunTime:0.006878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878992 ORDER BY `minOrder` ASC [ RunTime:0.001187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878992 ORDER BY `unit` DESC [ RunTime:0.006316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878992 LIMIT 2 [ RunTime:0.006364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878992 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
select * from pdf where partno='210-7MSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878991 LIMIT 4 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878991 ORDER BY `minOrder` ASC [ RunTime:0.010835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878991 ORDER BY `unit` DESC [ RunTime:0.004679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878991 LIMIT 2 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878991 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='210-7LPSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878990 LIMIT 4 [ RunTime:0.006972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878990 ORDER BY `minOrder` ASC [ RunTime:0.011096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878990 ORDER BY `unit` DESC [ RunTime:0.008444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878990 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878990 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='210-7MSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878989 LIMIT 4 [ RunTime:0.006348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878989 ORDER BY `minOrder` ASC [ RunTime:0.006125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878989 ORDER BY `unit` DESC [ RunTime:0.005406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878989 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878989 ORDER BY `minOrder` ASC [ RunTime:0.007588s ]
select * from pdf where partno='210-7LPSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878988 LIMIT 4 [ RunTime:0.001313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878988 ORDER BY `minOrder` ASC [ RunTime:0.002104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878988 ORDER BY `unit` DESC [ RunTime:0.006224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878988 LIMIT 2 [ RunTime:0.010911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878988 ORDER BY `minOrder` ASC [ RunTime:0.004603s ]
select * from pdf where partno='210-7MSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878987 LIMIT 4 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878987 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878987 ORDER BY `unit` DESC [ RunTime:0.004055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878987 LIMIT 2 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878987 ORDER BY `minOrder` ASC [ RunTime:0.007513s ]
select * from pdf where partno='210-7LPSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878986 LIMIT 4 [ RunTime:0.003857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878986 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878986 ORDER BY `unit` DESC [ RunTime:0.006886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878986 LIMIT 2 [ RunTime:0.002480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878986 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
select * from pdf where partno='210-7MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878985 LIMIT 4 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878985 ORDER BY `minOrder` ASC [ RunTime:0.001169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878985 ORDER BY `unit` DESC [ RunTime:0.004835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878985 LIMIT 2 [ RunTime:0.002648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878985 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
select * from pdf where partno='210-7LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878966 LIMIT 4 [ RunTime:0.003274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878966 ORDER BY `minOrder` ASC [ RunTime:0.017384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878966 ORDER BY `unit` DESC [ RunTime:0.006719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878966 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878966 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
select * from pdf where partno='210-7ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878965 LIMIT 4 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878965 ORDER BY `minOrder` ASC [ RunTime:0.012155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878965 ORDER BY `unit` DESC [ RunTime:0.004765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878965 LIMIT 2 [ RunTime:0.005250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878965 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
select * from pdf where partno='210-7MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878964 LIMIT 4 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878964 ORDER BY `minOrder` ASC [ RunTime:0.002305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878964 ORDER BY `unit` DESC [ RunTime:0.005572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878964 LIMIT 2 [ RunTime:0.004926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878964 ORDER BY `minOrder` ASC [ RunTime:0.004788s ]
select * from pdf where partno='210-7LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878963 LIMIT 4 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878963 ORDER BY `minOrder` ASC [ RunTime:0.002073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878963 ORDER BY `unit` DESC [ RunTime:0.005732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878963 LIMIT 2 [ RunTime:0.004013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878963 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
select * from pdf where partno='210-7ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878962 LIMIT 4 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878962 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878962 ORDER BY `unit` DESC [ RunTime:0.005047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878962 LIMIT 2 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878962 ORDER BY `minOrder` ASC [ RunTime:0.009186s ]
select * from pdf where partno='210-7MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878961 LIMIT 4 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878961 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878961 ORDER BY `unit` DESC [ RunTime:0.005943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878961 LIMIT 2 [ RunTime:0.009834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878961 ORDER BY `minOrder` ASC [ RunTime:0.009911s ]
select * from pdf where partno='210-7LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878960 LIMIT 4 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878960 ORDER BY `minOrder` ASC [ RunTime:0.008849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878960 ORDER BY `unit` DESC [ RunTime:0.007098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878960 LIMIT 2 [ RunTime:0.005588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878960 ORDER BY `minOrder` ASC [ RunTime:0.009991s ]
select * from pdf where partno='210-7ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878959 LIMIT 4 [ RunTime:0.005534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878959 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878959 ORDER BY `unit` DESC [ RunTime:0.009017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878959 LIMIT 2 [ RunTime:0.004961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878959 ORDER BY `minOrder` ASC [ RunTime:0.012295s ]
select * from pdf where partno='210-7MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878958 LIMIT 4 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878958 ORDER BY `minOrder` ASC [ RunTime:0.008313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878958 ORDER BY `unit` DESC [ RunTime:0.007833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878958 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878958 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='210-7LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878957 LIMIT 4 [ RunTime:0.004837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878957 ORDER BY `minOrder` ASC [ RunTime:0.012293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878957 ORDER BY `unit` DESC [ RunTime:0.012285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878957 LIMIT 2 [ RunTime:0.009258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878957 ORDER BY `minOrder` ASC [ RunTime:0.008297s ]
select * from pdf where partno='210-7ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878956 LIMIT 4 [ RunTime:0.003160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878956 ORDER BY `minOrder` ASC [ RunTime:0.004107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878956 ORDER BY `unit` DESC [ RunTime:0.016483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878956 LIMIT 2 [ RunTime:0.011635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878956 ORDER BY `minOrder` ASC [ RunTime:0.004254s ]
select * from pdf where partno='210-7MS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-7MS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003293s ]
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.048946s ]