SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001400s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=20855&search=1' [ RunTime:0.002593s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001648s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002139s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001894s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001602s ]
SELECT * FROM `stock_search` WHERE `partno` = '20855' LIMIT 1 [ RunTime:0.012236s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-30 09:01:05' WHERE `partno` = '20855' [ RunTime:0.004584s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001490s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028580s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237846 LIMIT 5 [ RunTime:0.010277s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237846 ORDER BY `minOrder` ASC [ RunTime:0.017189s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237846 ORDER BY `unit` DESC [ RunTime:0.008265s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237846 LIMIT 2 [ RunTime:0.006926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237846 ORDER BY `minOrder` ASC [ RunTime:0.001627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987135 LIMIT 5 [ RunTime:0.014144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987135 ORDER BY `minOrder` ASC [ RunTime:0.031557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987135 ORDER BY `unit` DESC [ RunTime:0.021954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987135 LIMIT 2 [ RunTime:0.012223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987135 ORDER BY `minOrder` ASC [ RunTime:0.040552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577098 LIMIT 5 [ RunTime:0.024861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577098 ORDER BY `minOrder` ASC [ RunTime:0.039096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577098 ORDER BY `unit` DESC [ RunTime:0.021984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577098 LIMIT 2 [ RunTime:0.021399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577098 ORDER BY `minOrder` ASC [ RunTime:0.023148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013789 LIMIT 5 [ RunTime:0.048438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013789 ORDER BY `minOrder` ASC [ RunTime:0.027448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013789 ORDER BY `unit` DESC [ RunTime:0.060957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013789 LIMIT 2 [ RunTime:0.015825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013789 ORDER BY `minOrder` ASC [ RunTime:0.028269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546624 LIMIT 5 [ RunTime:0.062923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546624 ORDER BY `minOrder` ASC [ RunTime:0.042787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13546624 ORDER BY `unit` DESC [ RunTime:0.032135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13546624 LIMIT 2 [ RunTime:0.025043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546624 ORDER BY `minOrder` ASC [ RunTime:0.033206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13298984 LIMIT 5 [ RunTime:0.023147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298984 ORDER BY `minOrder` ASC [ RunTime:0.051388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13298984 ORDER BY `unit` DESC [ RunTime:0.045799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13298984 LIMIT 2 [ RunTime:0.029643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298984 ORDER BY `minOrder` ASC [ RunTime:0.028036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13296801 LIMIT 5 [ RunTime:0.050897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296801 ORDER BY `minOrder` ASC [ RunTime:0.015929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13296801 ORDER BY `unit` DESC [ RunTime:0.052860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13296801 LIMIT 2 [ RunTime:0.061882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296801 ORDER BY `minOrder` ASC [ RunTime:0.027385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293807 LIMIT 5 [ RunTime:0.016665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293807 ORDER BY `minOrder` ASC [ RunTime:0.050038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293807 ORDER BY `unit` DESC [ RunTime:0.026071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293807 LIMIT 2 [ RunTime:0.006269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293807 ORDER BY `minOrder` ASC [ RunTime:0.024563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293806 LIMIT 5 [ RunTime:0.010302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293806 ORDER BY `minOrder` ASC [ RunTime:0.040108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293806 ORDER BY `unit` DESC [ RunTime:0.010213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293806 LIMIT 2 [ RunTime:0.020678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293806 ORDER BY `minOrder` ASC [ RunTime:0.002259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293045 LIMIT 5 [ RunTime:0.007404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293045 ORDER BY `minOrder` ASC [ RunTime:0.022933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293045 ORDER BY `unit` DESC [ RunTime:0.005731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293045 LIMIT 2 [ RunTime:0.013870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293045 ORDER BY `minOrder` ASC [ RunTime:0.007207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026015 LIMIT 5 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026015 ORDER BY `minOrder` ASC [ RunTime:0.002489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026015 ORDER BY `unit` DESC [ RunTime:0.003952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026015 LIMIT 2 [ RunTime:0.010708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026015 ORDER BY `minOrder` ASC [ RunTime:0.015053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11913720 LIMIT 5 [ RunTime:0.010552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11913720 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11913720 ORDER BY `unit` DESC [ RunTime:0.011790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11913720 LIMIT 2 [ RunTime:0.013229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11913720 ORDER BY `minOrder` ASC [ RunTime:0.005908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11912996 LIMIT 5 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11912996 ORDER BY `minOrder` ASC [ RunTime:0.011336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11912996 ORDER BY `unit` DESC [ RunTime:0.012535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11912996 LIMIT 2 [ RunTime:0.018338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11912996 ORDER BY `minOrder` ASC [ RunTime:0.018127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206111 LIMIT 5 [ RunTime:0.041301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206111 ORDER BY `minOrder` ASC [ RunTime:0.019253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206111 ORDER BY `unit` DESC [ RunTime:0.041867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206111 LIMIT 2 [ RunTime:0.011861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206111 ORDER BY `minOrder` ASC [ RunTime:0.014221s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014452s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212652 LIMIT 5 [ RunTime:0.011234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212652 ORDER BY `minOrder` ASC [ RunTime:0.015558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212652 ORDER BY `unit` DESC [ RunTime:0.014764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212652 LIMIT 2 [ RunTime:0.021075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212652 ORDER BY `minOrder` ASC [ RunTime:0.006957s ]
select * from pdf where partno='2085553' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019975s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085553' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028794s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212652 AND `partno` = '2085553' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237846 [ RunTime:0.001672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64229716 LIMIT 5 [ RunTime:0.006911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64229716 ORDER BY `minOrder` ASC [ RunTime:0.023187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64229716 ORDER BY `unit` DESC [ RunTime:0.014196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64229716 LIMIT 2 [ RunTime:0.020879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64229716 ORDER BY `minOrder` ASC [ RunTime:0.010335s ]
select * from pdf where partno='20855' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.012252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20855' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.004890s ]
SELECT `id` FROM `stock` WHERE `id` <> 64229716 AND `partno` = '20855' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.006817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987135 [ RunTime:0.021856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64459684 LIMIT 5 [ RunTime:0.014982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459684 ORDER BY `minOrder` ASC [ RunTime:0.022955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64459684 ORDER BY `unit` DESC [ RunTime:0.016485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64459684 LIMIT 2 [ RunTime:0.015805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459684 ORDER BY `minOrder` ASC [ RunTime:0.019782s ]
select * from pdf where partno='2085546' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085546' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009379s ]
SELECT `id` FROM `stock` WHERE `id` <> 64459684 AND `partno` = '2085546' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.034639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206111 [ RunTime:0.035974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64459160 LIMIT 5 [ RunTime:0.041582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459160 ORDER BY `minOrder` ASC [ RunTime:0.058312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64459160 ORDER BY `unit` DESC [ RunTime:0.017136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64459160 LIMIT 2 [ RunTime:0.021669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459160 ORDER BY `minOrder` ASC [ RunTime:0.035644s ]
select * from pdf where partno='2085551' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.034177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085551' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020934s ]
SELECT `id` FROM `stock` WHERE `id` <> 64459160 AND `partno` = '2085551' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013789 [ RunTime:0.027563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63144813 LIMIT 5 [ RunTime:0.005565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63144813 ORDER BY `minOrder` ASC [ RunTime:0.045883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63144813 ORDER BY `unit` DESC [ RunTime:0.013991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63144813 LIMIT 2 [ RunTime:0.025473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63144813 ORDER BY `minOrder` ASC [ RunTime:0.020183s ]
select * from pdf where partno='20855.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.024143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20855.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.014412s ]
SELECT `id` FROM `stock` WHERE `id` <> 63144813 AND `partno` = '20855.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.020738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546624 [ RunTime:0.014979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60296012 LIMIT 5 [ RunTime:0.014417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60296012 ORDER BY `minOrder` ASC [ RunTime:0.018250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60296012 ORDER BY `unit` DESC [ RunTime:0.011028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60296012 LIMIT 2 [ RunTime:0.010632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60296012 ORDER BY `minOrder` ASC [ RunTime:0.006873s ]
select * from pdf where partno='208550-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '208550-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.025543s ]
SELECT `id` FROM `stock` WHERE `id` <> 60296012 AND `partno` = '208550-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.043554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11913720 [ RunTime:0.005388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60289965 LIMIT 5 [ RunTime:0.022656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60289965 ORDER BY `minOrder` ASC [ RunTime:0.025003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60289965 ORDER BY `unit` DESC [ RunTime:0.001445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60289965 LIMIT 2 [ RunTime:0.022089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60289965 ORDER BY `minOrder` ASC [ RunTime:0.013515s ]
select * from pdf where partno='208552-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.022868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '208552-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.048122s ]
SELECT `id` FROM `stock` WHERE `id` <> 60289965 AND `partno` = '208552-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.037670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32708273 LIMIT 5 [ RunTime:0.053418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32708273 ORDER BY `minOrder` ASC [ RunTime:0.033733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32708273 ORDER BY `unit` DESC [ RunTime:0.010436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32708273 LIMIT 2 [ RunTime:0.027732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32708273 ORDER BY `minOrder` ASC [ RunTime:0.017832s ]
select * from pdf where partno='2085598' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085598' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040714s ]
SELECT `id` FROM `stock` WHERE `id` <> 32708273 AND `partno` = '2085598' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13296801 [ RunTime:0.021588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32654305 LIMIT 5 [ RunTime:0.043140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654305 ORDER BY `minOrder` ASC [ RunTime:0.011542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32654305 ORDER BY `unit` DESC [ RunTime:0.023153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32654305 LIMIT 2 [ RunTime:0.036064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654305 ORDER BY `minOrder` ASC [ RunTime:0.028943s ]
select * from pdf where partno='2085504' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.061198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085504' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.044940s ]
SELECT `id` FROM `stock` WHERE `id` <> 32654305 AND `partno` = '2085504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.052948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293807 [ RunTime:0.039168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32654304 LIMIT 5 [ RunTime:0.014876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654304 ORDER BY `minOrder` ASC [ RunTime:0.024741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32654304 ORDER BY `unit` DESC [ RunTime:0.023910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32654304 LIMIT 2 [ RunTime:0.036822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654304 ORDER BY `minOrder` ASC [ RunTime:0.040479s ]
select * from pdf where partno='2085503' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085503' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.042963s ]
SELECT `id` FROM `stock` WHERE `id` <> 32654304 AND `partno` = '2085503' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.049427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293806 [ RunTime:0.033115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32646179 LIMIT 5 [ RunTime:0.026308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646179 ORDER BY `minOrder` ASC [ RunTime:0.046603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32646179 ORDER BY `unit` DESC [ RunTime:0.094058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32646179 LIMIT 2 [ RunTime:0.075680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646179 ORDER BY `minOrder` ASC [ RunTime:0.032909s ]
select * from pdf where partno='2085502' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085502' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026815s ]
SELECT `id` FROM `stock` WHERE `id` <> 32646179 AND `partno` = '2085502' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026015 [ RunTime:0.045339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32646178 LIMIT 5 [ RunTime:0.001068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646178 ORDER BY `minOrder` ASC [ RunTime:0.019548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32646178 ORDER BY `unit` DESC [ RunTime:0.007871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32646178 LIMIT 2 [ RunTime:0.012613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646178 ORDER BY `minOrder` ASC [ RunTime:0.023739s ]
select * from pdf where partno='2085501' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2085501' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030238s ]
SELECT `id` FROM `stock` WHERE `id` <> 32646178 AND `partno` = '2085501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293045 [ RunTime:0.027487s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013527s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052133s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027354s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008850s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025349s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035492s ]
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 '20855%' OR `brand` LIKE '20855%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032730s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20855%' OR `brand` LIKE '20855%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031212s ]