SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002229s ]
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=70&srecordnum=10000' [ RunTime:0.004941s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002248s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000760s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002436s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001831s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002695s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001820s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001314s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.009858s ]
UPDATE `stock_search` SET `count` = 1944 , `updatetime` = '2026-06-12 07:53:43' WHERE `partno` = '228' [ RunTime:0.010553s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001385s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000250s ]
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.002237s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002179s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.267312s ]
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 1380,20 [ RunTime:0.113926s ]
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 ('32925542','32925541','32925540','32925539','32925538','32925537','32925536','32925535','32925534','32925533','32925532','32925531','32925530','32925529','32925528','32925527','32925526','32925525','32925524','32925523') ORDER BY FIELD(s.id, 32925542,32925541,32925540,32925539,32925538,32925537,32925536,32925535,32925534,32925533,32925532,32925531,32925530,32925529,32925528,32925527,32925526,32925525,32925524,32925523) [ RunTime:0.009597s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925542 LIMIT 4 [ RunTime:0.003092s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925542 ORDER BY `minOrder` ASC [ RunTime:0.005611s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925542 ORDER BY `unit` DESC [ RunTime:0.007344s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925542 LIMIT 2 [ RunTime:0.011167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925542 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
select * from pdf where partno='228ADS1AAWFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011047s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015095s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925542 AND `partno` = '228ADS1AAWFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449751 [ RunTime:0.009780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925541 LIMIT 4 [ RunTime:0.003362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925541 ORDER BY `minOrder` ASC [ RunTime:0.018290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925541 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925541 LIMIT 2 [ RunTime:0.021978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925541 ORDER BY `minOrder` ASC [ RunTime:0.016828s ]
select * from pdf where partno='228ADS1ARBFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010606s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925541 AND `partno` = '228ADS1ARBFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449750 [ RunTime:0.019316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925540 LIMIT 4 [ RunTime:0.020754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925540 ORDER BY `minOrder` ASC [ RunTime:0.013026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925540 ORDER BY `unit` DESC [ RunTime:0.010036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925540 LIMIT 2 [ RunTime:0.030376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925540 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='228ADS1ARFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026250s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925540 AND `partno` = '228ADS1ARFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449749 [ RunTime:0.018031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925539 LIMIT 4 [ RunTime:0.016061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925539 ORDER BY `minOrder` ASC [ RunTime:0.023544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925539 ORDER BY `unit` DESC [ RunTime:0.019475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925539 LIMIT 2 [ RunTime:0.034374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925539 ORDER BY `minOrder` ASC [ RunTime:0.023216s ]
select * from pdf where partno='228ADS1AYGFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.035560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041438s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925539 AND `partno` = '228ADS1AYGFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.079785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449748 [ RunTime:0.021896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925538 LIMIT 4 [ RunTime:0.013025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925538 ORDER BY `minOrder` ASC [ RunTime:0.022765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925538 ORDER BY `unit` DESC [ RunTime:0.018655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925538 LIMIT 2 [ RunTime:0.014796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925538 ORDER BY `minOrder` ASC [ RunTime:0.006134s ]
select * from pdf where partno='228ADS1ARFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020260s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925538 AND `partno` = '228ADS1ARFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449747 [ RunTime:0.015474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925537 LIMIT 4 [ RunTime:0.005763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925537 ORDER BY `minOrder` ASC [ RunTime:0.046597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925537 ORDER BY `unit` DESC [ RunTime:0.029269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925537 LIMIT 2 [ RunTime:0.010801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925537 ORDER BY `minOrder` ASC [ RunTime:0.002955s ]
select * from pdf where partno='228ADS1ARFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.027271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016502s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925537 AND `partno` = '228ADS1ARFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366460 [ RunTime:0.052160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925536 LIMIT 4 [ RunTime:0.025920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925536 ORDER BY `minOrder` ASC [ RunTime:0.020103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925536 ORDER BY `unit` DESC [ RunTime:0.013936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925536 LIMIT 2 [ RunTime:0.007771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925536 ORDER BY `minOrder` ASC [ RunTime:0.005556s ]
select * from pdf where partno='228ADS1AYGFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011615s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925536 AND `partno` = '228ADS1AYGFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925535 LIMIT 4 [ RunTime:0.010545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925535 ORDER BY `minOrder` ASC [ RunTime:0.008946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925535 ORDER BY `unit` DESC [ RunTime:0.027092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925535 LIMIT 2 [ RunTime:0.022533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925535 ORDER BY `minOrder` ASC [ RunTime:0.023594s ]
select * from pdf where partno='228ADS1AGFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033859s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925535 AND `partno` = '228ADS1AGFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925534 LIMIT 4 [ RunTime:0.019896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925534 ORDER BY `minOrder` ASC [ RunTime:0.018477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925534 ORDER BY `unit` DESC [ RunTime:0.019001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925534 LIMIT 2 [ RunTime:0.012351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925534 ORDER BY `minOrder` ASC [ RunTime:0.022990s ]
select * from pdf where partno='228ADS1ARFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.027514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034521s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925534 AND `partno` = '228ADS1ARFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925533 LIMIT 4 [ RunTime:0.005229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925533 ORDER BY `minOrder` ASC [ RunTime:0.023072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925533 ORDER BY `unit` DESC [ RunTime:0.062733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925533 LIMIT 2 [ RunTime:0.019949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925533 ORDER BY `minOrder` ASC [ RunTime:0.023354s ]
select * from pdf where partno='228ADS1AYGFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026565s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925533 AND `partno` = '228ADS1AYGFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.099967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925532 LIMIT 4 [ RunTime:0.011900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925532 ORDER BY `minOrder` ASC [ RunTime:0.018337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925532 ORDER BY `unit` DESC [ RunTime:0.020667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925532 LIMIT 2 [ RunTime:0.047877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925532 ORDER BY `minOrder` ASC [ RunTime:0.007415s ]
select * from pdf where partno='228ADS1ARGFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.031821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026842s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925532 AND `partno` = '228ADS1ARGFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449746 [ RunTime:0.022991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925531 LIMIT 4 [ RunTime:0.021461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925531 ORDER BY `minOrder` ASC [ RunTime:0.022945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925531 ORDER BY `unit` DESC [ RunTime:0.026200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925531 LIMIT 2 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925531 ORDER BY `minOrder` ASC [ RunTime:0.004703s ]
select * from pdf where partno='228ADS1AGFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029456s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925531 AND `partno` = '228ADS1AGFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.050088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366459 [ RunTime:0.043224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925530 LIMIT 4 [ RunTime:0.030785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925530 ORDER BY `minOrder` ASC [ RunTime:0.060908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925530 ORDER BY `unit` DESC [ RunTime:0.014885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925530 LIMIT 2 [ RunTime:0.067566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925530 ORDER BY `minOrder` ASC [ RunTime:0.013256s ]
select * from pdf where partno='228ADS1AAWFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015615s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925530 AND `partno` = '228ADS1AAWFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.067845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925529 LIMIT 4 [ RunTime:0.028737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925529 ORDER BY `minOrder` ASC [ RunTime:0.016783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925529 ORDER BY `unit` DESC [ RunTime:0.048102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925529 LIMIT 2 [ RunTime:0.015082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925529 ORDER BY `minOrder` ASC [ RunTime:0.011879s ]
select * from pdf where partno='228ADS1ABFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032757s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925529 AND `partno` = '228ADS1ABFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925528 LIMIT 4 [ RunTime:0.007655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925528 ORDER BY `minOrder` ASC [ RunTime:0.023799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925528 ORDER BY `unit` DESC [ RunTime:0.016338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925528 LIMIT 2 [ RunTime:0.015956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925528 ORDER BY `minOrder` ASC [ RunTime:0.021560s ]
select * from pdf where partno='228ADS1AYFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012059s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925528 AND `partno` = '228ADS1AYFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366458 [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925527 LIMIT 4 [ RunTime:0.014637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925527 ORDER BY `minOrder` ASC [ RunTime:0.063275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925527 ORDER BY `unit` DESC [ RunTime:0.053867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925527 LIMIT 2 [ RunTime:0.019091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925527 ORDER BY `minOrder` ASC [ RunTime:0.033056s ]
select * from pdf where partno='228ADS1AAFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.038377s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925527 AND `partno` = '228ADS1AAFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449745 [ RunTime:0.013845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925526 LIMIT 4 [ RunTime:0.037966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925526 ORDER BY `minOrder` ASC [ RunTime:0.011992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925526 ORDER BY `unit` DESC [ RunTime:0.034861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925526 LIMIT 2 [ RunTime:0.021601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925526 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
select * from pdf where partno='228ADS1AYGFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027609s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925526 AND `partno` = '228ADS1AYGFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366457 [ RunTime:0.049882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925525 LIMIT 4 [ RunTime:0.040417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925525 ORDER BY `minOrder` ASC [ RunTime:0.027702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925525 ORDER BY `unit` DESC [ RunTime:0.040723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925525 LIMIT 2 [ RunTime:0.033877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925525 ORDER BY `minOrder` ASC [ RunTime:0.001358s ]
select * from pdf where partno='228ADS1AAFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020210s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925525 AND `partno` = '228ADS1AAFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449744 [ RunTime:0.031747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925524 LIMIT 4 [ RunTime:0.018555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925524 ORDER BY `minOrder` ASC [ RunTime:0.027939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925524 ORDER BY `unit` DESC [ RunTime:0.036358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925524 LIMIT 2 [ RunTime:0.080012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925524 ORDER BY `minOrder` ASC [ RunTime:0.008189s ]
select * from pdf where partno='228ADS1ARAFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027927s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925524 AND `partno` = '228ADS1ARAFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.043567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449743 [ RunTime:0.044755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925523 LIMIT 4 [ RunTime:0.086935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925523 ORDER BY `minOrder` ASC [ RunTime:0.084515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925523 ORDER BY `unit` DESC [ RunTime:0.056454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925523 LIMIT 2 [ RunTime:0.081019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925523 ORDER BY `minOrder` ASC [ RunTime:0.034344s ]
select * from pdf where partno='228ADS1AYFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036995s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925523 AND `partno` = '228ADS1AYFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.069675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366456 [ RunTime:0.050944s ]
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.132567s ]