SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001548s ]
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=61&srecordnum=10000' [ RunTime:0.003085s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001532s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002066s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001641s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002605s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002034s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011466s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003570s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004003s ]
UPDATE `stock_search` SET `count` = 1186 , `updatetime` = '2026-06-12 02:53:42' WHERE `partno` = '228' [ RunTime:0.016260s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003885s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006380s ]
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.000656s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001541s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.224826s ]
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 1200,20 [ RunTime:0.115120s ]
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 ('32925722','32925721','32925720','32925719','32925718','32925717','32925716','32925715','32925714','32925713','32925712','32925711','32925710','32925709','32925708','32925707','32925706','32925705','32925704','32925703') ORDER BY FIELD(s.id, 32925722,32925721,32925720,32925719,32925718,32925717,32925716,32925715,32925714,32925713,32925712,32925711,32925710,32925709,32925708,32925707,32925706,32925705,32925704,32925703) [ RunTime:0.007476s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925722 LIMIT 4 [ RunTime:0.043051s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925722 ORDER BY `minOrder` ASC [ RunTime:0.052722s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925722 ORDER BY `unit` DESC [ RunTime:0.006567s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925722 LIMIT 2 [ RunTime:0.015595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925722 ORDER BY `minOrder` ASC [ RunTime:0.010817s ]
select * from pdf where partno='228ADS1AGFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015995s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021419s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925722 AND `partno` = '228ADS1AGFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449834 [ RunTime:0.004706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925721 LIMIT 4 [ RunTime:0.008837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925721 ORDER BY `minOrder` ASC [ RunTime:0.026667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925721 ORDER BY `unit` DESC [ RunTime:0.013258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925721 LIMIT 2 [ RunTime:0.046648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925721 ORDER BY `minOrder` ASC [ RunTime:0.023625s ]
select * from pdf where partno='228ADS1ARBFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026783s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925721 AND `partno` = '228ADS1ARBFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449833 [ RunTime:0.057654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925720 LIMIT 4 [ RunTime:0.090851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925720 ORDER BY `minOrder` ASC [ RunTime:0.037031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925720 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925720 LIMIT 2 [ RunTime:0.050720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925720 ORDER BY `minOrder` ASC [ RunTime:0.003236s ]
select * from pdf where partno='228ADS1ARBFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925720 AND `partno` = '228ADS1ARBFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449832 [ RunTime:0.008671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925719 LIMIT 4 [ RunTime:0.012828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925719 ORDER BY `minOrder` ASC [ RunTime:0.022777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925719 ORDER BY `unit` DESC [ RunTime:0.020944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925719 LIMIT 2 [ RunTime:0.019196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925719 ORDER BY `minOrder` ASC [ RunTime:0.019831s ]
select * from pdf where partno='228ADS1ARGFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003146s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925719 AND `partno` = '228ADS1ARGFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449831 [ RunTime:0.004997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925718 LIMIT 4 [ RunTime:0.006681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925718 ORDER BY `minOrder` ASC [ RunTime:0.017008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925718 ORDER BY `unit` DESC [ RunTime:0.013336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925718 LIMIT 2 [ RunTime:0.014353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925718 ORDER BY `minOrder` ASC [ RunTime:0.007009s ]
select * from pdf where partno='228ADS1AAWFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001341s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925718 AND `partno` = '228ADS1AAWFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449830 [ RunTime:0.002372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925717 LIMIT 4 [ RunTime:0.019112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925717 ORDER BY `minOrder` ASC [ RunTime:0.032210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925717 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925717 LIMIT 2 [ RunTime:0.050713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925717 ORDER BY `minOrder` ASC [ RunTime:0.008307s ]
select * from pdf where partno='228ADS1AAFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003949s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925717 AND `partno` = '228ADS1AAFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366514 [ RunTime:0.027028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925716 LIMIT 4 [ RunTime:0.026572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925716 ORDER BY `minOrder` ASC [ RunTime:0.045373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925716 ORDER BY `unit` DESC [ RunTime:0.008408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925716 LIMIT 2 [ RunTime:0.007959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925716 ORDER BY `minOrder` ASC [ RunTime:0.010834s ]
select * from pdf where partno='228ADS1ARBFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001087s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925716 AND `partno` = '228ADS1ARBFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449829 [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925715 LIMIT 4 [ RunTime:0.004136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925715 ORDER BY `minOrder` ASC [ RunTime:0.014389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925715 ORDER BY `unit` DESC [ RunTime:0.009554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925715 LIMIT 2 [ RunTime:0.025980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925715 ORDER BY `minOrder` ASC [ RunTime:0.013261s ]
select * from pdf where partno='228ADS1AAWFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011324s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925715 AND `partno` = '228ADS1AAWFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.029129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366513 [ RunTime:0.012936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925714 LIMIT 4 [ RunTime:0.034340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925714 ORDER BY `minOrder` ASC [ RunTime:0.054751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925714 ORDER BY `unit` DESC [ RunTime:0.012955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925714 LIMIT 2 [ RunTime:0.010067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925714 ORDER BY `minOrder` ASC [ RunTime:0.004819s ]
select * from pdf where partno='228ADS1AYFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007467s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925714 AND `partno` = '228ADS1AYFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366512 [ RunTime:0.007467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925713 LIMIT 4 [ RunTime:0.038420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925713 ORDER BY `minOrder` ASC [ RunTime:0.043704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925713 ORDER BY `unit` DESC [ RunTime:0.009682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925713 LIMIT 2 [ RunTime:0.013600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925713 ORDER BY `minOrder` ASC [ RunTime:0.045634s ]
select * from pdf where partno='228ADS1ARFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006098s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925713 AND `partno` = '228ADS1ARFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366511 [ RunTime:0.014339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925712 LIMIT 4 [ RunTime:0.007288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925712 ORDER BY `minOrder` ASC [ RunTime:0.029323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925712 ORDER BY `unit` DESC [ RunTime:0.013602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925712 LIMIT 2 [ RunTime:0.033491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925712 ORDER BY `minOrder` ASC [ RunTime:0.009003s ]
select * from pdf where partno='228ADS1AAFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015935s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925712 AND `partno` = '228ADS1AAFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449828 [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925711 LIMIT 4 [ RunTime:0.027428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925711 ORDER BY `minOrder` ASC [ RunTime:0.027044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925711 ORDER BY `unit` DESC [ RunTime:0.018301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925711 LIMIT 2 [ RunTime:0.032580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925711 ORDER BY `minOrder` ASC [ RunTime:0.007753s ]
select * from pdf where partno='228ADS1ARGFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021568s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925711 AND `partno` = '228ADS1ARGFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366510 [ RunTime:0.022985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925710 LIMIT 4 [ RunTime:0.020670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925710 ORDER BY `minOrder` ASC [ RunTime:0.027650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925710 ORDER BY `unit` DESC [ RunTime:0.008823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925710 LIMIT 2 [ RunTime:0.032481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925710 ORDER BY `minOrder` ASC [ RunTime:0.008830s ]
select * from pdf where partno='228ADS1ARFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.038840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008057s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925710 AND `partno` = '228ADS1ARFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925709 LIMIT 4 [ RunTime:0.008526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925709 ORDER BY `minOrder` ASC [ RunTime:0.015893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925709 ORDER BY `unit` DESC [ RunTime:0.017419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925709 LIMIT 2 [ RunTime:0.015778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925709 ORDER BY `minOrder` ASC [ RunTime:0.004690s ]
select * from pdf where partno='228ADS1AAWFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018330s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925709 AND `partno` = '228ADS1AAWFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.076063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925708 LIMIT 4 [ RunTime:0.017582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925708 ORDER BY `minOrder` ASC [ RunTime:0.048863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925708 ORDER BY `unit` DESC [ RunTime:0.010346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925708 LIMIT 2 [ RunTime:0.015672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925708 ORDER BY `minOrder` ASC [ RunTime:0.029248s ]
select * from pdf where partno='228ADS1ARBFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027000s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925708 AND `partno` = '228ADS1ARBFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449827 [ RunTime:0.001148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925707 LIMIT 4 [ RunTime:0.021750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925707 ORDER BY `minOrder` ASC [ RunTime:0.013284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925707 ORDER BY `unit` DESC [ RunTime:0.011317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925707 LIMIT 2 [ RunTime:0.025525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925707 ORDER BY `minOrder` ASC [ RunTime:0.008924s ]
select * from pdf where partno='228ADS1ARAFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007557s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925707 AND `partno` = '228ADS1ARAFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449826 [ RunTime:0.018040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925706 LIMIT 4 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925706 ORDER BY `minOrder` ASC [ RunTime:0.023995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925706 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925706 LIMIT 2 [ RunTime:0.015600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925706 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
select * from pdf where partno='228ADS1ARFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004012s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925706 AND `partno` = '228ADS1ARFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.006554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449825 [ RunTime:0.002599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925705 LIMIT 4 [ RunTime:0.001003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925705 ORDER BY `minOrder` ASC [ RunTime:0.012022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925705 ORDER BY `unit` DESC [ RunTime:0.005494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925705 LIMIT 2 [ RunTime:0.012005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925705 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
select * from pdf where partno='228ADS1AAFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002793s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925705 AND `partno` = '228ADS1AAFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925704 LIMIT 4 [ RunTime:0.004847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925704 ORDER BY `minOrder` ASC [ RunTime:0.020382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925704 ORDER BY `unit` DESC [ RunTime:0.013642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925704 LIMIT 2 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925704 ORDER BY `minOrder` ASC [ RunTime:0.002600s ]
select * from pdf where partno='228ADS1ARAFCWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006296s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925704 AND `partno` = '228ADS1ARAFCWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925703 LIMIT 4 [ RunTime:0.011075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925703 ORDER BY `minOrder` ASC [ RunTime:0.009061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925703 ORDER BY `unit` DESC [ RunTime:0.030114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925703 LIMIT 2 [ RunTime:0.007321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925703 ORDER BY `minOrder` ASC [ RunTime:0.016266s ]
select * from pdf where partno='228ADS1ARFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000965s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925703 AND `partno` = '228ADS1ARFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449824 [ RunTime:0.016101s ]
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.007558s ]