SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001554s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=2798&search=1' [ RunTime:0.002817s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001419s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001276s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.004928s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001449s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001436s ]
SELECT * FROM `stock_search` WHERE `partno` = '2798' LIMIT 1 [ RunTime:0.012811s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 07:13:13' WHERE `partno` = '2798' [ RunTime:0.013593s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001361s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029083s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901496 LIMIT 5 [ RunTime:0.015845s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901496 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901496 ORDER BY `unit` DESC [ RunTime:0.014093s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901496 LIMIT 2 [ RunTime:0.009683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901496 ORDER BY `minOrder` ASC [ RunTime:0.022394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900313 LIMIT 5 [ RunTime:0.011131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900313 ORDER BY `minOrder` ASC [ RunTime:0.012952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900313 ORDER BY `unit` DESC [ RunTime:0.013524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900313 LIMIT 2 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900313 ORDER BY `minOrder` ASC [ RunTime:0.001765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657118 LIMIT 5 [ RunTime:0.013575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657118 ORDER BY `minOrder` ASC [ RunTime:0.003758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657118 ORDER BY `unit` DESC [ RunTime:0.005460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657118 LIMIT 2 [ RunTime:0.029157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657118 ORDER BY `minOrder` ASC [ RunTime:0.013212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653440 LIMIT 5 [ RunTime:0.013624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653440 ORDER BY `minOrder` ASC [ RunTime:0.030777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19653440 ORDER BY `unit` DESC [ RunTime:0.012821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19653440 LIMIT 2 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653440 ORDER BY `minOrder` ASC [ RunTime:0.006984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632811 LIMIT 5 [ RunTime:0.004907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632811 ORDER BY `minOrder` ASC [ RunTime:0.003670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632811 ORDER BY `unit` DESC [ RunTime:0.004328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632811 LIMIT 2 [ RunTime:0.002082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632811 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310695 LIMIT 5 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310695 ORDER BY `minOrder` ASC [ RunTime:0.021601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310695 ORDER BY `unit` DESC [ RunTime:0.014582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310695 LIMIT 2 [ RunTime:0.011809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310695 ORDER BY `minOrder` ASC [ RunTime:0.006818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656483 LIMIT 5 [ RunTime:0.029649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656483 ORDER BY `minOrder` ASC [ RunTime:0.008660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656483 ORDER BY `unit` DESC [ RunTime:0.006074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656483 LIMIT 2 [ RunTime:0.004246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656483 ORDER BY `minOrder` ASC [ RunTime:0.009561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656438 LIMIT 5 [ RunTime:0.016333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656438 ORDER BY `minOrder` ASC [ RunTime:0.005926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656438 ORDER BY `unit` DESC [ RunTime:0.005630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656438 LIMIT 2 [ RunTime:0.010356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656438 ORDER BY `minOrder` ASC [ RunTime:0.001668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13231078 LIMIT 5 [ RunTime:0.014359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231078 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13231078 ORDER BY `unit` DESC [ RunTime:0.008022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13231078 LIMIT 2 [ RunTime:0.010594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231078 ORDER BY `minOrder` ASC [ RunTime:0.007484s ]
select * from pdf where partno='27984' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.009004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13222759 LIMIT 5 [ RunTime:0.005565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13222759 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13222759 ORDER BY `unit` DESC [ RunTime:0.003811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13222759 LIMIT 2 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13222759 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883431 LIMIT 5 [ RunTime:0.005192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883431 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883431 ORDER BY `unit` DESC [ RunTime:0.007539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883431 LIMIT 2 [ RunTime:0.010919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883431 ORDER BY `minOrder` ASC [ RunTime:0.001525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12565585 LIMIT 5 [ RunTime:0.002880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12565585 ORDER BY `minOrder` ASC [ RunTime:0.001571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12565585 ORDER BY `unit` DESC [ RunTime:0.000781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12565585 LIMIT 2 [ RunTime:0.006330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12565585 ORDER BY `minOrder` ASC [ RunTime:0.005343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390239 LIMIT 5 [ RunTime:0.029919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390239 ORDER BY `minOrder` ASC [ RunTime:0.025067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12390239 ORDER BY `unit` DESC [ RunTime:0.024474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12390239 LIMIT 2 [ RunTime:0.031619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390239 ORDER BY `minOrder` ASC [ RunTime:0.012298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12018846 LIMIT 5 [ RunTime:0.013539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12018846 ORDER BY `minOrder` ASC [ RunTime:0.007342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12018846 ORDER BY `unit` DESC [ RunTime:0.016236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12018846 LIMIT 2 [ RunTime:0.012576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12018846 ORDER BY `minOrder` ASC [ RunTime:0.010404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975217 LIMIT 5 [ RunTime:0.021318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975217 ORDER BY `minOrder` ASC [ RunTime:0.004554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975217 ORDER BY `unit` DESC [ RunTime:0.017048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975217 LIMIT 2 [ RunTime:0.007403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975217 ORDER BY `minOrder` ASC [ RunTime:0.021796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11963171 LIMIT 5 [ RunTime:0.028818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11963171 ORDER BY `minOrder` ASC [ RunTime:0.010162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11963171 ORDER BY `unit` DESC [ RunTime:0.014263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11963171 LIMIT 2 [ RunTime:0.020067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11963171 ORDER BY `minOrder` ASC [ RunTime:0.016472s ]
select * from pdf where partno='27985' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.023960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186961 LIMIT 5 [ RunTime:0.004747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186961 ORDER BY `minOrder` ASC [ RunTime:0.069567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186961 ORDER BY `unit` DESC [ RunTime:0.009805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186961 LIMIT 2 [ RunTime:0.012056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186961 ORDER BY `minOrder` ASC [ RunTime:0.011171s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024122s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53589174 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589174 ORDER BY `minOrder` ASC [ RunTime:0.014997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53589174 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53589174 LIMIT 2 [ RunTime:0.018397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589174 ORDER BY `minOrder` ASC [ RunTime:0.002066s ]
select * from pdf where partno='2798.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.011891s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.009164s ]
SELECT `id` FROM `stock` WHERE `id` <> 53589174 AND `partno` = '2798.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.023536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53589099 LIMIT 5 [ RunTime:0.018474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589099 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53589099 ORDER BY `unit` DESC [ RunTime:0.006445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53589099 LIMIT 2 [ RunTime:0.009301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589099 ORDER BY `minOrder` ASC [ RunTime:0.011039s ]
select * from pdf where partno='2798.0/100' and brandshort='Altech Corporation' limit 1 [ RunTime:0.007836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798.0/100' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.030555s ]
SELECT `id` FROM `stock` WHERE `id` <> 53589099 AND `partno` = '2798.0/100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.029272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57721598 LIMIT 5 [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57721598 ORDER BY `minOrder` ASC [ RunTime:0.015587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57721598 ORDER BY `unit` DESC [ RunTime:0.016505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57721598 LIMIT 2 [ RunTime:0.008178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57721598 ORDER BY `minOrder` ASC [ RunTime:0.025831s ]
select * from pdf where partno='2798844' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798844' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53650877 LIMIT 5 [ RunTime:0.022997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53650877 ORDER BY `minOrder` ASC [ RunTime:0.031453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53650877 ORDER BY `unit` DESC [ RunTime:0.026816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53650877 LIMIT 2 [ RunTime:0.002776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53650877 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
select * from pdf where partno='2798789' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798789' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321345 LIMIT 5 [ RunTime:0.004781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321345 ORDER BY `minOrder` ASC [ RunTime:0.005483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321345 ORDER BY `unit` DESC [ RunTime:0.002055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321345 LIMIT 2 [ RunTime:0.014051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321345 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
select * from pdf where partno='2798530' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798530' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57412677 LIMIT 5 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57412677 ORDER BY `minOrder` ASC [ RunTime:0.015687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57412677 ORDER BY `unit` DESC [ RunTime:0.006009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57412677 LIMIT 2 [ RunTime:0.012183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57412677 ORDER BY `minOrder` ASC [ RunTime:0.016930s ]
select * from pdf where partno='27985' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.004841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27985' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.017191s ]
SELECT `id` FROM `stock` WHERE `id` <> 57412677 AND `partno` = '27985' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.028948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11963171 [ RunTime:0.009980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57411380 LIMIT 5 [ RunTime:0.007444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57411380 ORDER BY `minOrder` ASC [ RunTime:0.013981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57411380 ORDER BY `unit` DESC [ RunTime:0.006727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57411380 LIMIT 2 [ RunTime:0.007733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57411380 ORDER BY `minOrder` ASC [ RunTime:0.001842s ]
select * from pdf where partno='27982' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.003413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27982' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.006299s ]
SELECT `id` FROM `stock` WHERE `id` <> 57411380 AND `partno` = '27982' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.009569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975217 [ RunTime:0.002957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57407395 LIMIT 5 [ RunTime:0.014645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407395 ORDER BY `minOrder` ASC [ RunTime:0.009433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57407395 ORDER BY `unit` DESC [ RunTime:0.029393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57407395 LIMIT 2 [ RunTime:0.005306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407395 ORDER BY `minOrder` ASC [ RunTime:0.001890s ]
select * from pdf where partno='27980' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.012666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27980' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.015003s ]
SELECT `id` FROM `stock` WHERE `id` <> 57407395 AND `partno` = '27980' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.014341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13222759 [ RunTime:0.022868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57407048 LIMIT 5 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407048 ORDER BY `minOrder` ASC [ RunTime:0.005570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57407048 ORDER BY `unit` DESC [ RunTime:0.007763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57407048 LIMIT 2 [ RunTime:0.025138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407048 ORDER BY `minOrder` ASC [ RunTime:0.021164s ]
select * from pdf where partno='27981' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.021134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27981' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.001476s ]
SELECT `id` FROM `stock` WHERE `id` <> 57407048 AND `partno` = '27981' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.007068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57407022 LIMIT 5 [ RunTime:0.021566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407022 ORDER BY `minOrder` ASC [ RunTime:0.020648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57407022 ORDER BY `unit` DESC [ RunTime:0.019728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57407022 LIMIT 2 [ RunTime:0.047808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57407022 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
select * from pdf where partno='27984' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.010040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27984' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.011500s ]
SELECT `id` FROM `stock` WHERE `id` <> 57407022 AND `partno` = '27984' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.015475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13231078 [ RunTime:0.007719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57204945 LIMIT 5 [ RunTime:0.017838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204945 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57204945 ORDER BY `unit` DESC [ RunTime:0.010743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57204945 LIMIT 2 [ RunTime:0.036420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204945 ORDER BY `minOrder` ASC [ RunTime:0.011192s ]
select * from pdf where partno='27983' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.001626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27983' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.008397s ]
SELECT `id` FROM `stock` WHERE `id` <> 57204945 AND `partno` = '27983' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.004267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390239 [ RunTime:0.003358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56600919 LIMIT 5 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600919 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56600919 ORDER BY `unit` DESC [ RunTime:0.009165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56600919 LIMIT 2 [ RunTime:0.005890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56600919 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='2798' and brandshort='80/20, LLC' limit 1 [ RunTime:0.005756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000777s ]
SELECT `id` FROM `stock` WHERE `id` <> 56600919 AND `partno` = '2798' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56577665 LIMIT 5 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577665 ORDER BY `minOrder` ASC [ RunTime:0.004464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56577665 ORDER BY `unit` DESC [ RunTime:0.006258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56577665 LIMIT 2 [ RunTime:0.015981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577665 ORDER BY `minOrder` ASC [ RunTime:0.006633s ]
select * from pdf where partno='2798' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.023000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005347s ]
SELECT `id` FROM `stock` WHERE `id` <> 56577665 AND `partno` = '2798' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.024061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53784425 LIMIT 5 [ RunTime:0.016126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53784425 ORDER BY `minOrder` ASC [ RunTime:0.019760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53784425 ORDER BY `unit` DESC [ RunTime:0.009473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53784425 LIMIT 2 [ RunTime:0.030211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53784425 ORDER BY `minOrder` ASC [ RunTime:0.005661s ]
select * from pdf where partno='2798' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.007918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.003302s ]
SELECT `id` FROM `stock` WHERE `id` <> 53784425 AND `partno` = '2798' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.005384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883431 [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731909 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731909 ORDER BY `minOrder` ASC [ RunTime:0.007714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731909 ORDER BY `unit` DESC [ RunTime:0.001966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731909 LIMIT 2 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731909 ORDER BY `minOrder` ASC [ RunTime:0.006293s ]
select * from pdf where partno='2798850000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798850000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004447s ]
SELECT `id` FROM `stock` WHERE `id` <> 53731909 AND `partno` = '2798850000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657118 [ RunTime:0.002342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53726208 LIMIT 5 [ RunTime:0.010466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726208 ORDER BY `minOrder` ASC [ RunTime:0.001247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53726208 ORDER BY `unit` DESC [ RunTime:0.000985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53726208 LIMIT 2 [ RunTime:0.001171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726208 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='2798840000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798840000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000855s ]
SELECT `id` FROM `stock` WHERE `id` <> 53726208 AND `partno` = '2798840000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310695 [ RunTime:0.003569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53702332 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702332 ORDER BY `minOrder` ASC [ RunTime:0.001510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53702332 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53702332 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702332 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='2798090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002232s ]
SELECT `id` FROM `stock` WHERE `id` <> 53702332 AND `partno` = '2798090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632811 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53649605 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649605 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53649605 ORDER BY `unit` DESC [ RunTime:0.003922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53649605 LIMIT 2 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649605 ORDER BY `minOrder` ASC [ RunTime:0.004771s ]
select * from pdf where partno='2798792' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798792' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51659518 LIMIT 5 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51659518 ORDER BY `minOrder` ASC [ RunTime:0.005687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51659518 ORDER BY `unit` DESC [ RunTime:0.001032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51659518 LIMIT 2 [ RunTime:0.005656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51659518 ORDER BY `minOrder` ASC [ RunTime:0.002350s ]
select * from pdf where partno='27983' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.003093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27983' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000925s ]
SELECT `id` FROM `stock` WHERE `id` <> 51659518 AND `partno` = '27983' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186961 [ RunTime:0.009669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51334521 LIMIT 5 [ RunTime:0.002490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51334521 ORDER BY `minOrder` ASC [ RunTime:0.006109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51334521 ORDER BY `unit` DESC [ RunTime:0.005849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51334521 LIMIT 2 [ RunTime:0.004355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51334521 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='2798527' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2798527' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006109s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011410s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002814s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001412s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006588s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003829s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017896s ]
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 '2798%' OR `brand` LIKE '2798%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001990s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2798%' OR `brand` LIKE '2798%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001961s ]