SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002825s ]
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=50&srecordnum=10000' [ RunTime:0.001757s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002292s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000848s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002565s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004162s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000432s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002319s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000617s ]
UPDATE `stock_search` SET `count` = 1146 , `updatetime` = '2026-06-11 19:53:56' WHERE `partno` = '228' [ RunTime:0.003254s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001030s ]
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.002662s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001490s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.244927s ]
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 980,20 [ RunTime:0.096176s ]
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 ('32926213','32926212','32926211','32926210','32926209','32926208','32926207','32926206','32926205','32926204','32926203','32926202','32926201','32926200','32926199','32926198','32926197','32926196','32926195','32926194') ORDER BY FIELD(s.id, 32926213,32926212,32926211,32926210,32926209,32926208,32926207,32926206,32926205,32926204,32926203,32926202,32926201,32926200,32926199,32926198,32926197,32926196,32926195,32926194) [ RunTime:0.008485s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926213 LIMIT 4 [ RunTime:0.007473s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926213 ORDER BY `minOrder` ASC [ RunTime:0.003218s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926213 ORDER BY `unit` DESC [ RunTime:0.009971s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926213 LIMIT 2 [ RunTime:0.005916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926213 ORDER BY `minOrder` ASC [ RunTime:0.011013s ]
select * from pdf where partno='228CMVARGBFEBBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019519s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEBBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003581s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926213 AND `partno` = '228CMVARGBFEBBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449950 [ RunTime:0.020889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926212 LIMIT 4 [ RunTime:0.026075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926212 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926212 ORDER BY `unit` DESC [ RunTime:0.019428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926212 LIMIT 2 [ RunTime:0.017828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926212 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
select * from pdf where partno='228CMVARGBFCRBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCRBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005618s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926212 AND `partno` = '228CMVARGBFCRBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449949 [ RunTime:0.008820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926211 LIMIT 4 [ RunTime:0.013942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926211 ORDER BY `minOrder` ASC [ RunTime:0.029762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926211 ORDER BY `unit` DESC [ RunTime:0.020942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926211 LIMIT 2 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926211 ORDER BY `minOrder` ASC [ RunTime:0.006576s ]
select * from pdf where partno='228CMVARGBFABBDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFABBDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033960s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926211 AND `partno` = '228CMVARGBFABBDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926210 LIMIT 4 [ RunTime:0.016726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926210 ORDER BY `minOrder` ASC [ RunTime:0.038362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926210 ORDER BY `unit` DESC [ RunTime:0.016478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926210 LIMIT 2 [ RunTime:0.016581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926210 ORDER BY `minOrder` ASC [ RunTime:0.008018s ]
select * from pdf where partno='228CMVARGBFCBBAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCBBAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005453s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926210 AND `partno` = '228CMVARGBFCBBAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926209 LIMIT 4 [ RunTime:0.014868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926209 ORDER BY `minOrder` ASC [ RunTime:0.009404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926209 ORDER BY `unit` DESC [ RunTime:0.001422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926209 LIMIT 2 [ RunTime:0.021857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926209 ORDER BY `minOrder` ASC [ RunTime:0.009663s ]
select * from pdf where partno='228CMVARGBFBWCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBWCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002791s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926209 AND `partno` = '228CMVARGBFBWCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926208 LIMIT 4 [ RunTime:0.009539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926208 ORDER BY `minOrder` ASC [ RunTime:0.007975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926208 ORDER BY `unit` DESC [ RunTime:0.004442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926208 LIMIT 2 [ RunTime:0.038908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926208 ORDER BY `minOrder` ASC [ RunTime:0.009426s ]
select * from pdf where partno='228CMVARGBFEMBAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEMBAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016692s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926208 AND `partno` = '228CMVARGBFEMBAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366602 [ RunTime:0.033351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926207 LIMIT 4 [ RunTime:0.009957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926207 ORDER BY `minOrder` ASC [ RunTime:0.004721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926207 ORDER BY `unit` DESC [ RunTime:0.025003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926207 LIMIT 2 [ RunTime:0.012816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926207 ORDER BY `minOrder` ASC [ RunTime:0.007302s ]
select * from pdf where partno='228CMVARGBFAADR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAADR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031460s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926207 AND `partno` = '228CMVARGBFAADR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366601 [ RunTime:0.016544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926206 LIMIT 4 [ RunTime:0.023675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926206 ORDER BY `minOrder` ASC [ RunTime:0.044047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926206 ORDER BY `unit` DESC [ RunTime:0.033586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926206 LIMIT 2 [ RunTime:0.002446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926206 ORDER BY `minOrder` ASC [ RunTime:0.005789s ]
select * from pdf where partno='228CMVARGBFAMBCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAMBCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010168s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926206 AND `partno` = '228CMVARGBFAMBCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366600 [ RunTime:0.016408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926205 LIMIT 4 [ RunTime:0.015897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926205 ORDER BY `minOrder` ASC [ RunTime:0.024989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926205 ORDER BY `unit` DESC [ RunTime:0.034479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926205 LIMIT 2 [ RunTime:0.010489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926205 ORDER BY `minOrder` ASC [ RunTime:0.005601s ]
select * from pdf where partno='228CMVARGBFFAAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFAAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005484s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926205 AND `partno` = '228CMVARGBFFAAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449948 [ RunTime:0.007608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926204 LIMIT 4 [ RunTime:0.012420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926204 ORDER BY `minOrder` ASC [ RunTime:0.022248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926204 ORDER BY `unit` DESC [ RunTime:0.002087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926204 LIMIT 2 [ RunTime:0.002400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926204 ORDER BY `minOrder` ASC [ RunTime:0.011828s ]
select * from pdf where partno='228CMVARGBFCMSAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCMSAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010359s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926204 AND `partno` = '228CMVARGBFCMSAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366599 [ RunTime:0.033079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926203 LIMIT 4 [ RunTime:0.027223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926203 ORDER BY `minOrder` ASC [ RunTime:0.005448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926203 ORDER BY `unit` DESC [ RunTime:0.050041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926203 LIMIT 2 [ RunTime:0.004297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926203 ORDER BY `minOrder` ASC [ RunTime:0.005894s ]
select * from pdf where partno='228CMVARGBFERBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.043205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFERBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036033s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926203 AND `partno` = '228CMVARGBFERBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366598 [ RunTime:0.023083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926202 LIMIT 4 [ RunTime:0.051159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926202 ORDER BY `minOrder` ASC [ RunTime:0.088349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926202 ORDER BY `unit` DESC [ RunTime:0.016700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926202 LIMIT 2 [ RunTime:0.030532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926202 ORDER BY `minOrder` ASC [ RunTime:0.009475s ]
select * from pdf where partno='228CMVARGBFARDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFARDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.078395s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926202 AND `partno` = '228CMVARGBFARDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366597 [ RunTime:0.050044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926201 LIMIT 4 [ RunTime:0.045841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926201 ORDER BY `minOrder` ASC [ RunTime:0.020491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926201 ORDER BY `unit` DESC [ RunTime:0.024828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926201 LIMIT 2 [ RunTime:0.024121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926201 ORDER BY `minOrder` ASC [ RunTime:0.011676s ]
select * from pdf where partno='228CMVARGBFBMBCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.045722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBMBCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028622s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926201 AND `partno` = '228CMVARGBFBMBCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.041208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366596 [ RunTime:0.015915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926200 LIMIT 4 [ RunTime:0.019339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926200 ORDER BY `minOrder` ASC [ RunTime:0.014362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926200 ORDER BY `unit` DESC [ RunTime:0.024494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926200 LIMIT 2 [ RunTime:0.041645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926200 ORDER BY `minOrder` ASC [ RunTime:0.009341s ]
select * from pdf where partno='228CMVARGBFFACR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFACR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013695s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926200 AND `partno` = '228CMVARGBFFACR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449947 [ RunTime:0.024549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926199 LIMIT 4 [ RunTime:0.019247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926199 ORDER BY `minOrder` ASC [ RunTime:0.002768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926199 ORDER BY `unit` DESC [ RunTime:0.008518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926199 LIMIT 2 [ RunTime:0.013623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926199 ORDER BY `minOrder` ASC [ RunTime:0.004427s ]
select * from pdf where partno='228CMVARGBFDWAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDWAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004427s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926199 AND `partno` = '228CMVARGBFDWAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366595 [ RunTime:0.015307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926198 LIMIT 4 [ RunTime:0.003255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926198 ORDER BY `minOrder` ASC [ RunTime:0.004160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926198 ORDER BY `unit` DESC [ RunTime:0.007144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926198 LIMIT 2 [ RunTime:0.014925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926198 ORDER BY `minOrder` ASC [ RunTime:0.014578s ]
select * from pdf where partno='228CMVARGBFFBBCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFBBCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014431s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926198 AND `partno` = '228CMVARGBFFBBCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.047797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449946 [ RunTime:0.033076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926197 LIMIT 4 [ RunTime:0.002742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926197 ORDER BY `minOrder` ASC [ RunTime:0.005224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926197 ORDER BY `unit` DESC [ RunTime:0.010184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926197 LIMIT 2 [ RunTime:0.006396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926197 ORDER BY `minOrder` ASC [ RunTime:0.001316s ]
select * from pdf where partno='228CMVARGBFCRCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCRCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.046301s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926197 AND `partno` = '228CMVARGBFCRCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366594 [ RunTime:0.017978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926196 LIMIT 4 [ RunTime:0.009807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926196 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926196 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926196 LIMIT 2 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926196 ORDER BY `minOrder` ASC [ RunTime:0.002954s ]
select * from pdf where partno='228CMVARGBFDWDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDWDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017509s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926196 AND `partno` = '228CMVARGBFDWDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449945 [ RunTime:0.007897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926195 LIMIT 4 [ RunTime:0.026538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926195 ORDER BY `minOrder` ASC [ RunTime:0.011126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926195 ORDER BY `unit` DESC [ RunTime:0.002965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926195 LIMIT 2 [ RunTime:0.021276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926195 ORDER BY `minOrder` ASC [ RunTime:0.011723s ]
select * from pdf where partno='228CMVARGBFFBBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFBBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026869s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926195 AND `partno` = '228CMVARGBFFBBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449944 [ RunTime:0.025490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926194 LIMIT 4 [ RunTime:0.032003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926194 ORDER BY `minOrder` ASC [ RunTime:0.027250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926194 ORDER BY `unit` DESC [ RunTime:0.007179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926194 LIMIT 2 [ RunTime:0.024891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926194 ORDER BY `minOrder` ASC [ RunTime:0.015258s ]
select * from pdf where partno='228CMVARGBFCBBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCBBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023625s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926194 AND `partno` = '228CMVARGBFCBBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013281s ]
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.138296s ]