SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001220s ]
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=49&srecordnum=10000' [ RunTime:0.001720s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003644s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002804s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002817s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002397s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000699s ]
UPDATE `stock_search` SET `count` = 1145 , `updatetime` = '2026-06-11 19:53:56' WHERE `partno` = '228' [ RunTime:0.003518s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000336s ]
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.000573s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002700s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.254298s ]
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 960,20 [ RunTime:0.063162s ]
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 ('32926233','32926232','32926231','32926230','32926229','32926228','32926227','32926226','32926225','32926224','32926223','32926222','32926221','32926220','32926219','32926218','32926217','32926216','32926215','32926214') ORDER BY FIELD(s.id, 32926233,32926232,32926231,32926230,32926229,32926228,32926227,32926226,32926225,32926224,32926223,32926222,32926221,32926220,32926219,32926218,32926217,32926216,32926215,32926214) [ RunTime:0.003063s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926233 LIMIT 4 [ RunTime:0.005683s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926233 ORDER BY `minOrder` ASC [ RunTime:0.002069s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926233 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926233 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926233 ORDER BY `minOrder` ASC [ RunTime:0.007211s ]
select * from pdf where partno='228CMVARGBFDBBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006833s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDBBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001733s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926233 AND `partno` = '228CMVARGBFDBBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449963 [ RunTime:0.008296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926232 LIMIT 4 [ RunTime:0.006934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926232 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926232 ORDER BY `unit` DESC [ RunTime:0.015438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926232 LIMIT 2 [ RunTime:0.016289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926232 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='228CMVARGBFEMBBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEMBBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016048s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926232 AND `partno` = '228CMVARGBFEMBBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449962 [ RunTime:0.041745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926231 LIMIT 4 [ RunTime:0.015236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926231 ORDER BY `minOrder` ASC [ RunTime:0.024733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926231 ORDER BY `unit` DESC [ RunTime:0.008081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926231 LIMIT 2 [ RunTime:0.006273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926231 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='228CMVARGBFBACR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBACR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006992s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926231 AND `partno` = '228CMVARGBFBACR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449961 [ RunTime:0.001410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926230 LIMIT 4 [ RunTime:0.014713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926230 ORDER BY `minOrder` ASC [ RunTime:0.021746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926230 ORDER BY `unit` DESC [ RunTime:0.005935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926230 LIMIT 2 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926230 ORDER BY `minOrder` ASC [ RunTime:0.008269s ]
select * from pdf where partno='228CMVARGBFCMSDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCMSDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025730s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926230 AND `partno` = '228CMVARGBFCMSDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449960 [ RunTime:0.014500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926229 LIMIT 4 [ RunTime:0.014998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926229 ORDER BY `minOrder` ASC [ RunTime:0.019106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926229 ORDER BY `unit` DESC [ RunTime:0.017757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926229 LIMIT 2 [ RunTime:0.020669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926229 ORDER BY `minOrder` ASC [ RunTime:0.013095s ]
select * from pdf where partno='228CMVARGBFEWBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEWBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006623s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926229 AND `partno` = '228CMVARGBFEWBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449959 [ RunTime:0.014784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926228 LIMIT 4 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926228 ORDER BY `minOrder` ASC [ RunTime:0.007475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926228 ORDER BY `unit` DESC [ RunTime:0.017864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926228 LIMIT 2 [ RunTime:0.010222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926228 ORDER BY `minOrder` ASC [ RunTime:0.008484s ]
select * from pdf where partno='228CMVARGBFDRAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDRAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007059s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926228 AND `partno` = '228CMVARGBFDRAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449958 [ RunTime:0.009834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926227 LIMIT 4 [ RunTime:0.024297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926227 ORDER BY `minOrder` ASC [ RunTime:0.025515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926227 ORDER BY `unit` DESC [ RunTime:0.002602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926227 LIMIT 2 [ RunTime:0.008435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926227 ORDER BY `minOrder` ASC [ RunTime:0.014609s ]
select * from pdf where partno='228CMVARGBFAMSAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAMSAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013174s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926227 AND `partno` = '228CMVARGBFAMSAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449957 [ RunTime:0.032364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926226 LIMIT 4 [ RunTime:0.013905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926226 ORDER BY `minOrder` ASC [ RunTime:0.021035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926226 ORDER BY `unit` DESC [ RunTime:0.006840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926226 LIMIT 2 [ RunTime:0.024496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926226 ORDER BY `minOrder` ASC [ RunTime:0.034069s ]
select * from pdf where partno='228CMVARGBFDAAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDAAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012054s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926226 AND `partno` = '228CMVARGBFDAAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449956 [ RunTime:0.039614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926225 LIMIT 4 [ RunTime:0.014436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926225 ORDER BY `minOrder` ASC [ RunTime:0.023803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926225 ORDER BY `unit` DESC [ RunTime:0.007013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926225 LIMIT 2 [ RunTime:0.003892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926225 ORDER BY `minOrder` ASC [ RunTime:0.009926s ]
select * from pdf where partno='228CMVARGBFCMSCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCMSCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005451s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926225 AND `partno` = '228CMVARGBFCMSCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366605 [ RunTime:0.014528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926224 LIMIT 4 [ RunTime:0.041039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926224 ORDER BY `minOrder` ASC [ RunTime:0.029245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926224 ORDER BY `unit` DESC [ RunTime:0.007161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926224 LIMIT 2 [ RunTime:0.024694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926224 ORDER BY `minOrder` ASC [ RunTime:0.005376s ]
select * from pdf where partno='228CMVARGBFAABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004288s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926224 AND `partno` = '228CMVARGBFAABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449955 [ RunTime:0.018569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926223 LIMIT 4 [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926223 ORDER BY `minOrder` ASC [ RunTime:0.016554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926223 ORDER BY `unit` DESC [ RunTime:0.003333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926223 LIMIT 2 [ RunTime:0.003567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926223 ORDER BY `minOrder` ASC [ RunTime:0.006502s ]
select * from pdf where partno='228CMVARGBFAAAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFAAAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019930s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926223 AND `partno` = '228CMVARGBFAAAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449954 [ RunTime:0.018951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926222 LIMIT 4 [ RunTime:0.042526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926222 ORDER BY `minOrder` ASC [ RunTime:0.016221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926222 ORDER BY `unit` DESC [ RunTime:0.002218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926222 LIMIT 2 [ RunTime:0.023907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926222 ORDER BY `minOrder` ASC [ RunTime:0.021645s ]
select * from pdf where partno='228CMVARGBFCRDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCRDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029727s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926222 AND `partno` = '228CMVARGBFCRDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449953 [ RunTime:0.023733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926221 LIMIT 4 [ RunTime:0.043152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926221 ORDER BY `minOrder` ASC [ RunTime:0.022734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926221 ORDER BY `unit` DESC [ RunTime:0.042354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926221 LIMIT 2 [ RunTime:0.072456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926221 ORDER BY `minOrder` ASC [ RunTime:0.011073s ]
select * from pdf where partno='228CMVARGBFCRAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCRAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.046378s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926221 AND `partno` = '228CMVARGBFCRAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.037939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366604 [ RunTime:0.060106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926220 LIMIT 4 [ RunTime:0.071898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926220 ORDER BY `minOrder` ASC [ RunTime:0.029129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926220 ORDER BY `unit` DESC [ RunTime:0.035867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926220 LIMIT 2 [ RunTime:0.031695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926220 ORDER BY `minOrder` ASC [ RunTime:0.030252s ]
select * from pdf where partno='228CMVARGBFERAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFERAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028248s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926220 AND `partno` = '228CMVARGBFERAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449952 [ RunTime:0.037691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926219 LIMIT 4 [ RunTime:0.033360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926219 ORDER BY `minOrder` ASC [ RunTime:0.011452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926219 ORDER BY `unit` DESC [ RunTime:0.054771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926219 LIMIT 2 [ RunTime:0.043122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926219 ORDER BY `minOrder` ASC [ RunTime:0.023856s ]
select * from pdf where partno='228CMVARGBFDMBDR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFDMBDR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010256s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926219 AND `partno` = '228CMVARGBFDMBDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449951 [ RunTime:0.011567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926218 LIMIT 4 [ RunTime:0.014880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926218 ORDER BY `minOrder` ASC [ RunTime:0.016079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926218 ORDER BY `unit` DESC [ RunTime:0.003905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926218 LIMIT 2 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926218 ORDER BY `minOrder` ASC [ RunTime:0.003132s ]
select * from pdf where partno='228CMVARGBFFABR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFFABR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008972s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926218 AND `partno` = '228CMVARGBFFABR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366603 [ RunTime:0.042743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926217 LIMIT 4 [ RunTime:0.019842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926217 ORDER BY `minOrder` ASC [ RunTime:0.016892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926217 ORDER BY `unit` DESC [ RunTime:0.027302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926217 LIMIT 2 [ RunTime:0.011961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926217 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
select * from pdf where partno='228CMVARGBFARCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFARCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005421s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926217 AND `partno` = '228CMVARGBFARCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926216 LIMIT 4 [ RunTime:0.050462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926216 ORDER BY `minOrder` ASC [ RunTime:0.017034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926216 ORDER BY `unit` DESC [ RunTime:0.013413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926216 LIMIT 2 [ RunTime:0.004336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926216 ORDER BY `minOrder` ASC [ RunTime:0.007360s ]
select * from pdf where partno='228CMVARGBFBRCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFBRCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015559s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926216 AND `partno` = '228CMVARGBFBRCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926215 LIMIT 4 [ RunTime:0.022986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926215 ORDER BY `minOrder` ASC [ RunTime:0.044771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926215 ORDER BY `unit` DESC [ RunTime:0.006207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926215 LIMIT 2 [ RunTime:0.077256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926215 ORDER BY `minOrder` ASC [ RunTime:0.014613s ]
select * from pdf where partno='228CMVARGBFEAAR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFEAAR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020511s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926215 AND `partno` = '228CMVARGBFEAAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32926214 LIMIT 4 [ RunTime:0.024522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926214 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32926214 ORDER BY `unit` DESC [ RunTime:0.017069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32926214 LIMIT 2 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32926214 ORDER BY `minOrder` ASC [ RunTime:0.010169s ]
select * from pdf where partno='228CMVARGBFCBBCR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CMVARGBFCBBCR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026316s ]
SELECT `id` FROM `stock` WHERE `id` <> 32926214 AND `partno` = '228CMVARGBFCBBCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010093s ]
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.130787s ]