SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001330s ]
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=10971&search=1' [ RunTime:0.003306s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001137s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001396s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001306s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.001816s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001081s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001451s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001759s ]
SELECT * FROM `stock_search` WHERE `partno` = '10971' LIMIT 1 [ RunTime:0.012786s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 02:13:02' WHERE `partno` = '10971' [ RunTime:0.004949s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001957s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009406s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784295 LIMIT 5 [ RunTime:0.006641s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784295 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784295 ORDER BY `unit` DESC [ RunTime:0.010407s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784295 LIMIT 2 [ RunTime:0.012841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784295 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406033 LIMIT 5 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406033 ORDER BY `minOrder` ASC [ RunTime:0.010147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406033 ORDER BY `unit` DESC [ RunTime:0.026566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406033 LIMIT 2 [ RunTime:0.007499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406033 ORDER BY `minOrder` ASC [ RunTime:0.012406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12405986 LIMIT 5 [ RunTime:0.013340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12405986 ORDER BY `minOrder` ASC [ RunTime:0.017764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12405986 ORDER BY `unit` DESC [ RunTime:0.012443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12405986 LIMIT 2 [ RunTime:0.011247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12405986 ORDER BY `minOrder` ASC [ RunTime:0.008171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981138 LIMIT 5 [ RunTime:0.017655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981138 ORDER BY `minOrder` ASC [ RunTime:0.017253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981138 ORDER BY `unit` DESC [ RunTime:0.021381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981138 LIMIT 2 [ RunTime:0.025500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981138 ORDER BY `minOrder` ASC [ RunTime:0.008570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974350 LIMIT 5 [ RunTime:0.010875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974350 ORDER BY `minOrder` ASC [ RunTime:0.011020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974350 ORDER BY `unit` DESC [ RunTime:0.028525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974350 LIMIT 2 [ RunTime:0.021700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974350 ORDER BY `minOrder` ASC [ RunTime:0.016772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786103 LIMIT 5 [ RunTime:0.039734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786103 ORDER BY `minOrder` ASC [ RunTime:0.038880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786103 ORDER BY `unit` DESC [ RunTime:0.082765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786103 LIMIT 2 [ RunTime:0.042890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786103 ORDER BY `minOrder` ASC [ RunTime:0.014972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775590 LIMIT 5 [ RunTime:0.054509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775590 ORDER BY `minOrder` ASC [ RunTime:0.029077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775590 ORDER BY `unit` DESC [ RunTime:0.057142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775590 LIMIT 2 [ RunTime:0.050149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775590 ORDER BY `minOrder` ASC [ RunTime:0.019736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774373 LIMIT 5 [ RunTime:0.046753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774373 ORDER BY `minOrder` ASC [ RunTime:0.046108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774373 ORDER BY `unit` DESC [ RunTime:0.074425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774373 LIMIT 2 [ RunTime:0.035498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774373 ORDER BY `minOrder` ASC [ RunTime:0.016049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772387 LIMIT 5 [ RunTime:0.039656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772387 ORDER BY `minOrder` ASC [ RunTime:0.051199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772387 ORDER BY `unit` DESC [ RunTime:0.018103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772387 LIMIT 2 [ RunTime:0.054562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772387 ORDER BY `minOrder` ASC [ RunTime:0.065992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771903 LIMIT 5 [ RunTime:0.081701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771903 ORDER BY `minOrder` ASC [ RunTime:0.021161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771903 ORDER BY `unit` DESC [ RunTime:0.063822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771903 LIMIT 2 [ RunTime:0.016214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771903 ORDER BY `minOrder` ASC [ RunTime:0.012527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615048 LIMIT 5 [ RunTime:0.028553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615048 ORDER BY `minOrder` ASC [ RunTime:0.019742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16615048 ORDER BY `unit` DESC [ RunTime:0.067042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16615048 LIMIT 2 [ RunTime:0.019867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615048 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225296 LIMIT 5 [ RunTime:0.025827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225296 ORDER BY `minOrder` ASC [ RunTime:0.022684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225296 ORDER BY `unit` DESC [ RunTime:0.048591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225296 LIMIT 2 [ RunTime:0.033582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225296 ORDER BY `minOrder` ASC [ RunTime:0.019255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223084 LIMIT 5 [ RunTime:0.036478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223084 ORDER BY `minOrder` ASC [ RunTime:0.030317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223084 ORDER BY `unit` DESC [ RunTime:0.020885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223084 LIMIT 2 [ RunTime:0.018540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223084 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406218 LIMIT 5 [ RunTime:0.019440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406218 ORDER BY `minOrder` ASC [ RunTime:0.038265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406218 ORDER BY `unit` DESC [ RunTime:0.046693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406218 LIMIT 2 [ RunTime:0.004157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406218 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030162 LIMIT 5 [ RunTime:0.033631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030162 ORDER BY `minOrder` ASC [ RunTime:0.048050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12030162 ORDER BY `unit` DESC [ RunTime:0.029512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12030162 LIMIT 2 [ RunTime:0.050396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030162 ORDER BY `minOrder` ASC [ RunTime:0.013874s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019225s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335224 LIMIT 5 [ RunTime:0.025367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335224 ORDER BY `minOrder` ASC [ RunTime:0.044541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335224 ORDER BY `unit` DESC [ RunTime:0.011423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335224 LIMIT 2 [ RunTime:0.028650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335224 ORDER BY `minOrder` ASC [ RunTime:0.018159s ]
select * from pdf where partno='1097190' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035108s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097190' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038937s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335224 AND `partno` = '1097190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784295 [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64818604 LIMIT 5 [ RunTime:0.034786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818604 ORDER BY `minOrder` ASC [ RunTime:0.009978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64818604 ORDER BY `unit` DESC [ RunTime:0.005340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64818604 LIMIT 2 [ RunTime:0.033739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818604 ORDER BY `minOrder` ASC [ RunTime:0.015233s ]
select * from pdf where partno='109712-HMC594LC3B' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.013897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109712-HMC594LC3B' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.006348s ]
SELECT `id` FROM `stock` WHERE `id` <> 64818604 AND `partno` = '109712-HMC594LC3B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.044048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406033 [ RunTime:0.028164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64818521 LIMIT 5 [ RunTime:0.037246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818521 ORDER BY `minOrder` ASC [ RunTime:0.014660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64818521 ORDER BY `unit` DESC [ RunTime:0.046112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64818521 LIMIT 2 [ RunTime:0.008191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818521 ORDER BY `minOrder` ASC [ RunTime:0.012812s ]
select * from pdf where partno='109712-HMC441LC3B' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.030948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109712-HMC441LC3B' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.052580s ]
SELECT `id` FROM `stock` WHERE `id` <> 64818521 AND `partno` = '109712-HMC441LC3B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.076776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12405986 [ RunTime:0.028894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64820310 LIMIT 5 [ RunTime:0.031748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64820310 ORDER BY `minOrder` ASC [ RunTime:0.033974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64820310 ORDER BY `unit` DESC [ RunTime:0.041717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64820310 LIMIT 2 [ RunTime:0.082287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64820310 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
select * from pdf where partno='109712-HMC442LC3B' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.042611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109712-HMC442LC3B' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.021319s ]
SELECT `id` FROM `stock` WHERE `id` <> 64820310 AND `partno` = '109712-HMC442LC3B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.010452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406218 [ RunTime:0.015049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807684 LIMIT 5 [ RunTime:0.027864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807684 ORDER BY `minOrder` ASC [ RunTime:0.052098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807684 ORDER BY `unit` DESC [ RunTime:0.043161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807684 LIMIT 2 [ RunTime:0.031548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807684 ORDER BY `minOrder` ASC [ RunTime:0.018592s ]
select * from pdf where partno='1097193' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097193' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022609s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807684 AND `partno` = '1097193' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775590 [ RunTime:0.020707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806411 LIMIT 5 [ RunTime:0.017128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806411 ORDER BY `minOrder` ASC [ RunTime:0.020878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806411 ORDER BY `unit` DESC [ RunTime:0.008821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806411 LIMIT 2 [ RunTime:0.040629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806411 ORDER BY `minOrder` ASC [ RunTime:0.067902s ]
select * from pdf where partno='1097185' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097185' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015672s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806411 AND `partno` = '1097185' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774373 [ RunTime:0.022643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804318 LIMIT 5 [ RunTime:0.039263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804318 ORDER BY `minOrder` ASC [ RunTime:0.030128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804318 ORDER BY `unit` DESC [ RunTime:0.005223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804318 LIMIT 2 [ RunTime:0.004675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804318 ORDER BY `minOrder` ASC [ RunTime:0.011252s ]
select * from pdf where partno='1097186' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097186' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011308s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804318 AND `partno` = '1097186' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981138 [ RunTime:0.029862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802966 LIMIT 5 [ RunTime:0.018019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802966 ORDER BY `minOrder` ASC [ RunTime:0.017410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802966 ORDER BY `unit` DESC [ RunTime:0.020262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802966 LIMIT 2 [ RunTime:0.032312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802966 ORDER BY `minOrder` ASC [ RunTime:0.003419s ]
select * from pdf where partno='1097188' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097188' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017660s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802966 AND `partno` = '1097188' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772387 [ RunTime:0.038124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801990 LIMIT 5 [ RunTime:0.009470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801990 ORDER BY `minOrder` ASC [ RunTime:0.018855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801990 ORDER BY `unit` DESC [ RunTime:0.023892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801990 LIMIT 2 [ RunTime:0.005011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801990 ORDER BY `minOrder` ASC [ RunTime:0.008722s ]
select * from pdf where partno='1097100' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097100' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020934s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801990 AND `partno` = '1097100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771903 [ RunTime:0.025857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800796 LIMIT 5 [ RunTime:0.047165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800796 ORDER BY `minOrder` ASC [ RunTime:0.033212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800796 ORDER BY `unit` DESC [ RunTime:0.049738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800796 LIMIT 2 [ RunTime:0.004560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800796 ORDER BY `minOrder` ASC [ RunTime:0.033096s ]
select * from pdf where partno='1097189' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097189' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.049594s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800796 AND `partno` = '1097189' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223084 [ RunTime:0.023233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381496 LIMIT 5 [ RunTime:0.047334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381496 ORDER BY `minOrder` ASC [ RunTime:0.078173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381496 ORDER BY `unit` DESC [ RunTime:0.039451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381496 LIMIT 2 [ RunTime:0.023725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381496 ORDER BY `minOrder` ASC [ RunTime:0.025311s ]
select * from pdf where partno='10971F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.029674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10971F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.055393s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381496 AND `partno` = '10971F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.049024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380778 LIMIT 5 [ RunTime:0.038266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380778 ORDER BY `minOrder` ASC [ RunTime:0.163966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380778 ORDER BY `unit` DESC [ RunTime:0.114976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380778 LIMIT 2 [ RunTime:0.027431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380778 ORDER BY `minOrder` ASC [ RunTime:0.015896s ]
select * from pdf where partno='10971' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.028714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10971' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.060007s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380778 AND `partno` = '10971' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.043986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63348059 LIMIT 5 [ RunTime:0.058444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348059 ORDER BY `minOrder` ASC [ RunTime:0.036877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63348059 ORDER BY `unit` DESC [ RunTime:0.031749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63348059 LIMIT 2 [ RunTime:0.039798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348059 ORDER BY `minOrder` ASC [ RunTime:0.010220s ]
select * from pdf where partno='1097191' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097191' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034981s ]
SELECT `id` FROM `stock` WHERE `id` <> 63348059 AND `partno` = '1097191' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225296 [ RunTime:0.019059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63339598 LIMIT 5 [ RunTime:0.017457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339598 ORDER BY `minOrder` ASC [ RunTime:0.021885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63339598 ORDER BY `unit` DESC [ RunTime:0.027402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63339598 LIMIT 2 [ RunTime:0.067407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339598 ORDER BY `minOrder` ASC [ RunTime:0.008936s ]
select * from pdf where partno='1097107' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.059438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097107' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024608s ]
SELECT `id` FROM `stock` WHERE `id` <> 63339598 AND `partno` = '1097107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786103 [ RunTime:0.039575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200550 LIMIT 5 [ RunTime:0.028915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200550 ORDER BY `minOrder` ASC [ RunTime:0.095724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200550 ORDER BY `unit` DESC [ RunTime:0.080606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200550 LIMIT 2 [ RunTime:0.052891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200550 ORDER BY `minOrder` ASC [ RunTime:0.040239s ]
select * from pdf where partno='1097192' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1097192' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017592s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200550 AND `partno` = '1097192' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974350 [ RunTime:0.069121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62180176 LIMIT 5 [ RunTime:0.051973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62180176 ORDER BY `minOrder` ASC [ RunTime:0.039246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62180176 ORDER BY `unit` DESC [ RunTime:0.106844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62180176 LIMIT 2 [ RunTime:0.046548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62180176 ORDER BY `minOrder` ASC [ RunTime:0.025961s ]
select * from pdf where partno='10971' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.003160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10971' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.056770s ]
SELECT `id` FROM `stock` WHERE `id` <> 62180176 AND `partno` = '10971' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.016752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615048 [ RunTime:0.021609s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076022s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103912s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047925s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089223s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053106s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035824s ]
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 '10971%' OR `brand` LIKE '10971%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034413s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10971%' OR `brand` LIKE '10971%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028084s ]