SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001445s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=10464&search=1' [ RunTime:0.005918s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001679s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000683s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002937s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.008292s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002152s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005652s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002146s ]
SELECT * FROM `stock_search` WHERE `partno` = '10464' LIMIT 1 [ RunTime:0.009677s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 12:27:14' WHERE `partno` = '10464' [ RunTime:0.020627s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003054s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047115s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190448 LIMIT 5 [ RunTime:0.030628s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190448 ORDER BY `minOrder` ASC [ RunTime:0.038706s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190448 ORDER BY `unit` DESC [ RunTime:0.035905s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190448 LIMIT 2 [ RunTime:0.020579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190448 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190362 LIMIT 5 [ RunTime:0.036829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190362 ORDER BY `minOrder` ASC [ RunTime:0.051350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190362 ORDER BY `unit` DESC [ RunTime:0.021823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190362 LIMIT 2 [ RunTime:0.037020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190362 ORDER BY `minOrder` ASC [ RunTime:0.015042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190361 LIMIT 5 [ RunTime:0.037339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190361 ORDER BY `minOrder` ASC [ RunTime:0.011104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190361 ORDER BY `unit` DESC [ RunTime:0.030090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190361 LIMIT 2 [ RunTime:0.038318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190361 ORDER BY `minOrder` ASC [ RunTime:0.016905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200602 LIMIT 5 [ RunTime:0.023030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200602 ORDER BY `minOrder` ASC [ RunTime:0.055009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200602 ORDER BY `unit` DESC [ RunTime:0.059975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200602 LIMIT 2 [ RunTime:0.033201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200602 ORDER BY `minOrder` ASC [ RunTime:0.001148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784266 LIMIT 5 [ RunTime:0.040284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784266 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784266 ORDER BY `unit` DESC [ RunTime:0.009095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784266 LIMIT 2 [ RunTime:0.010026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784266 ORDER BY `minOrder` ASC [ RunTime:0.008583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792861 LIMIT 5 [ RunTime:0.046454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792861 ORDER BY `minOrder` ASC [ RunTime:0.010276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792861 ORDER BY `unit` DESC [ RunTime:0.016899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792861 LIMIT 2 [ RunTime:0.066390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792861 ORDER BY `minOrder` ASC [ RunTime:0.006924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781930 LIMIT 5 [ RunTime:0.056714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781930 ORDER BY `minOrder` ASC [ RunTime:0.031122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781930 ORDER BY `unit` DESC [ RunTime:0.011088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781930 LIMIT 2 [ RunTime:0.008360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781930 ORDER BY `minOrder` ASC [ RunTime:0.009011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781262 LIMIT 5 [ RunTime:0.006985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781262 ORDER BY `minOrder` ASC [ RunTime:0.020059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781262 ORDER BY `unit` DESC [ RunTime:0.058106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781262 LIMIT 2 [ RunTime:0.042897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781262 ORDER BY `minOrder` ASC [ RunTime:0.027927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781261 LIMIT 5 [ RunTime:0.006777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781261 ORDER BY `minOrder` ASC [ RunTime:0.010286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781261 ORDER BY `unit` DESC [ RunTime:0.050822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781261 LIMIT 2 [ RunTime:0.004865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781261 ORDER BY `minOrder` ASC [ RunTime:0.009090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781260 LIMIT 5 [ RunTime:0.014887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781260 ORDER BY `minOrder` ASC [ RunTime:0.046791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781260 ORDER BY `unit` DESC [ RunTime:0.029638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781260 LIMIT 2 [ RunTime:0.040876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781260 ORDER BY `minOrder` ASC [ RunTime:0.012306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781259 LIMIT 5 [ RunTime:0.009131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781259 ORDER BY `minOrder` ASC [ RunTime:0.034284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781259 ORDER BY `unit` DESC [ RunTime:0.068115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781259 LIMIT 2 [ RunTime:0.028244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781259 ORDER BY `minOrder` ASC [ RunTime:0.043842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781127 LIMIT 5 [ RunTime:0.028382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781127 ORDER BY `minOrder` ASC [ RunTime:0.083476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781127 ORDER BY `unit` DESC [ RunTime:0.034454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781127 LIMIT 2 [ RunTime:0.016310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781127 ORDER BY `minOrder` ASC [ RunTime:0.007785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781126 LIMIT 5 [ RunTime:0.027802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781126 ORDER BY `minOrder` ASC [ RunTime:0.041127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781126 ORDER BY `unit` DESC [ RunTime:0.056174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781126 LIMIT 2 [ RunTime:0.015816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781126 ORDER BY `minOrder` ASC [ RunTime:0.019079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781125 LIMIT 5 [ RunTime:0.014923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781125 ORDER BY `minOrder` ASC [ RunTime:0.028431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781125 ORDER BY `unit` DESC [ RunTime:0.022204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781125 LIMIT 2 [ RunTime:0.050818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781125 ORDER BY `minOrder` ASC [ RunTime:0.004440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781124 LIMIT 5 [ RunTime:0.005807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781124 ORDER BY `minOrder` ASC [ RunTime:0.022772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781124 ORDER BY `unit` DESC [ RunTime:0.018163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781124 LIMIT 2 [ RunTime:0.061769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781124 ORDER BY `minOrder` ASC [ RunTime:0.022239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781123 LIMIT 5 [ RunTime:0.018167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781123 ORDER BY `minOrder` ASC [ RunTime:0.067738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781123 ORDER BY `unit` DESC [ RunTime:0.061451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781123 LIMIT 2 [ RunTime:0.031258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781123 ORDER BY `minOrder` ASC [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779762 LIMIT 5 [ RunTime:0.017358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779762 ORDER BY `minOrder` ASC [ RunTime:0.040909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779762 ORDER BY `unit` DESC [ RunTime:0.028160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779762 LIMIT 2 [ RunTime:0.044962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779762 ORDER BY `minOrder` ASC [ RunTime:0.002185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779761 LIMIT 5 [ RunTime:0.010565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779761 ORDER BY `minOrder` ASC [ RunTime:0.073823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779761 ORDER BY `unit` DESC [ RunTime:0.064040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779761 LIMIT 2 [ RunTime:0.054032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779761 ORDER BY `minOrder` ASC [ RunTime:0.015223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779760 LIMIT 5 [ RunTime:0.044503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779760 ORDER BY `minOrder` ASC [ RunTime:0.026117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779760 ORDER BY `unit` DESC [ RunTime:0.020701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779760 LIMIT 2 [ RunTime:0.034062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779760 ORDER BY `minOrder` ASC [ RunTime:0.039047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779759 LIMIT 5 [ RunTime:0.017120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779759 ORDER BY `minOrder` ASC [ RunTime:0.026269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779759 ORDER BY `unit` DESC [ RunTime:0.035619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779759 LIMIT 2 [ RunTime:0.015834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779759 ORDER BY `minOrder` ASC [ RunTime:0.006677s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036205s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59387145 LIMIT 5 [ RunTime:0.025859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387145 ORDER BY `minOrder` ASC [ RunTime:0.036794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59387145 ORDER BY `unit` DESC [ RunTime:0.011390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59387145 LIMIT 2 [ RunTime:0.049905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387145 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
select * from pdf where partno='1046410000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010390s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046410000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.026835s ]
SELECT `id` FROM `stock` WHERE `id` <> 59387145 AND `partno` = '1046410000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.030717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335182 LIMIT 5 [ RunTime:0.021586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335182 ORDER BY `minOrder` ASC [ RunTime:0.027700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335182 ORDER BY `unit` DESC [ RunTime:0.049122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335182 LIMIT 2 [ RunTime:0.025396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335182 ORDER BY `minOrder` ASC [ RunTime:0.007962s ]
select * from pdf where partno='1046446' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046446' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035878s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335182 AND `partno` = '1046446' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.073106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190448 [ RunTime:0.025203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335100 LIMIT 5 [ RunTime:0.024913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335100 ORDER BY `minOrder` ASC [ RunTime:0.012326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335100 ORDER BY `unit` DESC [ RunTime:0.017885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335100 LIMIT 2 [ RunTime:0.047490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335100 ORDER BY `minOrder` ASC [ RunTime:0.047652s ]
select * from pdf where partno='1046426' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046426' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038911s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335100 AND `partno` = '1046426' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200602 [ RunTime:0.035987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335069 LIMIT 5 [ RunTime:0.019231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335069 ORDER BY `minOrder` ASC [ RunTime:0.043795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335069 ORDER BY `unit` DESC [ RunTime:0.033561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335069 LIMIT 2 [ RunTime:0.052779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335069 ORDER BY `minOrder` ASC [ RunTime:0.018012s ]
select * from pdf where partno='1046421' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046421' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025291s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335069 AND `partno` = '1046421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.053940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190362 [ RunTime:0.009496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63337249 LIMIT 5 [ RunTime:0.081359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337249 ORDER BY `minOrder` ASC [ RunTime:0.041898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63337249 ORDER BY `unit` DESC [ RunTime:0.042296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63337249 LIMIT 2 [ RunTime:0.091263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337249 ORDER BY `minOrder` ASC [ RunTime:0.047571s ]
select * from pdf where partno='1046449' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046449' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.094732s ]
SELECT `id` FROM `stock` WHERE `id` <> 63337249 AND `partno` = '1046449' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.074068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784266 [ RunTime:0.026974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63337164 LIMIT 5 [ RunTime:0.034218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337164 ORDER BY `minOrder` ASC [ RunTime:0.030477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63337164 ORDER BY `unit` DESC [ RunTime:0.047452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63337164 LIMIT 2 [ RunTime:0.034095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337164 ORDER BY `minOrder` ASC [ RunTime:0.020576s ]
select * from pdf where partno='1046415' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046415' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.042147s ]
SELECT `id` FROM `stock` WHERE `id` <> 63337164 AND `partno` = '1046415' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190361 [ RunTime:0.046943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787566 LIMIT 5 [ RunTime:0.045052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787566 ORDER BY `minOrder` ASC [ RunTime:0.005048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787566 ORDER BY `unit` DESC [ RunTime:0.018464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787566 LIMIT 2 [ RunTime:0.012536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787566 ORDER BY `minOrder` ASC [ RunTime:0.005784s ]
select * from pdf where partno='1046451' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046451' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.041195s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787566 AND `partno` = '1046451' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792861 [ RunTime:0.009727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64612158 LIMIT 5 [ RunTime:0.012923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612158 ORDER BY `minOrder` ASC [ RunTime:0.027222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64612158 ORDER BY `unit` DESC [ RunTime:0.018031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64612158 LIMIT 2 [ RunTime:0.029625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612158 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
select * from pdf where partno='1046493' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046493' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027511s ]
SELECT `id` FROM `stock` WHERE `id` <> 64612158 AND `partno` = '1046493' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.048531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014002 [ RunTime:0.010786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381596 LIMIT 5 [ RunTime:0.034503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381596 ORDER BY `minOrder` ASC [ RunTime:0.006817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381596 ORDER BY `unit` DESC [ RunTime:0.034424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381596 LIMIT 2 [ RunTime:0.024020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381596 ORDER BY `minOrder` ASC [ RunTime:0.012898s ]
select * from pdf where partno='10464F-P' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.062642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10464F-P' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.081166s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381596 AND `partno` = '10464F-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.050212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043804 [ RunTime:0.024582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381410 LIMIT 5 [ RunTime:0.097962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381410 ORDER BY `minOrder` ASC [ RunTime:0.046170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381410 ORDER BY `unit` DESC [ RunTime:0.022758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381410 LIMIT 2 [ RunTime:0.033536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381410 ORDER BY `minOrder` ASC [ RunTime:0.025665s ]
select * from pdf where partno='10464F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.041494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10464F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.042272s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381410 AND `partno` = '10464F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.028965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380202 LIMIT 5 [ RunTime:0.003641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380202 ORDER BY `minOrder` ASC [ RunTime:0.013947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380202 ORDER BY `unit` DESC [ RunTime:0.054687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380202 LIMIT 2 [ RunTime:0.014154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380202 ORDER BY `minOrder` ASC [ RunTime:0.016141s ]
select * from pdf where partno='10464' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.023389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10464' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.015540s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380202 AND `partno` = '10464' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347931 LIMIT 5 [ RunTime:0.021486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347931 ORDER BY `minOrder` ASC [ RunTime:0.026995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347931 ORDER BY `unit` DESC [ RunTime:0.057074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347931 LIMIT 2 [ RunTime:0.043097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347931 ORDER BY `minOrder` ASC [ RunTime:0.016531s ]
select * from pdf where partno='1046400' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046400' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006801s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347931 AND `partno` = '1046400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781930 [ RunTime:0.037560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347224 LIMIT 5 [ RunTime:0.015866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347224 ORDER BY `minOrder` ASC [ RunTime:0.014361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347224 ORDER BY `unit` DESC [ RunTime:0.029966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347224 LIMIT 2 [ RunTime:0.038628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347224 ORDER BY `minOrder` ASC [ RunTime:0.006456s ]
select * from pdf where partno='1046410' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.044481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046410' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015291s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347224 AND `partno` = '1046410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011734 [ RunTime:0.037756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346887 LIMIT 5 [ RunTime:0.054643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346887 ORDER BY `minOrder` ASC [ RunTime:0.043540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346887 ORDER BY `unit` DESC [ RunTime:0.022627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346887 LIMIT 2 [ RunTime:0.011701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346887 ORDER BY `minOrder` ASC [ RunTime:0.006655s ]
select * from pdf where partno='1046450' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046450' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025347s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346887 AND `partno` = '1046450' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781262 [ RunTime:0.012438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346886 LIMIT 5 [ RunTime:0.015146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346886 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346886 ORDER BY `unit` DESC [ RunTime:0.014179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346886 LIMIT 2 [ RunTime:0.015311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346886 ORDER BY `minOrder` ASC [ RunTime:0.008044s ]
select * from pdf where partno='1046448' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046448' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018433s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346886 AND `partno` = '1046448' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781261 [ RunTime:0.013957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346885 LIMIT 5 [ RunTime:0.004797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346885 ORDER BY `minOrder` ASC [ RunTime:0.024958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346885 ORDER BY `unit` DESC [ RunTime:0.015505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346885 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346885 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='1046447' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046447' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008436s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346885 AND `partno` = '1046447' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781260 [ RunTime:0.019762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346884 LIMIT 5 [ RunTime:0.013470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346884 ORDER BY `minOrder` ASC [ RunTime:0.029696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346884 ORDER BY `unit` DESC [ RunTime:0.035435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346884 LIMIT 2 [ RunTime:0.036083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346884 ORDER BY `minOrder` ASC [ RunTime:0.007333s ]
select * from pdf where partno='1046438' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046438' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027177s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346884 AND `partno` = '1046438' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781259 [ RunTime:0.036790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346716 LIMIT 5 [ RunTime:0.013968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346716 ORDER BY `minOrder` ASC [ RunTime:0.026264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346716 ORDER BY `unit` DESC [ RunTime:0.011056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346716 LIMIT 2 [ RunTime:0.017108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346716 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
select * from pdf where partno='1046407' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046407' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004561s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346716 AND `partno` = '1046407' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781127 [ RunTime:0.004838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346715 LIMIT 5 [ RunTime:0.010135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346715 ORDER BY `minOrder` ASC [ RunTime:0.011664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346715 ORDER BY `unit` DESC [ RunTime:0.023689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346715 LIMIT 2 [ RunTime:0.022866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346715 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
select * from pdf where partno='1046405' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046405' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010456s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346715 AND `partno` = '1046405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781126 [ RunTime:0.032779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346714 LIMIT 5 [ RunTime:0.016194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346714 ORDER BY `minOrder` ASC [ RunTime:0.016990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346714 ORDER BY `unit` DESC [ RunTime:0.025652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346714 LIMIT 2 [ RunTime:0.011832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346714 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
select * from pdf where partno='1046404' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1046404' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038943s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346714 AND `partno` = '1046404' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.056001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011680 [ RunTime:0.045127s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038021s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069820s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106680s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049584s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046522s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075360s ]
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 '10464%' OR `brand` LIKE '10464%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068746s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10464%' OR `brand` LIKE '10464%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027831s ]