SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002389s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=106053&search=1' [ RunTime:0.003311s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002549s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004372s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002880s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.005973s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004008s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004836s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001692s ]
SELECT * FROM `stock_search` WHERE `partno` = '106053' LIMIT 1 [ RunTime:0.001558s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 04:25:28' WHERE `partno` = '106053' [ RunTime:0.014804s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001461s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019577s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671805 LIMIT 5 [ RunTime:0.015234s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671805 ORDER BY `minOrder` ASC [ RunTime:0.011997s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671805 ORDER BY `unit` DESC [ RunTime:0.013856s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671805 LIMIT 2 [ RunTime:0.041846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671805 ORDER BY `minOrder` ASC [ RunTime:0.008082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454811 LIMIT 5 [ RunTime:0.026678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454811 ORDER BY `minOrder` ASC [ RunTime:0.014428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454811 ORDER BY `unit` DESC [ RunTime:0.026624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454811 LIMIT 2 [ RunTime:0.015902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454811 ORDER BY `minOrder` ASC [ RunTime:0.013520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662354 LIMIT 5 [ RunTime:0.021314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662354 ORDER BY `minOrder` ASC [ RunTime:0.021242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662354 ORDER BY `unit` DESC [ RunTime:0.021679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662354 LIMIT 2 [ RunTime:0.047509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662354 ORDER BY `minOrder` ASC [ RunTime:0.021751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672538 LIMIT 5 [ RunTime:0.002091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672538 ORDER BY `minOrder` ASC [ RunTime:0.021249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672538 ORDER BY `unit` DESC [ RunTime:0.072654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672538 LIMIT 2 [ RunTime:0.066547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672538 ORDER BY `minOrder` ASC [ RunTime:0.018396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672520 LIMIT 5 [ RunTime:0.032117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672520 ORDER BY `minOrder` ASC [ RunTime:0.018794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672520 ORDER BY `unit` DESC [ RunTime:0.025376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672520 LIMIT 2 [ RunTime:0.009602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672520 ORDER BY `minOrder` ASC [ RunTime:0.004767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672498 LIMIT 5 [ RunTime:0.013186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672498 ORDER BY `minOrder` ASC [ RunTime:0.012071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672498 ORDER BY `unit` DESC [ RunTime:0.019712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672498 LIMIT 2 [ RunTime:0.016095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672498 ORDER BY `minOrder` ASC [ RunTime:0.003845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672493 LIMIT 5 [ RunTime:0.003301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672493 ORDER BY `minOrder` ASC [ RunTime:0.011289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672493 ORDER BY `unit` DESC [ RunTime:0.051313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672493 LIMIT 2 [ RunTime:0.004893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672493 ORDER BY `minOrder` ASC [ RunTime:0.009145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672472 LIMIT 5 [ RunTime:0.032016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672472 ORDER BY `minOrder` ASC [ RunTime:0.010459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672472 ORDER BY `unit` DESC [ RunTime:0.002239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672472 LIMIT 2 [ RunTime:0.001753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672472 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672465 LIMIT 5 [ RunTime:0.019777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672465 ORDER BY `minOrder` ASC [ RunTime:0.007161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672465 ORDER BY `unit` DESC [ RunTime:0.002842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672465 LIMIT 2 [ RunTime:0.017645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672465 ORDER BY `minOrder` ASC [ RunTime:0.006016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672464 LIMIT 5 [ RunTime:0.003686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672464 ORDER BY `minOrder` ASC [ RunTime:0.005786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672464 ORDER BY `unit` DESC [ RunTime:0.011425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672464 LIMIT 2 [ RunTime:0.015024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672464 ORDER BY `minOrder` ASC [ RunTime:0.003263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672089 LIMIT 5 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672089 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672089 ORDER BY `unit` DESC [ RunTime:0.006100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672089 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672089 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='1060530500' and brandshort='Molex' limit 1 [ RunTime:0.005688s ]
select foldpath,foldpath2,filename from pdf_file where id=1660315 limit 1 [ RunTime:0.008215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770820 LIMIT 5 [ RunTime:0.026247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770820 ORDER BY `minOrder` ASC [ RunTime:0.031189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770820 ORDER BY `unit` DESC [ RunTime:0.031538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770820 LIMIT 2 [ RunTime:0.005016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770820 ORDER BY `minOrder` ASC [ RunTime:0.008526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770710 LIMIT 5 [ RunTime:0.014924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770710 ORDER BY `minOrder` ASC [ RunTime:0.013286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770710 ORDER BY `unit` DESC [ RunTime:0.009936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770710 LIMIT 2 [ RunTime:0.040917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770710 ORDER BY `minOrder` ASC [ RunTime:0.029860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770709 LIMIT 5 [ RunTime:0.017616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770709 ORDER BY `minOrder` ASC [ RunTime:0.015492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770709 ORDER BY `unit` DESC [ RunTime:0.006335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770709 LIMIT 2 [ RunTime:0.022493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770709 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770674 LIMIT 5 [ RunTime:0.015461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770674 ORDER BY `minOrder` ASC [ RunTime:0.009601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770674 ORDER BY `unit` DESC [ RunTime:0.002539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770674 LIMIT 2 [ RunTime:0.023224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770674 ORDER BY `minOrder` ASC [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770673 LIMIT 5 [ RunTime:0.015627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770673 ORDER BY `minOrder` ASC [ RunTime:0.002544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770673 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770673 LIMIT 2 [ RunTime:0.006865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770673 ORDER BY `minOrder` ASC [ RunTime:0.006781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770672 LIMIT 5 [ RunTime:0.012511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770672 ORDER BY `minOrder` ASC [ RunTime:0.028222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770672 ORDER BY `unit` DESC [ RunTime:0.009808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770672 LIMIT 2 [ RunTime:0.003237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770672 ORDER BY `minOrder` ASC [ RunTime:0.017217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17314628 LIMIT 5 [ RunTime:0.008654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17314628 ORDER BY `minOrder` ASC [ RunTime:0.016543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17314628 ORDER BY `unit` DESC [ RunTime:0.025266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17314628 LIMIT 2 [ RunTime:0.037871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17314628 ORDER BY `minOrder` ASC [ RunTime:0.021735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010209 LIMIT 5 [ RunTime:0.008145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010209 ORDER BY `minOrder` ASC [ RunTime:0.009742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010209 ORDER BY `unit` DESC [ RunTime:0.006573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010209 LIMIT 2 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010209 ORDER BY `minOrder` ASC [ RunTime:0.028807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010208 LIMIT 5 [ RunTime:0.009026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010208 ORDER BY `minOrder` ASC [ RunTime:0.010975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010208 ORDER BY `unit` DESC [ RunTime:0.045548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010208 LIMIT 2 [ RunTime:0.039136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010208 ORDER BY `minOrder` ASC [ RunTime:0.004685s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014206s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62117938 LIMIT 5 [ RunTime:0.013085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62117938 ORDER BY `minOrder` ASC [ RunTime:0.020449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62117938 ORDER BY `unit` DESC [ RunTime:0.011536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62117938 LIMIT 2 [ RunTime:0.013227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62117938 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
select * from pdf where partno='1060533500' and brandshort='Molex' limit 1 [ RunTime:0.004795s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060533500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60487934 LIMIT 5 [ RunTime:0.035346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487934 ORDER BY `minOrder` ASC [ RunTime:0.009312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60487934 ORDER BY `unit` DESC [ RunTime:0.002203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60487934 LIMIT 2 [ RunTime:0.020632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487934 ORDER BY `minOrder` ASC [ RunTime:0.033335s ]
select * from pdf where partno='1060530000' and brandshort='Weidmüller' limit 1 [ RunTime:0.047090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060530000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024870s ]
SELECT `id` FROM `stock` WHERE `id` <> 60487934 AND `partno` = '1060530000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.041185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662354 [ RunTime:0.012594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800523 LIMIT 5 [ RunTime:0.042778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800523 ORDER BY `minOrder` ASC [ RunTime:0.026649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800523 ORDER BY `unit` DESC [ RunTime:0.062093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800523 LIMIT 2 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800523 ORDER BY `minOrder` ASC [ RunTime:0.003303s ]
select * from pdf where partno='1060534' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060534' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051295s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800523 AND `partno` = '1060534' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.077340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223020 [ RunTime:0.038165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800522 LIMIT 5 [ RunTime:0.004731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800522 ORDER BY `minOrder` ASC [ RunTime:0.034570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800522 ORDER BY `unit` DESC [ RunTime:0.031550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800522 LIMIT 2 [ RunTime:0.065974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800522 ORDER BY `minOrder` ASC [ RunTime:0.008845s ]
select * from pdf where partno='1060533' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.140924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060533' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031133s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800522 AND `partno` = '1060533' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223019 [ RunTime:0.049388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800521 LIMIT 5 [ RunTime:0.015844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800521 ORDER BY `minOrder` ASC [ RunTime:0.044234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800521 ORDER BY `unit` DESC [ RunTime:0.049630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800521 LIMIT 2 [ RunTime:0.038721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800521 ORDER BY `minOrder` ASC [ RunTime:0.002858s ]
select * from pdf where partno='1060532' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060532' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024226s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800521 AND `partno` = '1060532' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.057011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770820 [ RunTime:0.016209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800463 LIMIT 5 [ RunTime:0.017043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800463 ORDER BY `minOrder` ASC [ RunTime:0.035913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800463 ORDER BY `unit` DESC [ RunTime:0.046257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800463 LIMIT 2 [ RunTime:0.050946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800463 ORDER BY `minOrder` ASC [ RunTime:0.012753s ]
select * from pdf where partno='1060531' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060531' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017068s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800463 AND `partno` = '1060531' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010209 [ RunTime:0.010294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800462 LIMIT 5 [ RunTime:0.016185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800462 ORDER BY `minOrder` ASC [ RunTime:0.024230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800462 ORDER BY `unit` DESC [ RunTime:0.017390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800462 LIMIT 2 [ RunTime:0.025453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800462 ORDER BY `minOrder` ASC [ RunTime:0.027172s ]
select * from pdf where partno='1060530' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060530' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015348s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800462 AND `partno` = '1060530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010208 [ RunTime:0.038835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800367 LIMIT 5 [ RunTime:0.004436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800367 ORDER BY `minOrder` ASC [ RunTime:0.006309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800367 ORDER BY `unit` DESC [ RunTime:0.012807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800367 LIMIT 2 [ RunTime:0.033546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800367 ORDER BY `minOrder` ASC [ RunTime:0.011935s ]
select * from pdf where partno='1060539' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060539' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000921s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800367 AND `partno` = '1060539' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770710 [ RunTime:0.007101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800366 LIMIT 5 [ RunTime:0.009311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800366 ORDER BY `minOrder` ASC [ RunTime:0.007709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800366 ORDER BY `unit` DESC [ RunTime:0.008740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800366 LIMIT 2 [ RunTime:0.007369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800366 ORDER BY `minOrder` ASC [ RunTime:0.009718s ]
select * from pdf where partno='1060538' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060538' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009046s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800366 AND `partno` = '1060538' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770709 [ RunTime:0.004551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800308 LIMIT 5 [ RunTime:0.009807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800308 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800308 ORDER BY `unit` DESC [ RunTime:0.023972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800308 LIMIT 2 [ RunTime:0.021526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800308 ORDER BY `minOrder` ASC [ RunTime:0.004042s ]
select * from pdf where partno='1060537' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060537' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008661s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800308 AND `partno` = '1060537' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770674 [ RunTime:0.026380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800307 LIMIT 5 [ RunTime:0.005935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800307 ORDER BY `minOrder` ASC [ RunTime:0.027016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800307 ORDER BY `unit` DESC [ RunTime:0.016965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800307 LIMIT 2 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800307 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
select * from pdf where partno='1060536' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060536' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032154s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800307 AND `partno` = '1060536' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.043024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770673 [ RunTime:0.006498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800306 LIMIT 5 [ RunTime:0.008455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800306 ORDER BY `minOrder` ASC [ RunTime:0.018718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800306 ORDER BY `unit` DESC [ RunTime:0.005008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800306 LIMIT 2 [ RunTime:0.035705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800306 ORDER BY `minOrder` ASC [ RunTime:0.019196s ]
select * from pdf where partno='1060535' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060535' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007456s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800306 AND `partno` = '1060535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770672 [ RunTime:0.009439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64535024 LIMIT 5 [ RunTime:0.016384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64535024 ORDER BY `minOrder` ASC [ RunTime:0.025739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64535024 ORDER BY `unit` DESC [ RunTime:0.048604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64535024 LIMIT 2 [ RunTime:0.024768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64535024 ORDER BY `minOrder` ASC [ RunTime:0.005043s ]
select * from pdf where partno='106053' and brandshort='Brady Corporation' limit 1 [ RunTime:0.022886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106053' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.024901s ]
SELECT `id` FROM `stock` WHERE `id` <> 64535024 AND `partno` = '106053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426035 [ RunTime:0.021326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118418 LIMIT 5 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118418 ORDER BY `minOrder` ASC [ RunTime:0.067206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118418 ORDER BY `unit` DESC [ RunTime:0.020416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118418 LIMIT 2 [ RunTime:0.029534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118418 ORDER BY `minOrder` ASC [ RunTime:0.001995s ]
select * from pdf where partno='1060533000' and brandshort='Molex' limit 1 [ RunTime:0.024000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060533000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.041047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118368 LIMIT 5 [ RunTime:0.034936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118368 ORDER BY `minOrder` ASC [ RunTime:0.015188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118368 ORDER BY `unit` DESC [ RunTime:0.028664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118368 LIMIT 2 [ RunTime:0.025362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118368 ORDER BY `minOrder` ASC [ RunTime:0.036021s ]
select * from pdf where partno='1060534400' and brandshort='Molex' limit 1 [ RunTime:0.038364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060534400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.046074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118362 LIMIT 5 [ RunTime:0.006509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118362 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118362 ORDER BY `unit` DESC [ RunTime:0.009332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118362 LIMIT 2 [ RunTime:0.011027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118362 ORDER BY `minOrder` ASC [ RunTime:0.042338s ]
select * from pdf where partno='1060532180' and brandshort='Molex' limit 1 [ RunTime:0.043780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060532180' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118352 LIMIT 5 [ RunTime:0.045867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118352 ORDER BY `minOrder` ASC [ RunTime:0.049551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118352 ORDER BY `unit` DESC [ RunTime:0.033417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118352 LIMIT 2 [ RunTime:0.028462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118352 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
select * from pdf where partno='1060534000' and brandshort='Molex' limit 1 [ RunTime:0.020956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060534000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.056420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118325 LIMIT 5 [ RunTime:0.030122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118325 ORDER BY `minOrder` ASC [ RunTime:0.032983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118325 ORDER BY `unit` DESC [ RunTime:0.049048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118325 LIMIT 2 [ RunTime:0.042663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118325 ORDER BY `minOrder` ASC [ RunTime:0.043117s ]
select * from pdf where partno='1060533400' and brandshort='Molex' limit 1 [ RunTime:0.030879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060533400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.068975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118318 LIMIT 5 [ RunTime:0.020542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118318 ORDER BY `minOrder` ASC [ RunTime:0.051206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118318 ORDER BY `unit` DESC [ RunTime:0.004191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118318 LIMIT 2 [ RunTime:0.049193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118318 ORDER BY `minOrder` ASC [ RunTime:0.030472s ]
select * from pdf where partno='1060535500' and brandshort='Molex' limit 1 [ RunTime:0.031721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060535500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.070961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118317 LIMIT 5 [ RunTime:0.012616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118317 ORDER BY `minOrder` ASC [ RunTime:0.042141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118317 ORDER BY `unit` DESC [ RunTime:0.041577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118317 LIMIT 2 [ RunTime:0.034090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118317 ORDER BY `minOrder` ASC [ RunTime:0.018135s ]
select * from pdf where partno='1060535000' and brandshort='Molex' limit 1 [ RunTime:0.020591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1060535000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.060426s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025923s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013723s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024131s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001263s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011903s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007179s ]
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 '106053%' OR `brand` LIKE '106053%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015990s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '106053%' OR `brand` LIKE '106053%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022916s ]