SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001401s ]
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=55&srecordnum=10000' [ RunTime:0.005259s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001388s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001817s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000919s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001630s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001910s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.004009s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003540s ]
UPDATE `stock_search` SET `count` = 1152 , `updatetime` = '2026-06-11 20:59:01' WHERE `partno` = '228' [ RunTime:0.005001s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000305s ]
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.001459s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001456s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.231638s ]
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 1080,20 [ RunTime:0.099952s ]
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 ('32925901','32925900','32925899','32925898','32925897','32925896','32925895','32925894','32925893','32925892','32925891','32925890','32925889','32925888','32925887','32925886','32925885','32925884','32925883','32925882') ORDER BY FIELD(s.id, 32925901,32925900,32925899,32925898,32925897,32925896,32925895,32925894,32925893,32925892,32925891,32925890,32925889,32925888,32925887,32925886,32925885,32925884,32925883,32925882) [ RunTime:0.007992s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925901 LIMIT 4 [ RunTime:0.002043s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925901 ORDER BY `minOrder` ASC [ RunTime:0.026862s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925901 ORDER BY `unit` DESC [ RunTime:0.009562s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925901 LIMIT 2 [ RunTime:0.013664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925901 ORDER BY `minOrder` ASC [ RunTime:0.006423s ]
select * from pdf where partno='228ADS1ARGFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004465s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008326s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925901 AND `partno` = '228ADS1ARGFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449871 [ RunTime:0.017355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925900 LIMIT 4 [ RunTime:0.008748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925900 ORDER BY `minOrder` ASC [ RunTime:0.003972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925900 ORDER BY `unit` DESC [ RunTime:0.014218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925900 LIMIT 2 [ RunTime:0.007639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925900 ORDER BY `minOrder` ASC [ RunTime:0.014943s ]
select * from pdf where partno='228ADS1AWFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015415s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925900 AND `partno` = '228ADS1AWFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366541 [ RunTime:0.018563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925899 LIMIT 4 [ RunTime:0.015441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925899 ORDER BY `minOrder` ASC [ RunTime:0.007941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925899 ORDER BY `unit` DESC [ RunTime:0.005170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925899 LIMIT 2 [ RunTime:0.006908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925899 ORDER BY `minOrder` ASC [ RunTime:0.006964s ]
select * from pdf where partno='228ADS1ABFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010202s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925899 AND `partno` = '228ADS1ABFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366540 [ RunTime:0.011839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925898 LIMIT 4 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925898 ORDER BY `minOrder` ASC [ RunTime:0.028103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925898 ORDER BY `unit` DESC [ RunTime:0.021910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925898 LIMIT 2 [ RunTime:0.012805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925898 ORDER BY `minOrder` ASC [ RunTime:0.003302s ]
select * from pdf where partno='228ADS1ABFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007919s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925898 AND `partno` = '228ADS1ABFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449870 [ RunTime:0.008455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925897 LIMIT 4 [ RunTime:0.021829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925897 ORDER BY `minOrder` ASC [ RunTime:0.032886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925897 ORDER BY `unit` DESC [ RunTime:0.022977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925897 LIMIT 2 [ RunTime:0.030773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925897 ORDER BY `minOrder` ASC [ RunTime:0.026072s ]
select * from pdf where partno='228ADS1AWFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.038699s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925897 AND `partno` = '228ADS1AWFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366539 [ RunTime:0.037992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925896 LIMIT 4 [ RunTime:0.019484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925896 ORDER BY `minOrder` ASC [ RunTime:0.015722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925896 ORDER BY `unit` DESC [ RunTime:0.054472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925896 LIMIT 2 [ RunTime:0.019483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925896 ORDER BY `minOrder` ASC [ RunTime:0.015008s ]
select * from pdf where partno='228ADS1AWFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032073s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925896 AND `partno` = '228ADS1AWFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366538 [ RunTime:0.025392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925895 LIMIT 4 [ RunTime:0.016593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925895 ORDER BY `minOrder` ASC [ RunTime:0.031958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925895 ORDER BY `unit` DESC [ RunTime:0.031369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925895 LIMIT 2 [ RunTime:0.049853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925895 ORDER BY `minOrder` ASC [ RunTime:0.035413s ]
select * from pdf where partno='228ADS1AWFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.061419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039864s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925895 AND `partno` = '228ADS1AWFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.034748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366537 [ RunTime:0.070183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925894 LIMIT 4 [ RunTime:0.035111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925894 ORDER BY `minOrder` ASC [ RunTime:0.046237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925894 ORDER BY `unit` DESC [ RunTime:0.039051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925894 LIMIT 2 [ RunTime:0.028873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925894 ORDER BY `minOrder` ASC [ RunTime:0.016411s ]
select * from pdf where partno='228ADS1AAWFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.050851s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925894 AND `partno` = '228ADS1AAWFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366536 [ RunTime:0.063434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925893 LIMIT 4 [ RunTime:0.028856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925893 ORDER BY `minOrder` ASC [ RunTime:0.050314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925893 ORDER BY `unit` DESC [ RunTime:0.041003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925893 LIMIT 2 [ RunTime:0.096330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925893 ORDER BY `minOrder` ASC [ RunTime:0.046244s ]
select * from pdf where partno='228ADS1AYFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039941s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925893 AND `partno` = '228ADS1AYFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366535 [ RunTime:0.100958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925892 LIMIT 4 [ RunTime:0.073874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925892 ORDER BY `minOrder` ASC [ RunTime:0.043082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925892 ORDER BY `unit` DESC [ RunTime:0.070839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925892 LIMIT 2 [ RunTime:0.033634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925892 ORDER BY `minOrder` ASC [ RunTime:0.033245s ]
select * from pdf where partno='228ADS1AWFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.042070s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925892 AND `partno` = '228ADS1AWFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366534 [ RunTime:0.041175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925891 LIMIT 4 [ RunTime:0.025519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925891 ORDER BY `minOrder` ASC [ RunTime:0.035199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925891 ORDER BY `unit` DESC [ RunTime:0.015106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925891 LIMIT 2 [ RunTime:0.065287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925891 ORDER BY `minOrder` ASC [ RunTime:0.062299s ]
select * from pdf where partno='228ADS1AWFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.060346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.046971s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925891 AND `partno` = '228ADS1AWFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449869 [ RunTime:0.023744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925890 LIMIT 4 [ RunTime:0.043951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925890 ORDER BY `minOrder` ASC [ RunTime:0.013212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925890 ORDER BY `unit` DESC [ RunTime:0.016580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925890 LIMIT 2 [ RunTime:0.026345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925890 ORDER BY `minOrder` ASC [ RunTime:0.009278s ]
select * from pdf where partno='228ADS1AGFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016250s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925890 AND `partno` = '228ADS1AGFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449868 [ RunTime:0.021049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925889 LIMIT 4 [ RunTime:0.034888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925889 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925889 ORDER BY `unit` DESC [ RunTime:0.006772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925889 LIMIT 2 [ RunTime:0.019169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925889 ORDER BY `minOrder` ASC [ RunTime:0.016581s ]
select * from pdf where partno='228ADS1ARGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041803s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925889 AND `partno` = '228ADS1ARGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449867 [ RunTime:0.047961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925888 LIMIT 4 [ RunTime:0.053198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925888 ORDER BY `minOrder` ASC [ RunTime:0.094965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925888 ORDER BY `unit` DESC [ RunTime:0.020627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925888 LIMIT 2 [ RunTime:0.006463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925888 ORDER BY `minOrder` ASC [ RunTime:0.015547s ]
select * from pdf where partno='228ADS1ARFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022217s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925888 AND `partno` = '228ADS1ARFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366533 [ RunTime:0.014274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925887 LIMIT 4 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925887 ORDER BY `minOrder` ASC [ RunTime:0.009403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925887 ORDER BY `unit` DESC [ RunTime:0.037155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925887 LIMIT 2 [ RunTime:0.037530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925887 ORDER BY `minOrder` ASC [ RunTime:0.001787s ]
select * from pdf where partno='228ADS1AWFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017677s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925887 AND `partno` = '228ADS1AWFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449866 [ RunTime:0.032049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925886 LIMIT 4 [ RunTime:0.042987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925886 ORDER BY `minOrder` ASC [ RunTime:0.015354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925886 ORDER BY `unit` DESC [ RunTime:0.043311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925886 LIMIT 2 [ RunTime:0.048535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925886 ORDER BY `minOrder` ASC [ RunTime:0.008821s ]
select * from pdf where partno='228ADS1ARGFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008078s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925886 AND `partno` = '228ADS1ARGFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449865 [ RunTime:0.020801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925885 LIMIT 4 [ RunTime:0.064016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925885 ORDER BY `minOrder` ASC [ RunTime:0.011630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925885 ORDER BY `unit` DESC [ RunTime:0.063248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925885 LIMIT 2 [ RunTime:0.021582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925885 ORDER BY `minOrder` ASC [ RunTime:0.019029s ]
select * from pdf where partno='228ADS1AWFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.061184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032801s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925885 AND `partno` = '228ADS1AWFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925884 LIMIT 4 [ RunTime:0.095791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925884 ORDER BY `minOrder` ASC [ RunTime:0.049719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925884 ORDER BY `unit` DESC [ RunTime:0.021924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925884 LIMIT 2 [ RunTime:0.048498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925884 ORDER BY `minOrder` ASC [ RunTime:0.027310s ]
select * from pdf where partno='228ADS1ARGFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.052302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023699s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925884 AND `partno` = '228ADS1ARGFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.043364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925883 LIMIT 4 [ RunTime:0.067657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925883 ORDER BY `minOrder` ASC [ RunTime:0.060668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925883 ORDER BY `unit` DESC [ RunTime:0.002224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925883 LIMIT 2 [ RunTime:0.062913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925883 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
select * from pdf where partno='228ADS1AAWFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012738s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925883 AND `partno` = '228ADS1AAWFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449864 [ RunTime:0.029737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925882 LIMIT 4 [ RunTime:0.021723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925882 ORDER BY `minOrder` ASC [ RunTime:0.019674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925882 ORDER BY `unit` DESC [ RunTime:0.010026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925882 LIMIT 2 [ RunTime:0.001017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925882 ORDER BY `minOrder` ASC [ RunTime:0.004004s ]
select * from pdf where partno='228ADS1AWFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010905s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925882 AND `partno` = '228ADS1AWFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009429s ]
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.119305s ]