SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002172s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `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=14018&search=1' [ RunTime:0.002003s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001558s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002100s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001810s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002019s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001688s ]
SELECT * FROM `stock_search` WHERE `partno` = '14018' LIMIT 1 [ RunTime:0.006056s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 00:28:48' WHERE `partno` = '14018' [ RunTime:0.002044s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001101s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023445s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789892 LIMIT 5 [ RunTime:0.005879s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789892 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13789892 ORDER BY `unit` DESC [ RunTime:0.013474s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13789892 LIMIT 2 [ RunTime:0.015602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789892 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071926 LIMIT 5 [ RunTime:0.006903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071926 ORDER BY `minOrder` ASC [ RunTime:0.020271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071926 ORDER BY `unit` DESC [ RunTime:0.022618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071926 LIMIT 2 [ RunTime:0.012594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071926 ORDER BY `minOrder` ASC [ RunTime:0.009474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071777 LIMIT 5 [ RunTime:0.011435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071777 ORDER BY `minOrder` ASC [ RunTime:0.017162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071777 ORDER BY `unit` DESC [ RunTime:0.034516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071777 LIMIT 2 [ RunTime:0.004045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071777 ORDER BY `minOrder` ASC [ RunTime:0.006392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354058 LIMIT 5 [ RunTime:0.012312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354058 ORDER BY `minOrder` ASC [ RunTime:0.008577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354058 ORDER BY `unit` DESC [ RunTime:0.003334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354058 LIMIT 2 [ RunTime:0.030358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354058 ORDER BY `minOrder` ASC [ RunTime:0.007783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13788623 LIMIT 5 [ RunTime:0.023774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13788623 ORDER BY `minOrder` ASC [ RunTime:0.032162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13788623 ORDER BY `unit` DESC [ RunTime:0.028579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13788623 LIMIT 2 [ RunTime:0.015028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13788623 ORDER BY `minOrder` ASC [ RunTime:0.010409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074958 LIMIT 5 [ RunTime:0.018922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074958 ORDER BY `minOrder` ASC [ RunTime:0.004526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074958 ORDER BY `unit` DESC [ RunTime:0.005006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074958 LIMIT 2 [ RunTime:0.007513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074958 ORDER BY `minOrder` ASC [ RunTime:0.014863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19631465 LIMIT 5 [ RunTime:0.016344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19631465 ORDER BY `minOrder` ASC [ RunTime:0.006525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19631465 ORDER BY `unit` DESC [ RunTime:0.007864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19631465 LIMIT 2 [ RunTime:0.006461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19631465 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19627466 LIMIT 5 [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19627466 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19627466 ORDER BY `unit` DESC [ RunTime:0.007070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19627466 LIMIT 2 [ RunTime:0.005856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19627466 ORDER BY `minOrder` ASC [ RunTime:0.007739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19622654 LIMIT 5 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622654 ORDER BY `minOrder` ASC [ RunTime:0.002523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19622654 ORDER BY `unit` DESC [ RunTime:0.007811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19622654 LIMIT 2 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622654 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19620091 LIMIT 5 [ RunTime:0.005629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19620091 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19620091 ORDER BY `unit` DESC [ RunTime:0.010649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19620091 LIMIT 2 [ RunTime:0.004975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19620091 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19617144 LIMIT 5 [ RunTime:0.020209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19617144 ORDER BY `minOrder` ASC [ RunTime:0.008203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19617144 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19617144 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19617144 ORDER BY `minOrder` ASC [ RunTime:0.005015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17495566 LIMIT 5 [ RunTime:0.010032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17495566 ORDER BY `minOrder` ASC [ RunTime:0.011240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17495566 ORDER BY `unit` DESC [ RunTime:0.005240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17495566 LIMIT 2 [ RunTime:0.006974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17495566 ORDER BY `minOrder` ASC [ RunTime:0.003116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17305687 LIMIT 5 [ RunTime:0.018801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17305687 ORDER BY `minOrder` ASC [ RunTime:0.002144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17305687 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17305687 LIMIT 2 [ RunTime:0.007141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17305687 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17157913 LIMIT 5 [ RunTime:0.001131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17157913 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17157913 ORDER BY `unit` DESC [ RunTime:0.000963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17157913 LIMIT 2 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17157913 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15445875 LIMIT 5 [ RunTime:0.002386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15445875 ORDER BY `minOrder` ASC [ RunTime:0.004917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15445875 ORDER BY `unit` DESC [ RunTime:0.001300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15445875 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15445875 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687919 LIMIT 5 [ RunTime:0.001587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687919 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14687919 ORDER BY `unit` DESC [ RunTime:0.002784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14687919 LIMIT 2 [ RunTime:0.002264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687919 ORDER BY `minOrder` ASC [ RunTime:0.003928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14679378 LIMIT 5 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14679378 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14679378 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14679378 LIMIT 2 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14679378 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377829 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377829 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377829 ORDER BY `unit` DESC [ RunTime:0.001346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377829 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377829 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12263363 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263363 ORDER BY `minOrder` ASC [ RunTime:0.004752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12263363 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12263363 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263363 ORDER BY `minOrder` ASC [ RunTime:0.000204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12263324 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263324 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12263324 ORDER BY `unit` DESC [ RunTime:0.004819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12263324 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12263324 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086217 LIMIT 5 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086217 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086217 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086217 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086217 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='1401831' and brandshort='phoenix contact' limit 1 [ RunTime:0.004544s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401831' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007891s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60621688 LIMIT 5 [ RunTime:0.006941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60621688 ORDER BY `minOrder` ASC [ RunTime:0.004089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60621688 ORDER BY `unit` DESC [ RunTime:0.001183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60621688 LIMIT 2 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60621688 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='1401802:0021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622342 LIMIT 5 [ RunTime:0.002782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622342 ORDER BY `minOrder` ASC [ RunTime:0.001755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622342 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622342 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622342 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='1401802:0041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622343 LIMIT 5 [ RunTime:0.002267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622343 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622343 ORDER BY `unit` DESC [ RunTime:0.006147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622343 LIMIT 2 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622343 ORDER BY `minOrder` ASC [ RunTime:0.002663s ]
select * from pdf where partno='1401802:0011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622709 LIMIT 5 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622709 ORDER BY `minOrder` ASC [ RunTime:0.004031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622709 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622709 LIMIT 2 [ RunTime:0.008700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622709 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='1401802:0061' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0061' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622344 LIMIT 5 [ RunTime:0.001891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622344 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622344 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622344 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622344 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='1401802:0051' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0051' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625118 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625118 ORDER BY `minOrder` ASC [ RunTime:0.001054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625118 ORDER BY `unit` DESC [ RunTime:0.010370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625118 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625118 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='1401828:0021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401828:0021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625119 LIMIT 5 [ RunTime:0.003978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625119 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625119 ORDER BY `unit` DESC [ RunTime:0.006009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625119 LIMIT 2 [ RunTime:0.001513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625119 ORDER BY `minOrder` ASC [ RunTime:0.003225s ]
select * from pdf where partno='1401828:0011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401828:0011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62142389 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62142389 ORDER BY `minOrder` ASC [ RunTime:0.001364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62142389 ORDER BY `unit` DESC [ RunTime:0.001654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62142389 LIMIT 2 [ RunTime:0.003379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62142389 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='1401803' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401803' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622345 LIMIT 5 [ RunTime:0.003346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622345 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622345 ORDER BY `unit` DESC [ RunTime:0.001476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622345 LIMIT 2 [ RunTime:0.001291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622345 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='1401802:0031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401802:0031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419522 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419522 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419522 ORDER BY `unit` DESC [ RunTime:0.001294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419522 LIMIT 2 [ RunTime:0.001587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419522 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='1401806113KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.001711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401806113KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000531s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419522 AND `partno` = '1401806113KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071926 [ RunTime:0.001324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419133 LIMIT 5 [ RunTime:0.003219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419133 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419133 ORDER BY `unit` DESC [ RunTime:0.001021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419133 LIMIT 2 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419133 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1401810012KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.001179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401810012KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000569s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419133 AND `partno` = '1401810012KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071777 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419127 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419127 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419127 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419127 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419127 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='1401845512KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.003020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401845512KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419127 AND `partno` = '1401845512KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354058 [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63414025 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414025 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63414025 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63414025 LIMIT 2 [ RunTime:0.001535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414025 ORDER BY `minOrder` ASC [ RunTime:0.002255s ]
select * from pdf where partno='14018' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14018' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63020563 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63020563 ORDER BY `minOrder` ASC [ RunTime:0.003139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63020563 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63020563 LIMIT 2 [ RunTime:0.003164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63020563 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='1401819' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401819' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62192747 LIMIT 5 [ RunTime:0.003664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192747 ORDER BY `minOrder` ASC [ RunTime:0.010136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62192747 ORDER BY `unit` DESC [ RunTime:0.000950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62192747 LIMIT 2 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192747 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='1401825' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401825' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62140896 LIMIT 5 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140896 ORDER BY `minOrder` ASC [ RunTime:0.001065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62140896 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62140896 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140896 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='1401852' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401852' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62138948 LIMIT 5 [ RunTime:0.003655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138948 ORDER BY `minOrder` ASC [ RunTime:0.005471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62138948 ORDER BY `unit` DESC [ RunTime:0.001823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62138948 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138948 ORDER BY `minOrder` ASC [ RunTime:0.003378s ]
select * from pdf where partno='1401814' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401814' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62130715 LIMIT 5 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130715 ORDER BY `minOrder` ASC [ RunTime:0.002773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62130715 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62130715 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130715 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='1401846' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401846' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60626136 LIMIT 5 [ RunTime:0.001418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60626136 ORDER BY `minOrder` ASC [ RunTime:0.001748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60626136 ORDER BY `unit` DESC [ RunTime:0.004358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60626136 LIMIT 2 [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60626136 ORDER BY `minOrder` ASC [ RunTime:0.003300s ]
select * from pdf where partno='1401828:0001' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401828:0001' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625585 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625585 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625585 ORDER BY `unit` DESC [ RunTime:0.001154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625585 LIMIT 2 [ RunTime:0.008075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625585 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
select * from pdf where partno='1401828:0081' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401828:0081' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003059s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000783s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000610s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003144s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000727s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001047s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003528s ]
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 '14018%' OR `brand` LIKE '14018%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001768s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14018%' OR `brand` LIKE '14018%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001620s ]