SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002838s ]
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` = '' [ RunTime:0.016215s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002046s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013243s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003416s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.018573s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002033s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.022288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003454s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.067581s ]
UPDATE `stock_search` SET `count` = 2813 , `updatetime` = '2026-06-08 08:15:18' WHERE `partno` = '210' [ RunTime:0.055714s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.018278s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.017615s ]
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.021722s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002800s ]
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.026400s ]
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 4900,20 [ RunTime:0.125230s ]
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 ('32879678','32879677','32879676','32879675','32879674','32879425','32879424','32879423','32879422','32879421','32879420','32879419','32879418','32879395','32879394','32879393','32879392','32879391','32879390','32879389') ORDER BY FIELD(s.id, 32879678,32879677,32879676,32879675,32879674,32879425,32879424,32879423,32879422,32879421,32879420,32879419,32879418,32879395,32879394,32879393,32879392,32879391,32879390,32879389) [ RunTime:0.070194s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879678 LIMIT 4 [ RunTime:0.091544s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879678 ORDER BY `minOrder` ASC [ RunTime:0.036121s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.038330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879678 ORDER BY `unit` DESC [ RunTime:0.049510s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879678 LIMIT 2 [ RunTime:0.097523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879678 ORDER BY `minOrder` ASC [ RunTime:0.022963s ]
select * from pdf where partno='210-12ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.107120s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.069445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879677 LIMIT 4 [ RunTime:0.085990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879677 ORDER BY `minOrder` ASC [ RunTime:0.090122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879677 ORDER BY `unit` DESC [ RunTime:0.151358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879677 LIMIT 2 [ RunTime:0.149752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879677 ORDER BY `minOrder` ASC [ RunTime:0.023946s ]
select * from pdf where partno='210-12MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.094432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.050250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879676 LIMIT 4 [ RunTime:0.128571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879676 ORDER BY `minOrder` ASC [ RunTime:0.040676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879676 ORDER BY `unit` DESC [ RunTime:0.037155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879676 LIMIT 2 [ RunTime:0.058078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879676 ORDER BY `minOrder` ASC [ RunTime:0.071035s ]
select * from pdf where partno='210-12LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.080734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.064200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879675 LIMIT 4 [ RunTime:0.153373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879675 ORDER BY `minOrder` ASC [ RunTime:0.103125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879675 ORDER BY `unit` DESC [ RunTime:0.087304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879675 LIMIT 2 [ RunTime:0.060283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879675 ORDER BY `minOrder` ASC [ RunTime:0.023407s ]
select * from pdf where partno='210-12ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.114960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.051820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879674 LIMIT 4 [ RunTime:0.027251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879674 ORDER BY `minOrder` ASC [ RunTime:0.129946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879674 ORDER BY `unit` DESC [ RunTime:0.082126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879674 LIMIT 2 [ RunTime:0.060877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879674 ORDER BY `minOrder` ASC [ RunTime:0.080352s ]
select * from pdf where partno='210-12LPS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.047759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-12LPS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.149661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879425 LIMIT 4 [ RunTime:0.111099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879425 ORDER BY `minOrder` ASC [ RunTime:0.082487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879425 ORDER BY `unit` DESC [ RunTime:0.003195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879425 LIMIT 2 [ RunTime:0.071701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879425 ORDER BY `minOrder` ASC [ RunTime:0.046842s ]
select * from pdf where partno='210-10MSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.110283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879424 LIMIT 4 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879424 ORDER BY `minOrder` ASC [ RunTime:0.126327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879424 ORDER BY `unit` DESC [ RunTime:0.040017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879424 LIMIT 2 [ RunTime:0.102578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879424 ORDER BY `minOrder` ASC [ RunTime:0.046089s ]
select * from pdf where partno='210-10LPSTFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.037030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.072501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879423 LIMIT 4 [ RunTime:0.060895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879423 ORDER BY `minOrder` ASC [ RunTime:0.045988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879423 ORDER BY `unit` DESC [ RunTime:0.122219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879423 LIMIT 2 [ RunTime:0.140851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879423 ORDER BY `minOrder` ASC [ RunTime:0.011389s ]
select * from pdf where partno='210-10MSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.138380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.115921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879422 LIMIT 4 [ RunTime:0.206526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879422 ORDER BY `minOrder` ASC [ RunTime:0.258765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879422 ORDER BY `unit` DESC [ RunTime:0.071073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879422 LIMIT 2 [ RunTime:0.111973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879422 ORDER BY `minOrder` ASC [ RunTime:0.002582s ]
select * from pdf where partno='210-10LPSTD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.081580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.136865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879421 LIMIT 4 [ RunTime:0.163756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879421 ORDER BY `minOrder` ASC [ RunTime:0.054686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879421 ORDER BY `unit` DESC [ RunTime:0.145840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879421 LIMIT 2 [ RunTime:0.093823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879421 ORDER BY `minOrder` ASC [ RunTime:0.090810s ]
select * from pdf where partno='210-10MSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.086996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879420 LIMIT 4 [ RunTime:0.050343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879420 ORDER BY `minOrder` ASC [ RunTime:0.248599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879420 ORDER BY `unit` DESC [ RunTime:0.073818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879420 LIMIT 2 [ RunTime:0.067620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879420 ORDER BY `minOrder` ASC [ RunTime:0.005065s ]
select * from pdf where partno='210-10LPSTF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.086639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSTF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.092388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879419 LIMIT 4 [ RunTime:0.058224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879419 ORDER BY `minOrder` ASC [ RunTime:0.082052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879419 ORDER BY `unit` DESC [ RunTime:0.085111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879419 LIMIT 2 [ RunTime:0.096210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879419 ORDER BY `minOrder` ASC [ RunTime:0.015513s ]
select * from pdf where partno='210-10MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.048329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879418 LIMIT 4 [ RunTime:0.030482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879418 ORDER BY `minOrder` ASC [ RunTime:0.053919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879418 ORDER BY `unit` DESC [ RunTime:0.014036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879418 LIMIT 2 [ RunTime:0.048815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879418 ORDER BY `minOrder` ASC [ RunTime:0.004102s ]
select * from pdf where partno='210-10LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879395 LIMIT 4 [ RunTime:0.022420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879395 ORDER BY `minOrder` ASC [ RunTime:0.034200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879395 ORDER BY `unit` DESC [ RunTime:0.010671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879395 LIMIT 2 [ RunTime:0.010253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879395 ORDER BY `minOrder` ASC [ RunTime:0.036825s ]
select * from pdf where partno='210-10ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.055253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879394 LIMIT 4 [ RunTime:0.021216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879394 ORDER BY `minOrder` ASC [ RunTime:0.019724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879394 ORDER BY `unit` DESC [ RunTime:0.038541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879394 LIMIT 2 [ RunTime:0.023495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879394 ORDER BY `minOrder` ASC [ RunTime:0.017404s ]
select * from pdf where partno='210-10MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.055017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879393 LIMIT 4 [ RunTime:0.016286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879393 ORDER BY `minOrder` ASC [ RunTime:0.012375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879393 ORDER BY `unit` DESC [ RunTime:0.020560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879393 LIMIT 2 [ RunTime:0.013789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879393 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='210-10LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879392 LIMIT 4 [ RunTime:0.021771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879392 ORDER BY `minOrder` ASC [ RunTime:0.035023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879392 ORDER BY `unit` DESC [ RunTime:0.070612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879392 LIMIT 2 [ RunTime:0.041376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879392 ORDER BY `minOrder` ASC [ RunTime:0.011777s ]
select * from pdf where partno='210-10ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879391 LIMIT 4 [ RunTime:0.026881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879391 ORDER BY `minOrder` ASC [ RunTime:0.003906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879391 ORDER BY `unit` DESC [ RunTime:0.008292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879391 LIMIT 2 [ RunTime:0.013611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879391 ORDER BY `minOrder` ASC [ RunTime:0.020646s ]
select * from pdf where partno='210-10MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879390 LIMIT 4 [ RunTime:0.034981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879390 ORDER BY `minOrder` ASC [ RunTime:0.024238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879390 ORDER BY `unit` DESC [ RunTime:0.015886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879390 LIMIT 2 [ RunTime:0.015803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879390 ORDER BY `minOrder` ASC [ RunTime:0.037937s ]
select * from pdf where partno='210-10LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32879389 LIMIT 4 [ RunTime:0.021254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879389 ORDER BY `minOrder` ASC [ RunTime:0.010152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32879389 ORDER BY `unit` DESC [ RunTime:0.017672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32879389 LIMIT 2 [ RunTime:0.027443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32879389 ORDER BY `minOrder` ASC [ RunTime:0.021345s ]
select * from pdf where partno='210-10ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015035s ]
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.015837s ]