SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002719s ]
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=69&srecordnum=10000' [ RunTime:0.004949s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001292s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002959s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001597s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.009820s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001548s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003498s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001420s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.005139s ]
UPDATE `stock_search` SET `count` = 1945 , `updatetime` = '2026-06-12 07:53:43' WHERE `partno` = '228' [ RunTime:0.017661s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003993s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.010062s ]
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.002186s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002363s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.210157s ]
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 1360,20 [ RunTime:0.113771s ]
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 ('32925562','32925561','32925560','32925559','32925558','32925557','32925556','32925555','32925554','32925553','32925552','32925551','32925550','32925549','32925548','32925547','32925546','32925545','32925544','32925543') ORDER BY FIELD(s.id, 32925562,32925561,32925560,32925559,32925558,32925557,32925556,32925555,32925554,32925553,32925552,32925551,32925550,32925549,32925548,32925547,32925546,32925545,32925544,32925543) [ RunTime:0.013058s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925562 LIMIT 4 [ RunTime:0.003557s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925562 ORDER BY `minOrder` ASC [ RunTime:0.004457s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925562 ORDER BY `unit` DESC [ RunTime:0.016113s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925562 LIMIT 2 [ RunTime:0.013062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925562 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='228ADS1AAFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007489s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015504s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925562 AND `partno` = '228ADS1AAFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925561 LIMIT 4 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925561 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925561 ORDER BY `unit` DESC [ RunTime:0.003127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925561 LIMIT 2 [ RunTime:0.015561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925561 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
select * from pdf where partno='228ADS1AAWFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016811s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925561 AND `partno` = '228ADS1AAWFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925560 LIMIT 4 [ RunTime:0.006332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925560 ORDER BY `minOrder` ASC [ RunTime:0.028454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925560 ORDER BY `unit` DESC [ RunTime:0.016309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925560 LIMIT 2 [ RunTime:0.008765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925560 ORDER BY `minOrder` ASC [ RunTime:0.016800s ]
select * from pdf where partno='228ADS1AAFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010089s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925560 AND `partno` = '228ADS1AAFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449765 [ RunTime:0.021572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925559 LIMIT 4 [ RunTime:0.025660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925559 ORDER BY `minOrder` ASC [ RunTime:0.018655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925559 ORDER BY `unit` DESC [ RunTime:0.024506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925559 LIMIT 2 [ RunTime:0.028469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925559 ORDER BY `minOrder` ASC [ RunTime:0.017384s ]
select * from pdf where partno='228ADS1ARGFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033716s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925559 AND `partno` = '228ADS1ARGFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.047055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449764 [ RunTime:0.042790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925558 LIMIT 4 [ RunTime:0.011517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925558 ORDER BY `minOrder` ASC [ RunTime:0.041042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925558 ORDER BY `unit` DESC [ RunTime:0.059063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925558 LIMIT 2 [ RunTime:0.018829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925558 ORDER BY `minOrder` ASC [ RunTime:0.015296s ]
select * from pdf where partno='228ADS1ARFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006813s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925558 AND `partno` = '228ADS1ARFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449763 [ RunTime:0.009886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925557 LIMIT 4 [ RunTime:0.011138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925557 ORDER BY `minOrder` ASC [ RunTime:0.022457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925557 ORDER BY `unit` DESC [ RunTime:0.023126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925557 LIMIT 2 [ RunTime:0.037414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925557 ORDER BY `minOrder` ASC [ RunTime:0.017021s ]
select * from pdf where partno='228ADS1AYFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014347s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925557 AND `partno` = '228ADS1AYFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449762 [ RunTime:0.031891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925556 LIMIT 4 [ RunTime:0.034327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925556 ORDER BY `minOrder` ASC [ RunTime:0.013245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925556 ORDER BY `unit` DESC [ RunTime:0.059272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925556 LIMIT 2 [ RunTime:0.017618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925556 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
select * from pdf where partno='228ADS1ARBFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005509s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925556 AND `partno` = '228ADS1ARBFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449761 [ RunTime:0.010525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925555 LIMIT 4 [ RunTime:0.007822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925555 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925555 ORDER BY `unit` DESC [ RunTime:0.016382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925555 LIMIT 2 [ RunTime:0.020228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925555 ORDER BY `minOrder` ASC [ RunTime:0.008969s ]
select * from pdf where partno='228ADS1ARFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027839s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925555 AND `partno` = '228ADS1ARFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366462 [ RunTime:0.009288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925554 LIMIT 4 [ RunTime:0.028631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925554 ORDER BY `minOrder` ASC [ RunTime:0.033551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925554 ORDER BY `unit` DESC [ RunTime:0.037533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925554 LIMIT 2 [ RunTime:0.074490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925554 ORDER BY `minOrder` ASC [ RunTime:0.013951s ]
select * from pdf where partno='228ADS1ARGFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018424s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925554 AND `partno` = '228ADS1ARGFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.052791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449760 [ RunTime:0.045833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925553 LIMIT 4 [ RunTime:0.011088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925553 ORDER BY `minOrder` ASC [ RunTime:0.028567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925553 ORDER BY `unit` DESC [ RunTime:0.080910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925553 LIMIT 2 [ RunTime:0.028365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925553 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
select * from pdf where partno='228ADS1ABFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009656s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925553 AND `partno` = '228ADS1ABFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.041373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366461 [ RunTime:0.062559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925552 LIMIT 4 [ RunTime:0.013498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925552 ORDER BY `minOrder` ASC [ RunTime:0.034634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925552 ORDER BY `unit` DESC [ RunTime:0.029455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925552 LIMIT 2 [ RunTime:0.018091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925552 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
select * from pdf where partno='228ADS1ABFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012546s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925552 AND `partno` = '228ADS1ABFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449759 [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925551 LIMIT 4 [ RunTime:0.009923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925551 ORDER BY `minOrder` ASC [ RunTime:0.025240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925551 ORDER BY `unit` DESC [ RunTime:0.034000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925551 LIMIT 2 [ RunTime:0.053276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925551 ORDER BY `minOrder` ASC [ RunTime:0.020571s ]
select * from pdf where partno='228ADS1AYGFCYG' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCYG' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.054391s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925551 AND `partno` = '228ADS1AYGFCYG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449758 [ RunTime:0.033068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925550 LIMIT 4 [ RunTime:0.013844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925550 ORDER BY `minOrder` ASC [ RunTime:0.025227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925550 ORDER BY `unit` DESC [ RunTime:0.028720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925550 LIMIT 2 [ RunTime:0.029098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925550 ORDER BY `minOrder` ASC [ RunTime:0.053479s ]
select * from pdf where partno='228ADS1AAFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033128s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925550 AND `partno` = '228ADS1AAFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449757 [ RunTime:0.041184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925549 LIMIT 4 [ RunTime:0.022198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925549 ORDER BY `minOrder` ASC [ RunTime:0.026504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925549 ORDER BY `unit` DESC [ RunTime:0.027987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925549 LIMIT 2 [ RunTime:0.010714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925549 ORDER BY `minOrder` ASC [ RunTime:0.008079s ]
select * from pdf where partno='228ADS1ARFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010082s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925549 AND `partno` = '228ADS1ARFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.042141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449756 [ RunTime:0.016197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925548 LIMIT 4 [ RunTime:0.022050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925548 ORDER BY `minOrder` ASC [ RunTime:0.009759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925548 ORDER BY `unit` DESC [ RunTime:0.014932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925548 LIMIT 2 [ RunTime:0.032448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925548 ORDER BY `minOrder` ASC [ RunTime:0.016855s ]
select * from pdf where partno='228ADS1AAWFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041365s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925548 AND `partno` = '228ADS1AAWFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449755 [ RunTime:0.040939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925547 LIMIT 4 [ RunTime:0.034277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925547 ORDER BY `minOrder` ASC [ RunTime:0.023627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925547 ORDER BY `unit` DESC [ RunTime:0.016524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925547 LIMIT 2 [ RunTime:0.013158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925547 ORDER BY `minOrder` ASC [ RunTime:0.021422s ]
select * from pdf where partno='228ADS1ABFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018892s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925547 AND `partno` = '228ADS1ABFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.067472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925546 LIMIT 4 [ RunTime:0.038013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925546 ORDER BY `minOrder` ASC [ RunTime:0.012619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925546 ORDER BY `unit` DESC [ RunTime:0.038676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925546 LIMIT 2 [ RunTime:0.036642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925546 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
select * from pdf where partno='228ADS1AYGFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021959s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925546 AND `partno` = '228ADS1AYGFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925545 LIMIT 4 [ RunTime:0.021267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925545 ORDER BY `minOrder` ASC [ RunTime:0.031568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925545 ORDER BY `unit` DESC [ RunTime:0.013118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925545 LIMIT 2 [ RunTime:0.023709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925545 ORDER BY `minOrder` ASC [ RunTime:0.009595s ]
select * from pdf where partno='228ADS1AAFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.040001s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925545 AND `partno` = '228ADS1AAFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449754 [ RunTime:0.017125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925544 LIMIT 4 [ RunTime:0.034513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925544 ORDER BY `minOrder` ASC [ RunTime:0.058299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925544 ORDER BY `unit` DESC [ RunTime:0.038721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925544 LIMIT 2 [ RunTime:0.030437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925544 ORDER BY `minOrder` ASC [ RunTime:0.012696s ]
select * from pdf where partno='228ADS1ARBFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026393s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925544 AND `partno` = '228ADS1ARBFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.113054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449753 [ RunTime:0.076943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925543 LIMIT 4 [ RunTime:0.031161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925543 ORDER BY `minOrder` ASC [ RunTime:0.045880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925543 ORDER BY `unit` DESC [ RunTime:0.049388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925543 LIMIT 2 [ RunTime:0.029396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925543 ORDER BY `minOrder` ASC [ RunTime:0.015595s ]
select * from pdf where partno='228ADS1AGFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.035466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016140s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925543 AND `partno` = '228ADS1AGFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.062793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449752 [ RunTime:0.064144s ]
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.147011s ]