SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001935s ]
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=428&srecordnum=10000' [ RunTime:0.002752s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001622s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001950s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001111s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000650s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001859s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001115s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.001985s ]
UPDATE `stock_search` SET `count` = 1989 , `updatetime` = '2026-06-12 14:29:40' WHERE `partno` = '228' [ RunTime:0.002150s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001367s ]
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 `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8540,20 [ RunTime:0.224940s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920205 LIMIT 4 [ RunTime:0.009108s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920205 ORDER BY `minOrder` ASC [ RunTime:0.008822s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920205 ORDER BY `unit` DESC [ RunTime:0.011542s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920205 LIMIT 2 [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920205 ORDER BY `minOrder` ASC [ RunTime:0.007557s ]
select * from pdf where partno='228ADVAWFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013780s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041943s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920205 AND `partno` = '228ADVAWFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450836 [ RunTime:0.031660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920206 LIMIT 4 [ RunTime:0.006718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920206 ORDER BY `minOrder` ASC [ RunTime:0.009496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920206 ORDER BY `unit` DESC [ RunTime:0.010752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920206 LIMIT 2 [ RunTime:0.049398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920206 ORDER BY `minOrder` ASC [ RunTime:0.009837s ]
select * from pdf where partno='228ADVARFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022972s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920206 AND `partno` = '228ADVARFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.034566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367107 [ RunTime:0.039671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920207 LIMIT 4 [ RunTime:0.029813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920207 ORDER BY `minOrder` ASC [ RunTime:0.053381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920207 ORDER BY `unit` DESC [ RunTime:0.023806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920207 LIMIT 2 [ RunTime:0.040407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920207 ORDER BY `minOrder` ASC [ RunTime:0.008548s ]
select * from pdf where partno='228ADVAGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.058208s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920207 AND `partno` = '228ADVAGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450837 [ RunTime:0.016568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920208 LIMIT 4 [ RunTime:0.014676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920208 ORDER BY `minOrder` ASC [ RunTime:0.035431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920208 ORDER BY `unit` DESC [ RunTime:0.030429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920208 LIMIT 2 [ RunTime:0.029736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920208 ORDER BY `minOrder` ASC [ RunTime:0.011153s ]
select * from pdf where partno='228ADVAAWFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.029223s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920208 AND `partno` = '228ADVAAWFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.077717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450838 [ RunTime:0.023811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920209 LIMIT 4 [ RunTime:0.015599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920209 ORDER BY `minOrder` ASC [ RunTime:0.009439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920209 ORDER BY `unit` DESC [ RunTime:0.016673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920209 LIMIT 2 [ RunTime:0.014197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920209 ORDER BY `minOrder` ASC [ RunTime:0.008015s ]
select * from pdf where partno='228ADVAYCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023447s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920209 AND `partno` = '228ADVAYCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.045403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450839 [ RunTime:0.068115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920210 LIMIT 4 [ RunTime:0.030548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920210 ORDER BY `minOrder` ASC [ RunTime:0.055341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920210 ORDER BY `unit` DESC [ RunTime:0.070433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920210 LIMIT 2 [ RunTime:0.008246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920210 ORDER BY `minOrder` ASC [ RunTime:0.007799s ]
select * from pdf where partno='228ADVAYAMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYAMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021292s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920210 AND `partno` = '228ADVAYAMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450840 [ RunTime:0.027546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920211 LIMIT 4 [ RunTime:0.005951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920211 ORDER BY `minOrder` ASC [ RunTime:0.014715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920211 ORDER BY `unit` DESC [ RunTime:0.029242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920211 LIMIT 2 [ RunTime:0.015133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920211 ORDER BY `minOrder` ASC [ RunTime:0.016725s ]
select * from pdf where partno='228ADVAGFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011541s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920211 AND `partno` = '228ADVAGFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450841 [ RunTime:0.018551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920212 LIMIT 4 [ RunTime:0.015190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920212 ORDER BY `minOrder` ASC [ RunTime:0.017894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920212 ORDER BY `unit` DESC [ RunTime:0.015211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920212 LIMIT 2 [ RunTime:0.035747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920212 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
select * from pdf where partno='228ADVABBWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABBWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012625s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920212 AND `partno` = '228ADVABBWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450842 [ RunTime:0.027707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920213 LIMIT 4 [ RunTime:0.027085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920213 ORDER BY `minOrder` ASC [ RunTime:0.019856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920213 ORDER BY `unit` DESC [ RunTime:0.038018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920213 LIMIT 2 [ RunTime:0.041134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920213 ORDER BY `minOrder` ASC [ RunTime:0.014259s ]
select * from pdf where partno='228ADVAWFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031383s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920213 AND `partno` = '228ADVAWFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450843 [ RunTime:0.037879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920214 LIMIT 4 [ RunTime:0.023089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920214 ORDER BY `minOrder` ASC [ RunTime:0.027072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920214 ORDER BY `unit` DESC [ RunTime:0.015129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920214 LIMIT 2 [ RunTime:0.040345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920214 ORDER BY `minOrder` ASC [ RunTime:0.017827s ]
select * from pdf where partno='228ADVARAFAAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.045188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARAFAAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013880s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920214 AND `partno` = '228ADVARAFAAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.082005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450844 [ RunTime:0.032851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920215 LIMIT 4 [ RunTime:0.052743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920215 ORDER BY `minOrder` ASC [ RunTime:0.037670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920215 ORDER BY `unit` DESC [ RunTime:0.094499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920215 LIMIT 2 [ RunTime:0.053773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920215 ORDER BY `minOrder` ASC [ RunTime:0.029949s ]
select * from pdf where partno='228ADVAYARC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYARC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033503s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920215 AND `partno` = '228ADVAYARC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.061112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450845 [ RunTime:0.105004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920216 LIMIT 4 [ RunTime:0.057847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920216 ORDER BY `minOrder` ASC [ RunTime:0.080574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920216 ORDER BY `unit` DESC [ RunTime:0.035655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920216 LIMIT 2 [ RunTime:0.010320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920216 ORDER BY `minOrder` ASC [ RunTime:0.036722s ]
select * from pdf where partno='228ADVAYGFCRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.091803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYGFCRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.037431s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920216 AND `partno` = '228ADVAYGFCRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450846 [ RunTime:0.019186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920217 LIMIT 4 [ RunTime:0.003520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920217 ORDER BY `minOrder` ASC [ RunTime:0.026905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920217 ORDER BY `unit` DESC [ RunTime:0.029875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920217 LIMIT 2 [ RunTime:0.083418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920217 ORDER BY `minOrder` ASC [ RunTime:0.024399s ]
select * from pdf where partno='228ADVAWFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.050783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.051612s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920217 AND `partno` = '228ADVAWFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450847 [ RunTime:0.032961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920218 LIMIT 4 [ RunTime:0.053462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920218 ORDER BY `minOrder` ASC [ RunTime:0.078518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920218 ORDER BY `unit` DESC [ RunTime:0.015180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920218 LIMIT 2 [ RunTime:0.027084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920218 ORDER BY `minOrder` ASC [ RunTime:0.003190s ]
select * from pdf where partno='228ADVAGFCMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016498s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920218 AND `partno` = '228ADVAGFCMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367108 [ RunTime:0.024779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920219 LIMIT 4 [ RunTime:0.016959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920219 ORDER BY `minOrder` ASC [ RunTime:0.014422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920219 ORDER BY `unit` DESC [ RunTime:0.017699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920219 LIMIT 2 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920219 ORDER BY `minOrder` ASC [ RunTime:0.009880s ]
select * from pdf where partno='228ADVARFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005532s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920219 AND `partno` = '228ADVARFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367109 [ RunTime:0.009738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920220 LIMIT 4 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920220 ORDER BY `minOrder` ASC [ RunTime:0.005141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920220 ORDER BY `unit` DESC [ RunTime:0.008987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920220 LIMIT 2 [ RunTime:0.006894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920220 ORDER BY `minOrder` ASC [ RunTime:0.003875s ]
select * from pdf where partno='228ADVAYGFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYGFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004677s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920220 AND `partno` = '228ADVAYGFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367110 [ RunTime:0.007927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920221 LIMIT 4 [ RunTime:0.015943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920221 ORDER BY `minOrder` ASC [ RunTime:0.019970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920221 ORDER BY `unit` DESC [ RunTime:0.003848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920221 LIMIT 2 [ RunTime:0.042893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920221 ORDER BY `minOrder` ASC [ RunTime:0.016370s ]
select * from pdf where partno='228ADVAGFCAE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCAE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006462s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920221 AND `partno` = '228ADVAGFCAE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367111 [ RunTime:0.053860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920222 LIMIT 4 [ RunTime:0.007111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920222 ORDER BY `minOrder` ASC [ RunTime:0.027311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920222 ORDER BY `unit` DESC [ RunTime:0.028289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920222 LIMIT 2 [ RunTime:0.013902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920222 ORDER BY `minOrder` ASC [ RunTime:0.010228s ]
select * from pdf where partno='228ADVARGFABBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARGFABBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011232s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920222 AND `partno` = '228ADVARGFABBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367112 [ RunTime:0.009331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920223 LIMIT 4 [ RunTime:0.015365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920223 ORDER BY `minOrder` ASC [ RunTime:0.008370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920223 ORDER BY `unit` DESC [ RunTime:0.029141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920223 LIMIT 2 [ RunTime:0.028960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920223 ORDER BY `minOrder` ASC [ RunTime:0.030966s ]
select * from pdf where partno='228ADVARFCMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004758s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920223 AND `partno` = '228ADVARFCMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450848 [ RunTime:0.008298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920224 LIMIT 4 [ RunTime:0.012574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920224 ORDER BY `minOrder` ASC [ RunTime:0.008447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920224 ORDER BY `unit` DESC [ RunTime:0.003535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920224 LIMIT 2 [ RunTime:0.002423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920224 ORDER BY `minOrder` ASC [ RunTime:0.006944s ]
select * from pdf where partno='228ADVARAFAMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARAFAMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003071s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920224 AND `partno` = '228ADVARAFAMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367113 [ RunTime:0.007837s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8540,20 [ RunTime:0.139474s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.142550s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.069557s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 643 [ RunTime:0.001640s ]