SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001335s ]
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=94&srecordnum=10000' [ RunTime:0.003570s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002764s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001308s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001369s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001542s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001845s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000651s ]
UPDATE `stock_search` SET `count` = 1984 , `updatetime` = '2026-06-12 13:50:43' WHERE `partno` = '228' [ RunTime:0.011347s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008906s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001501s ]
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.000468s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002447s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.213814s ]
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 1860,20 [ RunTime:0.121381s ]
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 ('32924855','32924854','32924853','32924852','32924851','32924850','32924849','32924848','32924847','32924846','32924845','32924844','32924843','32924842','32924841','32924840','32924839','32924838','32924837','32924836') ORDER BY FIELD(s.id, 32924855,32924854,32924853,32924852,32924851,32924850,32924849,32924848,32924847,32924846,32924845,32924844,32924843,32924842,32924841,32924840,32924839,32924838,32924837,32924836) [ RunTime:0.017460s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924855 LIMIT 4 [ RunTime:0.008911s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924855 ORDER BY `minOrder` ASC [ RunTime:0.007596s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924855 ORDER BY `unit` DESC [ RunTime:0.005289s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924855 LIMIT 2 [ RunTime:0.006369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924855 ORDER BY `minOrder` ASC [ RunTime:0.014971s ]
select * from pdf where partno='228CDVABFAMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006113s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFAMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015694s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924855 AND `partno` = '228CDVABFAMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366296 [ RunTime:0.034694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924854 LIMIT 4 [ RunTime:0.014985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924854 ORDER BY `minOrder` ASC [ RunTime:0.024574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924854 ORDER BY `unit` DESC [ RunTime:0.048635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924854 LIMIT 2 [ RunTime:0.036390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924854 ORDER BY `minOrder` ASC [ RunTime:0.013935s ]
select * from pdf where partno='228CDVAWFAAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.066179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016179s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924854 AND `partno` = '228CDVAWFAAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449506 [ RunTime:0.076523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924853 LIMIT 4 [ RunTime:0.043083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924853 ORDER BY `minOrder` ASC [ RunTime:0.086794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924853 ORDER BY `unit` DESC [ RunTime:0.047123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924853 LIMIT 2 [ RunTime:0.029850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924853 ORDER BY `minOrder` ASC [ RunTime:0.028854s ]
select * from pdf where partno='228CDVAYFFMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023864s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924853 AND `partno` = '228CDVAYFFMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366295 [ RunTime:0.049087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924852 LIMIT 4 [ RunTime:0.013357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924852 ORDER BY `minOrder` ASC [ RunTime:0.021737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924852 ORDER BY `unit` DESC [ RunTime:0.017636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924852 LIMIT 2 [ RunTime:0.043249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924852 ORDER BY `minOrder` ASC [ RunTime:0.027010s ]
select * from pdf where partno='228CDVAYFFBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924852 AND `partno` = '228CDVAYFFBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449505 [ RunTime:0.026842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924851 LIMIT 4 [ RunTime:0.023103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924851 ORDER BY `minOrder` ASC [ RunTime:0.027889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924851 ORDER BY `unit` DESC [ RunTime:0.029185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924851 LIMIT 2 [ RunTime:0.033400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924851 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
select * from pdf where partno='228CDVAAFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.055536s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924851 AND `partno` = '228CDVAAFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.050706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924850 LIMIT 4 [ RunTime:0.026479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924850 ORDER BY `minOrder` ASC [ RunTime:0.024845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924850 ORDER BY `unit` DESC [ RunTime:0.019711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924850 LIMIT 2 [ RunTime:0.008744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924850 ORDER BY `minOrder` ASC [ RunTime:0.019640s ]
select * from pdf where partno='228CDVAGFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015881s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924850 AND `partno` = '228CDVAGFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924849 LIMIT 4 [ RunTime:0.004604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924849 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924849 ORDER BY `unit` DESC [ RunTime:0.006520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924849 LIMIT 2 [ RunTime:0.030593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924849 ORDER BY `minOrder` ASC [ RunTime:0.021988s ]
select * from pdf where partno='228CDVARGBFFBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFFBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007333s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924849 AND `partno` = '228CDVARGBFFBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.042177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924848 LIMIT 4 [ RunTime:0.008627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924848 ORDER BY `minOrder` ASC [ RunTime:0.023826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924848 ORDER BY `unit` DESC [ RunTime:0.009144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924848 LIMIT 2 [ RunTime:0.013889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924848 ORDER BY `minOrder` ASC [ RunTime:0.008447s ]
select * from pdf where partno='228CDVAWFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016258s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924848 AND `partno` = '228CDVAWFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924847 LIMIT 4 [ RunTime:0.008682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924847 ORDER BY `minOrder` ASC [ RunTime:0.018509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924847 ORDER BY `unit` DESC [ RunTime:0.020531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924847 LIMIT 2 [ RunTime:0.005293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924847 ORDER BY `minOrder` ASC [ RunTime:0.007340s ]
select * from pdf where partno='228CDVAWFAMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026157s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924847 AND `partno` = '228CDVAWFAMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924846 LIMIT 4 [ RunTime:0.004533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924846 ORDER BY `minOrder` ASC [ RunTime:0.002802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924846 ORDER BY `unit` DESC [ RunTime:0.009285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924846 LIMIT 2 [ RunTime:0.023873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924846 ORDER BY `minOrder` ASC [ RunTime:0.026865s ]
select * from pdf where partno='228CDVAWFAMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014539s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924846 AND `partno` = '228CDVAWFAMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449504 [ RunTime:0.034740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924845 LIMIT 4 [ RunTime:0.013385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924845 ORDER BY `minOrder` ASC [ RunTime:0.010549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924845 ORDER BY `unit` DESC [ RunTime:0.004322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924845 LIMIT 2 [ RunTime:0.015848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924845 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='228CDVARGBFDRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924845 AND `partno` = '228CDVARGBFDRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366294 [ RunTime:0.014779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924844 LIMIT 4 [ RunTime:0.017239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924844 ORDER BY `minOrder` ASC [ RunTime:0.017005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924844 ORDER BY `unit` DESC [ RunTime:0.029891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924844 LIMIT 2 [ RunTime:0.010579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924844 ORDER BY `minOrder` ASC [ RunTime:0.003853s ]
select * from pdf where partno='228CDVAWFABBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFABBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008198s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924844 AND `partno` = '228CDVAWFABBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449503 [ RunTime:0.027177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924843 LIMIT 4 [ RunTime:0.060485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924843 ORDER BY `minOrder` ASC [ RunTime:0.025646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924843 ORDER BY `unit` DESC [ RunTime:0.021277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924843 LIMIT 2 [ RunTime:0.005082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924843 ORDER BY `minOrder` ASC [ RunTime:0.017815s ]
select * from pdf where partno='228CDVAAFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.071581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009309s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924843 AND `partno` = '228CDVAAFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366293 [ RunTime:0.027009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924842 LIMIT 4 [ RunTime:0.041777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924842 ORDER BY `minOrder` ASC [ RunTime:0.027508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924842 ORDER BY `unit` DESC [ RunTime:0.052733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924842 LIMIT 2 [ RunTime:0.016701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924842 ORDER BY `minOrder` ASC [ RunTime:0.006446s ]
select * from pdf where partno='228CDVARAFFMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016705s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924842 AND `partno` = '228CDVARAFFMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449502 [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924841 LIMIT 4 [ RunTime:0.017758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924841 ORDER BY `minOrder` ASC [ RunTime:0.026306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924841 ORDER BY `unit` DESC [ RunTime:0.007066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924841 LIMIT 2 [ RunTime:0.018664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924841 ORDER BY `minOrder` ASC [ RunTime:0.008277s ]
select * from pdf where partno='228CDVAAFAWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFAWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004030s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924841 AND `partno` = '228CDVAAFAWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449501 [ RunTime:0.026528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924840 LIMIT 4 [ RunTime:0.013302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924840 ORDER BY `minOrder` ASC [ RunTime:0.019352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924840 ORDER BY `unit` DESC [ RunTime:0.012305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924840 LIMIT 2 [ RunTime:0.024843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924840 ORDER BY `minOrder` ASC [ RunTime:0.016071s ]
select * from pdf where partno='228CDVARAFFMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.066108s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924840 AND `partno` = '228CDVARAFFMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449500 [ RunTime:0.026596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924839 LIMIT 4 [ RunTime:0.035442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924839 ORDER BY `minOrder` ASC [ RunTime:0.016934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924839 ORDER BY `unit` DESC [ RunTime:0.047962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924839 LIMIT 2 [ RunTime:0.019216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924839 ORDER BY `minOrder` ASC [ RunTime:0.010649s ]
select * from pdf where partno='228CDVARBFFWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFFWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009443s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924839 AND `partno` = '228CDVARBFFWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449499 [ RunTime:0.025766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924838 LIMIT 4 [ RunTime:0.014315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924838 ORDER BY `minOrder` ASC [ RunTime:0.022351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924838 ORDER BY `unit` DESC [ RunTime:0.024001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924838 LIMIT 2 [ RunTime:0.005271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924838 ORDER BY `minOrder` ASC [ RunTime:0.009785s ]
select * from pdf where partno='228CDVAYGFAMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.053339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYGFAMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010869s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924838 AND `partno` = '228CDVAYGFAMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449498 [ RunTime:0.047284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924837 LIMIT 4 [ RunTime:0.046631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924837 ORDER BY `minOrder` ASC [ RunTime:0.028646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924837 ORDER BY `unit` DESC [ RunTime:0.018871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924837 LIMIT 2 [ RunTime:0.054623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924837 ORDER BY `minOrder` ASC [ RunTime:0.020613s ]
select * from pdf where partno='228CDVARBFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017755s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924837 AND `partno` = '228CDVARBFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449497 [ RunTime:0.007254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924836 LIMIT 4 [ RunTime:0.027921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924836 ORDER BY `minOrder` ASC [ RunTime:0.036251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924836 ORDER BY `unit` DESC [ RunTime:0.041790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924836 LIMIT 2 [ RunTime:0.017557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924836 ORDER BY `minOrder` ASC [ RunTime:0.011037s ]
select * from pdf where partno='228CDVABFERB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFERB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924836 AND `partno` = '228CDVABFERB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449496 [ RunTime:0.018420s ]
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.089252s ]