SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002367s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=72&srecordnum=10000' [ RunTime:0.006870s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002507s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001937s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.007318s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002816s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002642s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.002649s ]
UPDATE `stock_search` SET `count` = 1953 , `updatetime` = '2026-06-12 09:04:58' WHERE `partno` = '228' [ RunTime:0.005298s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000405s ]
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.006407s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002752s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.223818s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1420,20 [ RunTime:0.102839s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32925495','32925494','32925493','32925492','32925491','32925490','32925489','32925488','32925487','32925486','32925485','32925484','32925483','32925482','32925481','32925380','32925379','32925378','32925377','32925376') ORDER BY FIELD(s.id, 32925495,32925494,32925493,32925492,32925491,32925490,32925489,32925488,32925487,32925486,32925485,32925484,32925483,32925482,32925481,32925380,32925379,32925378,32925377,32925376) [ RunTime:0.008731s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925495 LIMIT 4 [ RunTime:0.020327s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925495 ORDER BY `minOrder` ASC [ RunTime:0.038463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925495 ORDER BY `unit` DESC [ RunTime:0.046328s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925495 LIMIT 2 [ RunTime:0.018351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925495 ORDER BY `minOrder` ASC [ RunTime:0.007896s ]
select * from pdf where partno='228CDVARGBFERB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023835s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFERB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.037952s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925495 AND `partno` = '228CDVARGBFERB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449725 [ RunTime:0.045461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925494 LIMIT 4 [ RunTime:0.008458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925494 ORDER BY `minOrder` ASC [ RunTime:0.035220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925494 ORDER BY `unit` DESC [ RunTime:0.040391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925494 LIMIT 2 [ RunTime:0.032711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925494 ORDER BY `minOrder` ASC [ RunTime:0.007361s ]
select * from pdf where partno='228CDVARGBFFBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFFBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020135s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925494 AND `partno` = '228CDVARGBFFBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366449 [ RunTime:0.013789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925493 LIMIT 4 [ RunTime:0.028097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925493 ORDER BY `minOrder` ASC [ RunTime:0.009480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925493 ORDER BY `unit` DESC [ RunTime:0.051646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925493 LIMIT 2 [ RunTime:0.036549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925493 ORDER BY `minOrder` ASC [ RunTime:0.019727s ]
select * from pdf where partno='228CDVARGFDWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.037469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFDWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026791s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925493 AND `partno` = '228CDVARGFDWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366448 [ RunTime:0.010510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925492 LIMIT 4 [ RunTime:0.013601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925492 ORDER BY `minOrder` ASC [ RunTime:0.012349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925492 ORDER BY `unit` DESC [ RunTime:0.059189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925492 LIMIT 2 [ RunTime:0.041325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925492 ORDER BY `minOrder` ASC [ RunTime:0.014660s ]
select * from pdf where partno='228CDVABFAAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.044684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFAAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022536s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925492 AND `partno` = '228CDVABFAAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449724 [ RunTime:0.005956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925491 LIMIT 4 [ RunTime:0.033582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925491 ORDER BY `minOrder` ASC [ RunTime:0.030032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925491 ORDER BY `unit` DESC [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925491 LIMIT 2 [ RunTime:0.003070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925491 ORDER BY `minOrder` ASC [ RunTime:0.007766s ]
select * from pdf where partno='228CDVARAFEWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFEWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032017s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925491 AND `partno` = '228CDVARAFEWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366447 [ RunTime:0.036228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925490 LIMIT 4 [ RunTime:0.028557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925490 ORDER BY `minOrder` ASC [ RunTime:0.017197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925490 ORDER BY `unit` DESC [ RunTime:0.074965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925490 LIMIT 2 [ RunTime:0.104796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925490 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='228CDVAGFDMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.036297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFDMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022765s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925490 AND `partno` = '228CDVAGFDMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366446 [ RunTime:0.019549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925489 LIMIT 4 [ RunTime:0.032564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925489 ORDER BY `minOrder` ASC [ RunTime:0.016370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925489 ORDER BY `unit` DESC [ RunTime:0.021935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925489 LIMIT 2 [ RunTime:0.014807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925489 ORDER BY `minOrder` ASC [ RunTime:0.012154s ]
select * from pdf where partno='228CDVARFAAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041718s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925489 AND `partno` = '228CDVARFAAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449723 [ RunTime:0.029893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925488 LIMIT 4 [ RunTime:0.028412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925488 ORDER BY `minOrder` ASC [ RunTime:0.012126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925488 ORDER BY `unit` DESC [ RunTime:0.021854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925488 LIMIT 2 [ RunTime:0.019718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925488 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
select * from pdf where partno='228CDVAAWFDWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFDWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007695s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925488 AND `partno` = '228CDVAAWFDWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449722 [ RunTime:0.012766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925487 LIMIT 4 [ RunTime:0.026186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925487 ORDER BY `minOrder` ASC [ RunTime:0.029469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925487 ORDER BY `unit` DESC [ RunTime:0.002895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925487 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925487 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
select * from pdf where partno='228CDVARFAWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025142s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925487 AND `partno` = '228CDVARFAWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.034103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366445 [ RunTime:0.031441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925486 LIMIT 4 [ RunTime:0.027292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925486 ORDER BY `minOrder` ASC [ RunTime:0.024914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925486 ORDER BY `unit` DESC [ RunTime:0.019238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925486 LIMIT 2 [ RunTime:0.020105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925486 ORDER BY `minOrder` ASC [ RunTime:0.002625s ]
select * from pdf where partno='228CDVARAFFBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000857s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925486 AND `partno` = '228CDVARAFFBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449721 [ RunTime:0.023616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925485 LIMIT 4 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925485 ORDER BY `minOrder` ASC [ RunTime:0.010933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925485 ORDER BY `unit` DESC [ RunTime:0.015510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925485 LIMIT 2 [ RunTime:0.017150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925485 ORDER BY `minOrder` ASC [ RunTime:0.013404s ]
select * from pdf where partno='228CDVAAFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026634s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925485 AND `partno` = '228CDVAAFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366444 [ RunTime:0.006452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925484 LIMIT 4 [ RunTime:0.006931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925484 ORDER BY `minOrder` ASC [ RunTime:0.017134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925484 ORDER BY `unit` DESC [ RunTime:0.015755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925484 LIMIT 2 [ RunTime:0.024518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925484 ORDER BY `minOrder` ASC [ RunTime:0.007787s ]
select * from pdf where partno='228CDVAGFDWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFDWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013259s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925484 AND `partno` = '228CDVAGFDWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366443 [ RunTime:0.018884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925483 LIMIT 4 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925483 ORDER BY `minOrder` ASC [ RunTime:0.011054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925483 ORDER BY `unit` DESC [ RunTime:0.019242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925483 LIMIT 2 [ RunTime:0.009338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925483 ORDER BY `minOrder` ASC [ RunTime:0.004266s ]
select * from pdf where partno='228CDVARGFFMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035353s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925483 AND `partno` = '228CDVARGFFMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449720 [ RunTime:0.009147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925482 LIMIT 4 [ RunTime:0.040531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925482 ORDER BY `minOrder` ASC [ RunTime:0.038906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925482 ORDER BY `unit` DESC [ RunTime:0.017601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925482 LIMIT 2 [ RunTime:0.055140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925482 ORDER BY `minOrder` ASC [ RunTime:0.012985s ]
select * from pdf where partno='228CDVAAFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.112664s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925482 AND `partno` = '228CDVAAFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.049213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449719 [ RunTime:0.021645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925481 LIMIT 4 [ RunTime:0.035470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925481 ORDER BY `minOrder` ASC [ RunTime:0.043962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925481 ORDER BY `unit` DESC [ RunTime:0.362318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925481 LIMIT 2 [ RunTime:0.113409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925481 ORDER BY `minOrder` ASC [ RunTime:0.059080s ]
select * from pdf where partno='228CDVAAWFFWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.051285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.078486s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925481 AND `partno` = '228CDVAAWFFWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366442 [ RunTime:0.159185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925380 LIMIT 4 [ RunTime:0.069700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925380 ORDER BY `minOrder` ASC [ RunTime:0.015067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925380 ORDER BY `unit` DESC [ RunTime:0.045251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925380 LIMIT 2 [ RunTime:0.063326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925380 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
select * from pdf where partno='228CDVARGBFBRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.055124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFBRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041625s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925380 AND `partno` = '228CDVARGBFBRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366441 [ RunTime:0.025186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925379 LIMIT 4 [ RunTime:0.083985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925379 ORDER BY `minOrder` ASC [ RunTime:0.017449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925379 ORDER BY `unit` DESC [ RunTime:0.028537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925379 LIMIT 2 [ RunTime:0.031906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925379 ORDER BY `minOrder` ASC [ RunTime:0.012641s ]
select * from pdf where partno='228CDVAAFDMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015215s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925379 AND `partno` = '228CDVAAFDMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366440 [ RunTime:0.003153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925378 LIMIT 4 [ RunTime:0.010009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925378 ORDER BY `minOrder` ASC [ RunTime:0.006668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925378 ORDER BY `unit` DESC [ RunTime:0.015021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925378 LIMIT 2 [ RunTime:0.001830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925378 ORDER BY `minOrder` ASC [ RunTime:0.012262s ]
select * from pdf where partno='228CDVAGFDWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFDWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007262s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925378 AND `partno` = '228CDVAGFDWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449718 [ RunTime:0.002282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925377 LIMIT 4 [ RunTime:0.005376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925377 ORDER BY `minOrder` ASC [ RunTime:0.006423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925377 ORDER BY `unit` DESC [ RunTime:0.003491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925377 LIMIT 2 [ RunTime:0.005762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925377 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
select * from pdf where partno='228CDVARBFFRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFFRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004900s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925377 AND `partno` = '228CDVARBFFRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366439 [ RunTime:0.005809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925376 LIMIT 4 [ RunTime:0.003288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925376 ORDER BY `minOrder` ASC [ RunTime:0.006187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925376 ORDER BY `unit` DESC [ RunTime:0.002402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925376 LIMIT 2 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925376 ORDER BY `minOrder` ASC [ RunTime:0.005533s ]
select * from pdf where partno='228CDVAGFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002583s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925376 AND `partno` = '228CDVAGFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013485s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.085302s ]