SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001184s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=2000-3&search=1' [ RunTime:0.023770s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001297s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016025s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002571s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.002842s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001577s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016862s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001366s ]
SELECT * FROM `stock_search` WHERE `partno` = '2000-3' LIMIT 1 [ RunTime:0.040021s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 00:30:32' WHERE `partno` = '2000-3' [ RunTime:0.023531s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001530s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018317s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593736 LIMIT 5 [ RunTime:0.010074s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593736 ORDER BY `minOrder` ASC [ RunTime:0.009642s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593736 ORDER BY `unit` DESC [ RunTime:0.005476s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593736 LIMIT 2 [ RunTime:0.017307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593736 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11411164 LIMIT 5 [ RunTime:0.021544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11411164 ORDER BY `minOrder` ASC [ RunTime:0.008132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11411164 ORDER BY `unit` DESC [ RunTime:0.009648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11411164 LIMIT 2 [ RunTime:0.010990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11411164 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14289572 LIMIT 5 [ RunTime:0.002153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289572 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14289572 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14289572 LIMIT 2 [ RunTime:0.008184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289572 ORDER BY `minOrder` ASC [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16392069 LIMIT 5 [ RunTime:0.004969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16392069 ORDER BY `minOrder` ASC [ RunTime:0.003713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16392069 ORDER BY `unit` DESC [ RunTime:0.020982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16392069 LIMIT 2 [ RunTime:0.010564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16392069 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344217 LIMIT 5 [ RunTime:0.011382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344217 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14344217 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14344217 LIMIT 2 [ RunTime:0.015944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344217 ORDER BY `minOrder` ASC [ RunTime:0.008132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13456949 LIMIT 5 [ RunTime:0.044462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13456949 ORDER BY `minOrder` ASC [ RunTime:0.025184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13456949 ORDER BY `unit` DESC [ RunTime:0.006233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13456949 LIMIT 2 [ RunTime:0.009432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13456949 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427503 LIMIT 5 [ RunTime:0.005653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427503 ORDER BY `minOrder` ASC [ RunTime:0.015600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13427503 ORDER BY `unit` DESC [ RunTime:0.012276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13427503 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427503 ORDER BY `minOrder` ASC [ RunTime:0.005007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313289 LIMIT 5 [ RunTime:0.011025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313289 ORDER BY `minOrder` ASC [ RunTime:0.017390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313289 ORDER BY `unit` DESC [ RunTime:0.019074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313289 LIMIT 2 [ RunTime:0.021902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313289 ORDER BY `minOrder` ASC [ RunTime:0.021760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13311893 LIMIT 5 [ RunTime:0.033808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13311893 ORDER BY `minOrder` ASC [ RunTime:0.020481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13311893 ORDER BY `unit` DESC [ RunTime:0.029456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13311893 LIMIT 2 [ RunTime:0.008551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13311893 ORDER BY `minOrder` ASC [ RunTime:0.007824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12076872 LIMIT 5 [ RunTime:0.004721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12076872 ORDER BY `minOrder` ASC [ RunTime:0.011248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12076872 ORDER BY `unit` DESC [ RunTime:0.001435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12076872 LIMIT 2 [ RunTime:0.018942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12076872 ORDER BY `minOrder` ASC [ RunTime:0.007649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039091 LIMIT 5 [ RunTime:0.015846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039091 ORDER BY `minOrder` ASC [ RunTime:0.006976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039091 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039091 LIMIT 2 [ RunTime:0.004696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039091 ORDER BY `minOrder` ASC [ RunTime:0.004203s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013783s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393304 LIMIT 5 [ RunTime:0.039427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393304 ORDER BY `minOrder` ASC [ RunTime:0.013629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393304 ORDER BY `unit` DESC [ RunTime:0.013420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393304 LIMIT 2 [ RunTime:0.011854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393304 ORDER BY `minOrder` ASC [ RunTime:0.022228s ]
select * from pdf where partno='2000-3-15-20-75-14-11-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013939s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3-15-20-75-14-11-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.014193s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393304 AND `partno` = '2000-3-15-20-75-14-11-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.010934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11411164 [ RunTime:0.015214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60311292 LIMIT 5 [ RunTime:0.023338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311292 ORDER BY `minOrder` ASC [ RunTime:0.035039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60311292 ORDER BY `unit` DESC [ RunTime:0.030799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60311292 LIMIT 2 [ RunTime:0.036572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311292 ORDER BY `minOrder` ASC [ RunTime:0.058993s ]
select * from pdf where partno='2000-3' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.019581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.030077s ]
SELECT `id` FROM `stock` WHERE `id` <> 60311292 AND `partno` = '2000-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.029787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593736 [ RunTime:0.033391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40468531 LIMIT 5 [ RunTime:0.038289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40468531 ORDER BY `minOrder` ASC [ RunTime:0.043566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40468531 ORDER BY `unit` DESC [ RunTime:0.008538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40468531 LIMIT 2 [ RunTime:0.014178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40468531 ORDER BY `minOrder` ASC [ RunTime:0.005950s ]
select * from pdf where partno='2000-3R3-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.023597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3R3-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019558s ]
SELECT `id` FROM `stock` WHERE `id` <> 40468531 AND `partno` = '2000-3R3-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.038706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14289572 [ RunTime:0.052559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40478601 LIMIT 5 [ RunTime:0.038463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40478601 ORDER BY `minOrder` ASC [ RunTime:0.008073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40478601 ORDER BY `unit` DESC [ RunTime:0.022798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40478601 LIMIT 2 [ RunTime:0.035072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40478601 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
select * from pdf where partno='2000-330-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-330-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003193s ]
SELECT `id` FROM `stock` WHERE `id` <> 40478601 AND `partno` = '2000-330-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.023475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427503 [ RunTime:0.007269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526635 LIMIT 5 [ RunTime:0.008646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526635 ORDER BY `minOrder` ASC [ RunTime:0.019927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526635 ORDER BY `unit` DESC [ RunTime:0.023906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526635 LIMIT 2 [ RunTime:0.006199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526635 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
select * from pdf where partno='2000-3U-160H-LF' and brandshort='Twin Industries' limit 1 [ RunTime:0.013011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3U-160H-LF' OR `brand` LIKE 'Twin Industries%' ) ) LIMIT 1 [ RunTime:0.023594s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526635 AND `partno` = '2000-3U-160H-LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%twin industries%' ) [ RunTime:0.004530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686850 LIMIT 5 [ RunTime:0.035736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686850 ORDER BY `minOrder` ASC [ RunTime:0.033630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686850 ORDER BY `unit` DESC [ RunTime:0.003014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686850 LIMIT 2 [ RunTime:0.005367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686850 ORDER BY `minOrder` ASC [ RunTime:0.001351s ]
select * from pdf where partno='2000-30PA' and brandshort='Dwyer' limit 1 [ RunTime:0.010239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30PA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.010242s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686850 AND `partno` = '2000-30PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.016623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32535279 [ RunTime:0.022292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686792 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686792 ORDER BY `minOrder` ASC [ RunTime:0.012051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686792 ORDER BY `unit` DESC [ RunTime:0.000782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686792 LIMIT 2 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686792 ORDER BY `minOrder` ASC [ RunTime:0.007044s ]
select * from pdf where partno='2000-300CM' and brandshort='Dwyer' limit 1 [ RunTime:0.005571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-300CM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.026382s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686792 AND `partno` = '2000-300CM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.005300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532258 [ RunTime:0.005422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686136 LIMIT 5 [ RunTime:0.005317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686136 ORDER BY `minOrder` ASC [ RunTime:0.029094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686136 ORDER BY `unit` DESC [ RunTime:0.042589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686136 LIMIT 2 [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686136 ORDER BY `minOrder` ASC [ RunTime:0.006206s ]
select * from pdf where partno='2000-3KPA' and brandshort='Dwyer' limit 1 [ RunTime:0.003840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3KPA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.001986s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686136 AND `partno` = '2000-3KPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.040141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514051 [ RunTime:0.016456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686132 LIMIT 5 [ RunTime:0.004974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686132 ORDER BY `minOrder` ASC [ RunTime:0.009642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686132 ORDER BY `unit` DESC [ RunTime:0.009372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686132 LIMIT 2 [ RunTime:0.005459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686132 ORDER BY `minOrder` ASC [ RunTime:0.008115s ]
select * from pdf where partno='2000-30CM' and brandshort='Dwyer' limit 1 [ RunTime:0.003697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30CM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.007284s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686132 AND `partno` = '2000-30CM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.043696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514047 [ RunTime:0.011703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686128 LIMIT 5 [ RunTime:0.029126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686128 ORDER BY `minOrder` ASC [ RunTime:0.024855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686128 ORDER BY `unit` DESC [ RunTime:0.083489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686128 LIMIT 2 [ RunTime:0.025533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686128 ORDER BY `minOrder` ASC [ RunTime:0.023076s ]
select * from pdf where partno='2000-30MM' and brandshort='Dwyer' limit 1 [ RunTime:0.049942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30MM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.016549s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686128 AND `partno` = '2000-30MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.037491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514043 [ RunTime:0.025385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686127 LIMIT 5 [ RunTime:0.043893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686127 ORDER BY `minOrder` ASC [ RunTime:0.043192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686127 ORDER BY `unit` DESC [ RunTime:0.048818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686127 LIMIT 2 [ RunTime:0.027208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686127 ORDER BY `minOrder` ASC [ RunTime:0.024048s ]
select * from pdf where partno='2000-300PA' and brandshort='Dwyer' limit 1 [ RunTime:0.047945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-300PA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.028391s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686127 AND `partno` = '2000-300PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.014594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514042 [ RunTime:0.014196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686124 LIMIT 5 [ RunTime:0.012673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686124 ORDER BY `minOrder` ASC [ RunTime:0.026316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686124 ORDER BY `unit` DESC [ RunTime:0.033298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686124 LIMIT 2 [ RunTime:0.012037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686124 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='2000-300MM' and brandshort='Dwyer' limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-300MM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.048819s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686124 AND `partno` = '2000-300MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.032670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514039 [ RunTime:0.065789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686123 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686123 ORDER BY `minOrder` ASC [ RunTime:0.021150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686123 ORDER BY `unit` DESC [ RunTime:0.032829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686123 LIMIT 2 [ RunTime:0.008400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686123 ORDER BY `minOrder` ASC [ RunTime:0.011520s ]
select * from pdf where partno='2000-30KPA' and brandshort='Dwyer' limit 1 [ RunTime:0.008402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30KPA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.018321s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686123 AND `partno` = '2000-30KPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.016211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514038 [ RunTime:0.016573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40557480 LIMIT 5 [ RunTime:0.022635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557480 ORDER BY `minOrder` ASC [ RunTime:0.055404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40557480 ORDER BY `unit` DESC [ RunTime:0.030325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40557480 LIMIT 2 [ RunTime:0.017250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557480 ORDER BY `minOrder` ASC [ RunTime:0.026994s ]
select * from pdf where partno='2000-3R9-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3R9-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.025062s ]
SELECT `id` FROM `stock` WHERE `id` <> 40557480 AND `partno` = '2000-3R9-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16392069 [ RunTime:0.012213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40557479 LIMIT 5 [ RunTime:0.008912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557479 ORDER BY `minOrder` ASC [ RunTime:0.017126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40557479 ORDER BY `unit` DESC [ RunTime:0.015093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40557479 LIMIT 2 [ RunTime:0.050302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557479 ORDER BY `minOrder` ASC [ RunTime:0.002549s ]
select * from pdf where partno='2000-330-H-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-330-H-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.020329s ]
SELECT `id` FROM `stock` WHERE `id` <> 40557479 AND `partno` = '2000-330-H-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13456949 [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40557469 LIMIT 5 [ RunTime:0.008757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557469 ORDER BY `minOrder` ASC [ RunTime:0.034570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40557469 ORDER BY `unit` DESC [ RunTime:0.008323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40557469 LIMIT 2 [ RunTime:0.008448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40557469 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
select * from pdf where partno='2000-3R3-H-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.016200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3R3-H-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.021334s ]
SELECT `id` FROM `stock` WHERE `id` <> 40557469 AND `partno` = '2000-3R3-H-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344217 [ RunTime:0.028868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32535279 LIMIT 5 [ RunTime:0.015408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535279 ORDER BY `minOrder` ASC [ RunTime:0.013809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32535279 ORDER BY `unit` DESC [ RunTime:0.001543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32535279 LIMIT 2 [ RunTime:0.009826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535279 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
select * from pdf where partno='2000-30PA' and brandshort='Dwyer' limit 1 [ RunTime:0.015337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30PA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004439s ]
SELECT `id` FROM `stock` WHERE `id` <> 32535279 AND `partno` = '2000-30PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.014086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686850 [ RunTime:0.003207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532258 LIMIT 5 [ RunTime:0.009893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532258 ORDER BY `minOrder` ASC [ RunTime:0.023205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532258 ORDER BY `unit` DESC [ RunTime:0.019539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532258 LIMIT 2 [ RunTime:0.039267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532258 ORDER BY `minOrder` ASC [ RunTime:0.024536s ]
select * from pdf where partno='2000-300CM' and brandshort='Dwyer' limit 1 [ RunTime:0.003372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-300CM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004195s ]
SELECT `id` FROM `stock` WHERE `id` <> 32532258 AND `partno` = '2000-300CM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.003880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686792 [ RunTime:0.007133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514051 LIMIT 5 [ RunTime:0.016722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514051 ORDER BY `minOrder` ASC [ RunTime:0.006369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32514051 ORDER BY `unit` DESC [ RunTime:0.012471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32514051 LIMIT 2 [ RunTime:0.026965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514051 ORDER BY `minOrder` ASC [ RunTime:0.012113s ]
select * from pdf where partno='2000-3KPA' and brandshort='Dwyer' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-3KPA' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT `id` FROM `stock` WHERE `id` <> 32514051 AND `partno` = '2000-3KPA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.003199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686136 [ RunTime:0.028253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514047 LIMIT 5 [ RunTime:0.047465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514047 ORDER BY `minOrder` ASC [ RunTime:0.010711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32514047 ORDER BY `unit` DESC [ RunTime:0.002541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32514047 LIMIT 2 [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514047 ORDER BY `minOrder` ASC [ RunTime:0.017056s ]
select * from pdf where partno='2000-30CM' and brandshort='Dwyer' limit 1 [ RunTime:0.004303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000-30CM' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.010601s ]
SELECT `id` FROM `stock` WHERE `id` <> 32514047 AND `partno` = '2000-30CM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.011849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686132 [ RunTime:0.023022s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025054s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007477s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012291s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004487s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008415s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001395s ]
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 '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011539s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2000-3%' OR `brand` LIKE '2000-3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015678s ]