SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002965s ]
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=65&srecordnum=10000' [ RunTime:0.002701s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001503s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002088s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001531s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001793s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002233s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000601s ]
UPDATE `stock_search` SET `count` = 1188 , `updatetime` = '2026-06-12 02:53:42' WHERE `partno` = '228' [ RunTime:0.006036s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000242s ]
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.001455s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002155s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.103774s ]
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 1280,20 [ RunTime:0.092768s ]
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 ('32925642','32925641','32925640','32925639','32925638','32925637','32925636','32925635','32925634','32925633','32925632','32925631','32925630','32925629','32925628','32925627','32925626','32925625','32925624','32925623') ORDER BY FIELD(s.id, 32925642,32925641,32925640,32925639,32925638,32925637,32925636,32925635,32925634,32925633,32925632,32925631,32925630,32925629,32925628,32925627,32925626,32925625,32925624,32925623) [ RunTime:0.030127s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925642 LIMIT 4 [ RunTime:0.034119s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925642 ORDER BY `minOrder` ASC [ RunTime:0.026910s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925642 ORDER BY `unit` DESC [ RunTime:0.021344s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925642 LIMIT 2 [ RunTime:0.012442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925642 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
select * from pdf where partno='228ADS1AGFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.040124s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008455s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925642 AND `partno` = '228ADS1AGFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925641 LIMIT 4 [ RunTime:0.023550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925641 ORDER BY `minOrder` ASC [ RunTime:0.046556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925641 ORDER BY `unit` DESC [ RunTime:0.023100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925641 LIMIT 2 [ RunTime:0.024708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925641 ORDER BY `minOrder` ASC [ RunTime:0.010740s ]
select * from pdf where partno='228ADS1AAFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035065s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925641 AND `partno` = '228ADS1AAFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925640 LIMIT 4 [ RunTime:0.067298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925640 ORDER BY `minOrder` ASC [ RunTime:0.058257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925640 ORDER BY `unit` DESC [ RunTime:0.035200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925640 LIMIT 2 [ RunTime:0.023591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925640 ORDER BY `minOrder` ASC [ RunTime:0.006580s ]
select * from pdf where partno='228ADS1AYFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016561s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925640 AND `partno` = '228ADS1AYFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449798 [ RunTime:0.036589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925639 LIMIT 4 [ RunTime:0.017058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925639 ORDER BY `minOrder` ASC [ RunTime:0.012640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925639 ORDER BY `unit` DESC [ RunTime:0.031085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925639 LIMIT 2 [ RunTime:0.004452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925639 ORDER BY `minOrder` ASC [ RunTime:0.009331s ]
select * from pdf where partno='228ADS1ARAFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015507s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925639 AND `partno` = '228ADS1ARAFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366488 [ RunTime:0.013975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925638 LIMIT 4 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925638 ORDER BY `minOrder` ASC [ RunTime:0.007498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925638 ORDER BY `unit` DESC [ RunTime:0.015790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925638 LIMIT 2 [ RunTime:0.015723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925638 ORDER BY `minOrder` ASC [ RunTime:0.015601s ]
select * from pdf where partno='228ADS1AYFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007157s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925638 AND `partno` = '228ADS1AYFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449797 [ RunTime:0.023161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925637 LIMIT 4 [ RunTime:0.009308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925637 ORDER BY `minOrder` ASC [ RunTime:0.033211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925637 ORDER BY `unit` DESC [ RunTime:0.014224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925637 LIMIT 2 [ RunTime:0.056211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925637 ORDER BY `minOrder` ASC [ RunTime:0.019971s ]
select * from pdf where partno='228ADS1AGFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012123s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925637 AND `partno` = '228ADS1AGFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366487 [ RunTime:0.011419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925636 LIMIT 4 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925636 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925636 ORDER BY `unit` DESC [ RunTime:0.013085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925636 LIMIT 2 [ RunTime:0.022863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925636 ORDER BY `minOrder` ASC [ RunTime:0.007338s ]
select * from pdf where partno='228ADS1ARAFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008469s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925636 AND `partno` = '228ADS1ARAFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925635 LIMIT 4 [ RunTime:0.074901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925635 ORDER BY `minOrder` ASC [ RunTime:0.034321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925635 ORDER BY `unit` DESC [ RunTime:0.036575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925635 LIMIT 2 [ RunTime:0.005195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925635 ORDER BY `minOrder` ASC [ RunTime:0.019527s ]
select * from pdf where partno='228ADS1ARAFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025549s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925635 AND `partno` = '228ADS1ARAFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925634 LIMIT 4 [ RunTime:0.008639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925634 ORDER BY `minOrder` ASC [ RunTime:0.064523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925634 ORDER BY `unit` DESC [ RunTime:0.013351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925634 LIMIT 2 [ RunTime:0.010312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925634 ORDER BY `minOrder` ASC [ RunTime:0.034092s ]
select * from pdf where partno='228ADS1AGFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035710s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925634 AND `partno` = '228ADS1AGFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366486 [ RunTime:0.014517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925633 LIMIT 4 [ RunTime:0.029673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925633 ORDER BY `minOrder` ASC [ RunTime:0.017984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925633 ORDER BY `unit` DESC [ RunTime:0.024329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925633 LIMIT 2 [ RunTime:0.020781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925633 ORDER BY `minOrder` ASC [ RunTime:0.004877s ]
select * from pdf where partno='228ADS1AYGFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021724s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925633 AND `partno` = '228ADS1AYGFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366485 [ RunTime:0.030902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925632 LIMIT 4 [ RunTime:0.019433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925632 ORDER BY `minOrder` ASC [ RunTime:0.007862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925632 ORDER BY `unit` DESC [ RunTime:0.005126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925632 LIMIT 2 [ RunTime:0.011568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925632 ORDER BY `minOrder` ASC [ RunTime:0.030759s ]
select * from pdf where partno='228ADS1ARBFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015858s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925632 AND `partno` = '228ADS1ARBFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366484 [ RunTime:0.012933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925631 LIMIT 4 [ RunTime:0.014123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925631 ORDER BY `minOrder` ASC [ RunTime:0.009789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925631 ORDER BY `unit` DESC [ RunTime:0.015093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925631 LIMIT 2 [ RunTime:0.010806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925631 ORDER BY `minOrder` ASC [ RunTime:0.019302s ]
select * from pdf where partno='228ADS1ARGFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011725s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925631 AND `partno` = '228ADS1ARGFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366483 [ RunTime:0.036974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925630 LIMIT 4 [ RunTime:0.009480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925630 ORDER BY `minOrder` ASC [ RunTime:0.013786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925630 ORDER BY `unit` DESC [ RunTime:0.041390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925630 LIMIT 2 [ RunTime:0.087374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925630 ORDER BY `minOrder` ASC [ RunTime:0.016317s ]
select * from pdf where partno='228ADS1ARBFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.035643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023880s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925630 AND `partno` = '228ADS1ARBFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449796 [ RunTime:0.044681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925629 LIMIT 4 [ RunTime:0.034012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925629 ORDER BY `minOrder` ASC [ RunTime:0.010871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925629 ORDER BY `unit` DESC [ RunTime:0.010764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925629 LIMIT 2 [ RunTime:0.026519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925629 ORDER BY `minOrder` ASC [ RunTime:0.003166s ]
select * from pdf where partno='228ADS1ARAFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036906s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925629 AND `partno` = '228ADS1ARAFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449795 [ RunTime:0.017941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925628 LIMIT 4 [ RunTime:0.006425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925628 ORDER BY `minOrder` ASC [ RunTime:0.014991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925628 ORDER BY `unit` DESC [ RunTime:0.017064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925628 LIMIT 2 [ RunTime:0.003262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925628 ORDER BY `minOrder` ASC [ RunTime:0.005832s ]
select * from pdf where partno='228ADS1AAFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014051s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925628 AND `partno` = '228ADS1AAFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449794 [ RunTime:0.008522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925627 LIMIT 4 [ RunTime:0.001997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925627 ORDER BY `minOrder` ASC [ RunTime:0.004319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925627 ORDER BY `unit` DESC [ RunTime:0.013898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925627 LIMIT 2 [ RunTime:0.011332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925627 ORDER BY `minOrder` ASC [ RunTime:0.004130s ]
select * from pdf where partno='228ADS1AYGFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002957s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925627 AND `partno` = '228ADS1AYGFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366482 [ RunTime:0.004874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925626 LIMIT 4 [ RunTime:0.014759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925626 ORDER BY `minOrder` ASC [ RunTime:0.016318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925626 ORDER BY `unit` DESC [ RunTime:0.007109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925626 LIMIT 2 [ RunTime:0.011899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925626 ORDER BY `minOrder` ASC [ RunTime:0.013270s ]
select * from pdf where partno='228ADS1AYGFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008909s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925626 AND `partno` = '228ADS1AYGFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449793 [ RunTime:0.033297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925625 LIMIT 4 [ RunTime:0.019288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925625 ORDER BY `minOrder` ASC [ RunTime:0.007384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925625 ORDER BY `unit` DESC [ RunTime:0.014407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925625 LIMIT 2 [ RunTime:0.020884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925625 ORDER BY `minOrder` ASC [ RunTime:0.007021s ]
select * from pdf where partno='228ADS1AYGFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014337s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925625 AND `partno` = '228ADS1AYGFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366481 [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925624 LIMIT 4 [ RunTime:0.005610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925624 ORDER BY `minOrder` ASC [ RunTime:0.019094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925624 ORDER BY `unit` DESC [ RunTime:0.006347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925624 LIMIT 2 [ RunTime:0.008964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925624 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
select * from pdf where partno='228ADS1ARGFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009159s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925624 AND `partno` = '228ADS1ARGFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925623 LIMIT 4 [ RunTime:0.019331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925623 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925623 ORDER BY `unit` DESC [ RunTime:0.022366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925623 LIMIT 2 [ RunTime:0.012722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925623 ORDER BY `minOrder` ASC [ RunTime:0.008539s ]
select * from pdf where partno='228ADS1ARFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020635s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925623 AND `partno` = '228ADS1ARFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035090s ]
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.009199s ]