SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001958s ]
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=67&srecordnum=10000' [ RunTime:0.003977s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001370s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006449s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001955s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000625s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001282s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008279s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001407s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.005045s ]
UPDATE `stock_search` SET `count` = 1948 , `updatetime` = '2026-06-12 07:53:43' WHERE `partno` = '228' [ RunTime:0.006982s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000831s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001536s ]
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.003389s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002410s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.000346s ]
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 1320,20 [ RunTime:0.078948s ]
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 ('32925602','32925601','32925600','32925599','32925598','32925597','32925596','32925595','32925594','32925593','32925592','32925591','32925590','32925589','32925588','32925587','32925586','32925585','32925584','32925583') ORDER BY FIELD(s.id, 32925602,32925601,32925600,32925599,32925598,32925597,32925596,32925595,32925594,32925593,32925592,32925591,32925590,32925589,32925588,32925587,32925586,32925585,32925584,32925583) [ RunTime:0.004369s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925602 LIMIT 4 [ RunTime:0.023586s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925602 ORDER BY `minOrder` ASC [ RunTime:0.007217s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925602 ORDER BY `unit` DESC [ RunTime:0.011235s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925602 LIMIT 2 [ RunTime:0.007281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925602 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='228ADS1ARAFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018172s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018816s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925602 AND `partno` = '228ADS1ARAFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925601 LIMIT 4 [ RunTime:0.022908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925601 ORDER BY `minOrder` ASC [ RunTime:0.006829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925601 ORDER BY `unit` DESC [ RunTime:0.018084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925601 LIMIT 2 [ RunTime:0.016074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925601 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
select * from pdf where partno='228ADS1AYFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006845s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925601 AND `partno` = '228ADS1AYFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925600 LIMIT 4 [ RunTime:0.021460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925600 ORDER BY `minOrder` ASC [ RunTime:0.006409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925600 ORDER BY `unit` DESC [ RunTime:0.030451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925600 LIMIT 2 [ RunTime:0.027649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925600 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
select * from pdf where partno='228ADS1AAWFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007792s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925600 AND `partno` = '228ADS1AAWFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925599 LIMIT 4 [ RunTime:0.037322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925599 ORDER BY `minOrder` ASC [ RunTime:0.027526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925599 ORDER BY `unit` DESC [ RunTime:0.045269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925599 LIMIT 2 [ RunTime:0.037243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925599 ORDER BY `minOrder` ASC [ RunTime:0.006618s ]
select * from pdf where partno='228ADS1ARAFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.046335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034254s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925599 AND `partno` = '228ADS1ARAFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449782 [ RunTime:0.006921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925598 LIMIT 4 [ RunTime:0.019885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925598 ORDER BY `minOrder` ASC [ RunTime:0.012548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925598 ORDER BY `unit` DESC [ RunTime:0.025103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925598 LIMIT 2 [ RunTime:0.009884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925598 ORDER BY `minOrder` ASC [ RunTime:0.008999s ]
select * from pdf where partno='228ADS1ARGFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014051s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925598 AND `partno` = '228ADS1ARGFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449781 [ RunTime:0.019069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925597 LIMIT 4 [ RunTime:0.011435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925597 ORDER BY `minOrder` ASC [ RunTime:0.017962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925597 ORDER BY `unit` DESC [ RunTime:0.051137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925597 LIMIT 2 [ RunTime:0.019123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925597 ORDER BY `minOrder` ASC [ RunTime:0.005034s ]
select * from pdf where partno='228ADS1ARFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026550s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925597 AND `partno` = '228ADS1ARFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449780 [ RunTime:0.036601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925596 LIMIT 4 [ RunTime:0.017585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925596 ORDER BY `minOrder` ASC [ RunTime:0.052149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925596 ORDER BY `unit` DESC [ RunTime:0.003670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925596 LIMIT 2 [ RunTime:0.015429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925596 ORDER BY `minOrder` ASC [ RunTime:0.006022s ]
select * from pdf where partno='228ADS1AYGFCMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009458s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925596 AND `partno` = '228ADS1AYGFCMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366474 [ RunTime:0.002857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925595 LIMIT 4 [ RunTime:0.010618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925595 ORDER BY `minOrder` ASC [ RunTime:0.011384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925595 ORDER BY `unit` DESC [ RunTime:0.012428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925595 LIMIT 2 [ RunTime:0.023626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925595 ORDER BY `minOrder` ASC [ RunTime:0.016856s ]
select * from pdf where partno='228ADS1ABFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925595 AND `partno` = '228ADS1ABFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449779 [ RunTime:0.012398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925594 LIMIT 4 [ RunTime:0.031725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925594 ORDER BY `minOrder` ASC [ RunTime:0.031621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925594 ORDER BY `unit` DESC [ RunTime:0.010986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925594 LIMIT 2 [ RunTime:0.064834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925594 ORDER BY `minOrder` ASC [ RunTime:0.027322s ]
select * from pdf where partno='228ADS1ARAFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014640s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925594 AND `partno` = '228ADS1ARAFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366473 [ RunTime:0.025357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925593 LIMIT 4 [ RunTime:0.025391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925593 ORDER BY `minOrder` ASC [ RunTime:0.025479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925593 ORDER BY `unit` DESC [ RunTime:0.034308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925593 LIMIT 2 [ RunTime:0.032426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925593 ORDER BY `minOrder` ASC [ RunTime:0.058462s ]
select * from pdf where partno='228ADS1ABFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039726s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925593 AND `partno` = '228ADS1ABFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449778 [ RunTime:0.035615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925592 LIMIT 4 [ RunTime:0.054191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925592 ORDER BY `minOrder` ASC [ RunTime:0.040961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925592 ORDER BY `unit` DESC [ RunTime:0.041939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925592 LIMIT 2 [ RunTime:0.018123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925592 ORDER BY `minOrder` ASC [ RunTime:0.004547s ]
select * from pdf where partno='228ADS1AYFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017769s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925592 AND `partno` = '228ADS1AYFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366472 [ RunTime:0.008663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925591 LIMIT 4 [ RunTime:0.003559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925591 ORDER BY `minOrder` ASC [ RunTime:0.019847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925591 ORDER BY `unit` DESC [ RunTime:0.075136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925591 LIMIT 2 [ RunTime:0.045411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925591 ORDER BY `minOrder` ASC [ RunTime:0.011065s ]
select * from pdf where partno='228ADS1ARBFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.032137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.058210s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925591 AND `partno` = '228ADS1ARBFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.048872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449777 [ RunTime:0.025809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925590 LIMIT 4 [ RunTime:0.024960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925590 ORDER BY `minOrder` ASC [ RunTime:0.040815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925590 ORDER BY `unit` DESC [ RunTime:0.058921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925590 LIMIT 2 [ RunTime:0.042996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925590 ORDER BY `minOrder` ASC [ RunTime:0.002820s ]
select * from pdf where partno='228ADS1ARBFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024953s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925590 AND `partno` = '228ADS1ARBFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366471 [ RunTime:0.005170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925589 LIMIT 4 [ RunTime:0.024042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925589 ORDER BY `minOrder` ASC [ RunTime:0.023690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925589 ORDER BY `unit` DESC [ RunTime:0.014464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925589 LIMIT 2 [ RunTime:0.018119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925589 ORDER BY `minOrder` ASC [ RunTime:0.016185s ]
select * from pdf where partno='228ADS1AYGFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024498s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925589 AND `partno` = '228ADS1AYGFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925588 LIMIT 4 [ RunTime:0.018254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925588 ORDER BY `minOrder` ASC [ RunTime:0.018496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925588 ORDER BY `unit` DESC [ RunTime:0.028328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925588 LIMIT 2 [ RunTime:0.022277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925588 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
select * from pdf where partno='228ADS1ARAFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025124s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925588 AND `partno` = '228ADS1ARAFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449776 [ RunTime:0.035436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925587 LIMIT 4 [ RunTime:0.038704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925587 ORDER BY `minOrder` ASC [ RunTime:0.020565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925587 ORDER BY `unit` DESC [ RunTime:0.003051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925587 LIMIT 2 [ RunTime:0.007067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925587 ORDER BY `minOrder` ASC [ RunTime:0.013406s ]
select * from pdf where partno='228ADS1AYGFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016596s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925587 AND `partno` = '228ADS1AYGFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925586 LIMIT 4 [ RunTime:0.042369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925586 ORDER BY `minOrder` ASC [ RunTime:0.025210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925586 ORDER BY `unit` DESC [ RunTime:0.021430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925586 LIMIT 2 [ RunTime:0.006673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925586 ORDER BY `minOrder` ASC [ RunTime:0.002731s ]
select * from pdf where partno='228ADS1ARAFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024646s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925586 AND `partno` = '228ADS1ARAFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.045949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366470 [ RunTime:0.023919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925585 LIMIT 4 [ RunTime:0.008608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925585 ORDER BY `minOrder` ASC [ RunTime:0.023417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925585 ORDER BY `unit` DESC [ RunTime:0.020914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925585 LIMIT 2 [ RunTime:0.026078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925585 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
select * from pdf where partno='228ADS1ARAFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014089s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925585 AND `partno` = '228ADS1ARAFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366469 [ RunTime:0.019848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925584 LIMIT 4 [ RunTime:0.021310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925584 ORDER BY `minOrder` ASC [ RunTime:0.021364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925584 ORDER BY `unit` DESC [ RunTime:0.021461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925584 LIMIT 2 [ RunTime:0.037904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925584 ORDER BY `minOrder` ASC [ RunTime:0.050821s ]
select * from pdf where partno='228ADS1AAFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.053249s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925584 AND `partno` = '228ADS1AAFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.116187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366468 [ RunTime:0.093932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925583 LIMIT 4 [ RunTime:0.051975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925583 ORDER BY `minOrder` ASC [ RunTime:0.073583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925583 ORDER BY `unit` DESC [ RunTime:0.020160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925583 LIMIT 2 [ RunTime:0.050833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925583 ORDER BY `minOrder` ASC [ RunTime:0.015199s ]
select * from pdf where partno='228ADS1AYFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.043346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035011s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925583 AND `partno` = '228ADS1AYFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.085782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449775 [ RunTime:0.025261s ]
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.115611s ]