SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002332s ]
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=66&srecordnum=10000' [ RunTime:0.012034s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003498s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003521s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003345s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.005617s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002148s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007800s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002280s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.011166s ]
UPDATE `stock_search` SET `count` = 1946 , `updatetime` = '2026-06-12 07:53:43' WHERE `partno` = '228' [ RunTime:0.005303s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001310s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000299s ]
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.000470s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002901s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.213036s ]
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 1300,20 [ RunTime:0.105075s ]
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 ('32925622','32925621','32925620','32925619','32925618','32925617','32925616','32925615','32925614','32925613','32925612','32925611','32925610','32925609','32925608','32925607','32925606','32925605','32925604','32925603') ORDER BY FIELD(s.id, 32925622,32925621,32925620,32925619,32925618,32925617,32925616,32925615,32925614,32925613,32925612,32925611,32925610,32925609,32925608,32925607,32925606,32925605,32925604,32925603) [ RunTime:0.018610s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925622 LIMIT 4 [ RunTime:0.004024s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925622 ORDER BY `minOrder` ASC [ RunTime:0.007386s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925622 ORDER BY `unit` DESC [ RunTime:0.011155s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925622 LIMIT 2 [ RunTime:0.016731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925622 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
select * from pdf where partno='228ADS1ARGFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012051s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012990s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925622 AND `partno` = '228ADS1ARGFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449792 [ RunTime:0.009361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925621 LIMIT 4 [ RunTime:0.005594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925621 ORDER BY `minOrder` ASC [ RunTime:0.014160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925621 ORDER BY `unit` DESC [ RunTime:0.007160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925621 LIMIT 2 [ RunTime:0.023987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925621 ORDER BY `minOrder` ASC [ RunTime:0.010400s ]
select * from pdf where partno='228ADS1ARFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015066s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925621 AND `partno` = '228ADS1ARFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366480 [ RunTime:0.023571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925620 LIMIT 4 [ RunTime:0.009730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925620 ORDER BY `minOrder` ASC [ RunTime:0.015666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925620 ORDER BY `unit` DESC [ RunTime:0.008166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925620 LIMIT 2 [ RunTime:0.005186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925620 ORDER BY `minOrder` ASC [ RunTime:0.017994s ]
select * from pdf where partno='228ADS1AYFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.030755s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925620 AND `partno` = '228ADS1AYFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366479 [ RunTime:0.023282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925619 LIMIT 4 [ RunTime:0.018567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925619 ORDER BY `minOrder` ASC [ RunTime:0.012762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925619 ORDER BY `unit` DESC [ RunTime:0.069064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925619 LIMIT 2 [ RunTime:0.031678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925619 ORDER BY `minOrder` ASC [ RunTime:0.012629s ]
select * from pdf where partno='228ADS1AYGFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023612s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925619 AND `partno` = '228ADS1AYGFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366478 [ RunTime:0.043296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925618 LIMIT 4 [ RunTime:0.005469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925618 ORDER BY `minOrder` ASC [ RunTime:0.013907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925618 ORDER BY `unit` DESC [ RunTime:0.015122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925618 LIMIT 2 [ RunTime:0.011732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925618 ORDER BY `minOrder` ASC [ RunTime:0.022516s ]
select * from pdf where partno='228ADS1AAFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009890s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925618 AND `partno` = '228ADS1AAFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449791 [ RunTime:0.021276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925617 LIMIT 4 [ RunTime:0.021665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925617 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925617 ORDER BY `unit` DESC [ RunTime:0.013447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925617 LIMIT 2 [ RunTime:0.026966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925617 ORDER BY `minOrder` ASC [ RunTime:0.023928s ]
select * from pdf where partno='228ADS1ARAFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010610s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925617 AND `partno` = '228ADS1ARAFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925616 LIMIT 4 [ RunTime:0.026255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925616 ORDER BY `minOrder` ASC [ RunTime:0.053996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925616 ORDER BY `unit` DESC [ RunTime:0.042636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925616 LIMIT 2 [ RunTime:0.017994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925616 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
select * from pdf where partno='228ADS1ARFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006005s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925616 AND `partno` = '228ADS1ARFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925615 LIMIT 4 [ RunTime:0.007159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925615 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925615 ORDER BY `unit` DESC [ RunTime:0.014689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925615 LIMIT 2 [ RunTime:0.004945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925615 ORDER BY `minOrder` ASC [ RunTime:0.003133s ]
select * from pdf where partno='228ADS1AAFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029122s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925615 AND `partno` = '228ADS1AAFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449790 [ RunTime:0.044300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925614 LIMIT 4 [ RunTime:0.025681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925614 ORDER BY `minOrder` ASC [ RunTime:0.017540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925614 ORDER BY `unit` DESC [ RunTime:0.022057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925614 LIMIT 2 [ RunTime:0.006918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925614 ORDER BY `minOrder` ASC [ RunTime:0.008765s ]
select * from pdf where partno='228ADS1ARAFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022430s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925614 AND `partno` = '228ADS1ARAFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366477 [ RunTime:0.011561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925613 LIMIT 4 [ RunTime:0.028356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925613 ORDER BY `minOrder` ASC [ RunTime:0.025250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925613 ORDER BY `unit` DESC [ RunTime:0.017979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925613 LIMIT 2 [ RunTime:0.025253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925613 ORDER BY `minOrder` ASC [ RunTime:0.019670s ]
select * from pdf where partno='228ADS1AYFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.053335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028913s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925613 AND `partno` = '228ADS1AYFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366476 [ RunTime:0.064074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925612 LIMIT 4 [ RunTime:0.010768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925612 ORDER BY `minOrder` ASC [ RunTime:0.025624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925612 ORDER BY `unit` DESC [ RunTime:0.016078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925612 LIMIT 2 [ RunTime:0.039494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925612 ORDER BY `minOrder` ASC [ RunTime:0.013539s ]
select * from pdf where partno='228ADS1ARAFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.053448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031865s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925612 AND `partno` = '228ADS1ARAFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449789 [ RunTime:0.023204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925611 LIMIT 4 [ RunTime:0.016598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925611 ORDER BY `minOrder` ASC [ RunTime:0.016917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925611 ORDER BY `unit` DESC [ RunTime:0.016916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925611 LIMIT 2 [ RunTime:0.026329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925611 ORDER BY `minOrder` ASC [ RunTime:0.012184s ]
select * from pdf where partno='228ADS1ARAFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012348s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925611 AND `partno` = '228ADS1ARAFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366475 [ RunTime:0.030732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925610 LIMIT 4 [ RunTime:0.045474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925610 ORDER BY `minOrder` ASC [ RunTime:0.014626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925610 ORDER BY `unit` DESC [ RunTime:0.015066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925610 LIMIT 2 [ RunTime:0.053753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925610 ORDER BY `minOrder` ASC [ RunTime:0.032590s ]
select * from pdf where partno='228ADS1AAWFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039528s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925610 AND `partno` = '228ADS1AAWFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449788 [ RunTime:0.027380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925609 LIMIT 4 [ RunTime:0.031517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925609 ORDER BY `minOrder` ASC [ RunTime:0.054596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925609 ORDER BY `unit` DESC [ RunTime:0.046234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925609 LIMIT 2 [ RunTime:0.018253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925609 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
select * from pdf where partno='228ADS1AYFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.053199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018065s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925609 AND `partno` = '228ADS1AYFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449787 [ RunTime:0.046614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925608 LIMIT 4 [ RunTime:0.036223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925608 ORDER BY `minOrder` ASC [ RunTime:0.040120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925608 ORDER BY `unit` DESC [ RunTime:0.007201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925608 LIMIT 2 [ RunTime:0.034275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925608 ORDER BY `minOrder` ASC [ RunTime:0.014734s ]
select * from pdf where partno='228ADS1ARAFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022441s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925608 AND `partno` = '228ADS1ARAFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449786 [ RunTime:0.019659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925607 LIMIT 4 [ RunTime:0.055954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925607 ORDER BY `minOrder` ASC [ RunTime:0.032998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925607 ORDER BY `unit` DESC [ RunTime:0.013984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925607 LIMIT 2 [ RunTime:0.056590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925607 ORDER BY `minOrder` ASC [ RunTime:0.008460s ]
select * from pdf where partno='228ADS1ARBFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.042488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028138s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925607 AND `partno` = '228ADS1ARBFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449785 [ RunTime:0.031037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925606 LIMIT 4 [ RunTime:0.033750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925606 ORDER BY `minOrder` ASC [ RunTime:0.028506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925606 ORDER BY `unit` DESC [ RunTime:0.011155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925606 LIMIT 2 [ RunTime:0.024443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925606 ORDER BY `minOrder` ASC [ RunTime:0.023945s ]
select * from pdf where partno='228ADS1ARGFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015974s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925606 AND `partno` = '228ADS1ARGFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449784 [ RunTime:0.009587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925605 LIMIT 4 [ RunTime:0.012138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925605 ORDER BY `minOrder` ASC [ RunTime:0.050987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925605 ORDER BY `unit` DESC [ RunTime:0.015030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925605 LIMIT 2 [ RunTime:0.015333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925605 ORDER BY `minOrder` ASC [ RunTime:0.006142s ]
select * from pdf where partno='228ADS1AAFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032774s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925605 AND `partno` = '228ADS1AAFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449783 [ RunTime:0.008417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925604 LIMIT 4 [ RunTime:0.019197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925604 ORDER BY `minOrder` ASC [ RunTime:0.053920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925604 ORDER BY `unit` DESC [ RunTime:0.061594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925604 LIMIT 2 [ RunTime:0.019670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925604 ORDER BY `minOrder` ASC [ RunTime:0.025295s ]
select * from pdf where partno='228ADS1ARFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.060896s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925604 AND `partno` = '228ADS1ARFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.099826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925603 LIMIT 4 [ RunTime:0.037175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925603 ORDER BY `minOrder` ASC [ RunTime:0.090065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925603 ORDER BY `unit` DESC [ RunTime:0.053472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925603 LIMIT 2 [ RunTime:0.042579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925603 ORDER BY `minOrder` ASC [ RunTime:0.051197s ]
select * from pdf where partno='228ADS1AYFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.047558s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925603 AND `partno` = '228ADS1AYFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.058528s ]
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.160326s ]