SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002642s ]
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=LPS62&search=1' [ RunTime:0.001818s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001571s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006721s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001322s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.011268s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002481s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012471s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001033s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LPS62' LIMIT 1 [ RunTime:0.016617s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-14 06:49:20' WHERE `partno` = 'LPS62' [ RunTime:0.005643s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001571s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015184s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419335 LIMIT 5 [ RunTime:0.012826s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419335 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419335 ORDER BY `unit` DESC [ RunTime:0.015033s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419335 LIMIT 2 [ RunTime:0.025465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419335 ORDER BY `minOrder` ASC [ RunTime:0.010787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419164 LIMIT 5 [ RunTime:0.016920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419164 ORDER BY `minOrder` ASC [ RunTime:0.010104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419164 ORDER BY `unit` DESC [ RunTime:0.000361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419164 LIMIT 2 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419164 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419166 LIMIT 5 [ RunTime:0.008178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419166 ORDER BY `minOrder` ASC [ RunTime:0.005938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419166 ORDER BY `unit` DESC [ RunTime:0.005901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419166 LIMIT 2 [ RunTime:0.006290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419166 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312364 LIMIT 5 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312364 ORDER BY `minOrder` ASC [ RunTime:0.001797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14312364 ORDER BY `unit` DESC [ RunTime:0.002241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14312364 LIMIT 2 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312364 ORDER BY `minOrder` ASC [ RunTime:0.002317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419172 LIMIT 5 [ RunTime:0.014134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419172 ORDER BY `minOrder` ASC [ RunTime:0.008635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419172 ORDER BY `unit` DESC [ RunTime:0.004585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419172 LIMIT 2 [ RunTime:0.017605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419172 ORDER BY `minOrder` ASC [ RunTime:0.003016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419336 LIMIT 5 [ RunTime:0.001551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419336 ORDER BY `minOrder` ASC [ RunTime:0.008323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419336 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419336 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419336 ORDER BY `minOrder` ASC [ RunTime:0.002978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312367 LIMIT 5 [ RunTime:0.006613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312367 ORDER BY `minOrder` ASC [ RunTime:0.003928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14312367 ORDER BY `unit` DESC [ RunTime:0.002872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14312367 LIMIT 2 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312367 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312371 LIMIT 5 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312371 ORDER BY `minOrder` ASC [ RunTime:0.003967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14312371 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14312371 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14312371 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419176 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419176 ORDER BY `minOrder` ASC [ RunTime:0.003103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419176 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419176 LIMIT 2 [ RunTime:0.003088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419176 ORDER BY `minOrder` ASC [ RunTime:0.003906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419337 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419337 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419337 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419337 LIMIT 2 [ RunTime:0.002410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419337 ORDER BY `minOrder` ASC [ RunTime:0.003296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419178 LIMIT 5 [ RunTime:0.009774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419178 ORDER BY `minOrder` ASC [ RunTime:0.002442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419178 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419178 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419178 ORDER BY `minOrder` ASC [ RunTime:0.001715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419179 LIMIT 5 [ RunTime:0.002384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419179 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419179 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419179 LIMIT 2 [ RunTime:0.002510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419179 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419182 LIMIT 5 [ RunTime:0.005009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419182 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419182 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419182 LIMIT 2 [ RunTime:0.003172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419182 ORDER BY `minOrder` ASC [ RunTime:0.005859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419181 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419181 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419181 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419181 LIMIT 2 [ RunTime:0.009304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419181 ORDER BY `minOrder` ASC [ RunTime:0.005950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419177 LIMIT 5 [ RunTime:0.005256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419177 ORDER BY `minOrder` ASC [ RunTime:0.002356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419177 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419177 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419177 ORDER BY `minOrder` ASC [ RunTime:0.002246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419338 LIMIT 5 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419338 ORDER BY `minOrder` ASC [ RunTime:0.014668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419338 ORDER BY `unit` DESC [ RunTime:0.005871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419338 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419338 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419339 LIMIT 5 [ RunTime:0.001180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419339 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419339 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419339 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419339 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419190 LIMIT 5 [ RunTime:0.003036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419190 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419190 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419190 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419190 ORDER BY `minOrder` ASC [ RunTime:0.004560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14313591 LIMIT 5 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14313591 ORDER BY `minOrder` ASC [ RunTime:0.003359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14313591 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14313591 LIMIT 2 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14313591 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419197 LIMIT 5 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419197 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13419197 ORDER BY `unit` DESC [ RunTime:0.001885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13419197 LIMIT 2 [ RunTime:0.001019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13419197 ORDER BY `minOrder` ASC [ RunTime:0.006289s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001949s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486779 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486779 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486779 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486779 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486779 ORDER BY `minOrder` ASC [ RunTime:0.004883s ]
select * from pdf where partno='LPS6235-104MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000880s ]
select foldpath,foldpath2,filename from pdf_file where id=876689 limit 1 [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-104MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000593s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486779 AND `partno` = 'LPS6235-104MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419172 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486783 LIMIT 5 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486783 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486783 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486783 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486783 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='LPS6235-183MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-183MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000420s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486783 AND `partno` = 'LPS6235-183MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312376 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487051 LIMIT 5 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487051 ORDER BY `minOrder` ASC [ RunTime:0.005504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487051 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487051 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487051 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='LPS6225-153MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-153MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487051 AND `partno` = 'LPS6225-153MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13420983 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486790 LIMIT 5 [ RunTime:0.003867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486790 ORDER BY `minOrder` ASC [ RunTime:0.030691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486790 ORDER BY `unit` DESC [ RunTime:0.006398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486790 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486790 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
select * from pdf where partno='LPS6235-563MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-563MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486790 AND `partno` = 'LPS6235-563MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419177 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486791 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486791 ORDER BY `minOrder` ASC [ RunTime:0.004269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486791 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486791 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486791 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
select * from pdf where partno='LPS6235-106MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-106MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486791 AND `partno` = 'LPS6235-106MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419182 [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486793 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486793 ORDER BY `minOrder` ASC [ RunTime:0.004895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486793 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486793 LIMIT 2 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486793 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
select * from pdf where partno='LPS6235-105MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.001129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-105MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000421s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486793 AND `partno` = 'LPS6235-105MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312367 [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486794 LIMIT 5 [ RunTime:0.001583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486794 ORDER BY `minOrder` ASC [ RunTime:0.003769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486794 ORDER BY `unit` DESC [ RunTime:0.001614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486794 LIMIT 2 [ RunTime:0.007339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486794 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
select * from pdf where partno='LPS6235-684MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.001303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-684MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.007233s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486794 AND `partno` = 'LPS6235-684MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.002444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312371 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486795 LIMIT 5 [ RunTime:0.001154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486795 ORDER BY `minOrder` ASC [ RunTime:0.001061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486795 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486795 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486795 ORDER BY `minOrder` ASC [ RunTime:0.002530s ]
select * from pdf where partno='LPS6235-334MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-334MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000387s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486795 AND `partno` = 'LPS6235-334MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419176 [ RunTime:0.002756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487052 LIMIT 5 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487052 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487052 ORDER BY `unit` DESC [ RunTime:0.007435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487052 LIMIT 2 [ RunTime:0.001900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487052 ORDER BY `minOrder` ASC [ RunTime:0.004149s ]
select * from pdf where partno='LPS6225-333MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-333MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000509s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487052 AND `partno` = 'LPS6225-333MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6976 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419337 [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486803 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486803 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486803 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486803 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486803 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
select * from pdf where partno='LPS6235-103MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000589s ]
select foldpath,foldpath2,filename from pdf_file where id=1522339 limit 1 [ RunTime:0.000434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-103MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486803 AND `partno` = 'LPS6235-103MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419181 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486805 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486805 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486805 ORDER BY `unit` DESC [ RunTime:0.002613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486805 LIMIT 2 [ RunTime:0.001219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486805 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='LPS6235-565MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-565MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000618s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486805 AND `partno` = 'LPS6235-565MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419179 [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486807 LIMIT 5 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486807 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486807 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486807 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486807 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='LPS6235-123MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.008270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-123MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486807 AND `partno` = 'LPS6235-123MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.010458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419190 [ RunTime:0.003028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486810 LIMIT 5 [ RunTime:0.005311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486810 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486810 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486810 LIMIT 2 [ RunTime:0.003636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486810 ORDER BY `minOrder` ASC [ RunTime:0.004222s ]
select * from pdf where partno='LPS6235-475MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.002433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-475MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000332s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486810 AND `partno` = 'LPS6235-475MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.001840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419178 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486811 LIMIT 5 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486811 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486811 ORDER BY `unit` DESC [ RunTime:0.000904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486811 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486811 ORDER BY `minOrder` ASC [ RunTime:0.002572s ]
select * from pdf where partno='LPS6235-683MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-683MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486811 AND `partno` = 'LPS6235-683MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6978 [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419166 [ RunTime:0.000285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487053 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487053 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487053 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487053 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487053 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='LPS6225-106MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-106MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000295s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487053 AND `partno` = 'LPS6225-106MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419336 [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487054 LIMIT 5 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487054 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487054 ORDER BY `unit` DESC [ RunTime:0.001502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487054 LIMIT 2 [ RunTime:0.001694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487054 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='LPS6225-103MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-103MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487054 AND `partno` = 'LPS6225-103MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.005938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419340 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40486813 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486813 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40486813 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40486813 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40486813 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='LPS6235-333MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.001609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6235-333MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000452s ]
SELECT `id` FROM `stock` WHERE `id` <> 40486813 AND `partno` = 'LPS6235-333MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.002868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419201 [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487055 LIMIT 5 [ RunTime:0.009621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487055 ORDER BY `minOrder` ASC [ RunTime:0.002282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487055 ORDER BY `unit` DESC [ RunTime:0.008975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487055 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487055 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='LPS6225-224MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000340s ]
select foldpath,foldpath2,filename from pdf_file where id=1525031 limit 1 [ RunTime:0.000232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-224MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000302s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487055 AND `partno` = 'LPS6225-224MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14313593 [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487056 LIMIT 5 [ RunTime:0.004962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487056 ORDER BY `minOrder` ASC [ RunTime:0.013238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487056 ORDER BY `unit` DESC [ RunTime:0.003900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487056 LIMIT 2 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487056 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
select * from pdf where partno='LPS6225-105MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.000342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-105MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000293s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487056 AND `partno` = 'LPS6225-105MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419342 [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487057 LIMIT 5 [ RunTime:0.006319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487057 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487057 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487057 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487057 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='LPS6225-222MRC' and brandshort='Coilcraft' limit 1 [ RunTime:0.006769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPS6225-222MRC' OR `brand` LIKE 'Coilcraft%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487057 AND `partno` = 'LPS6225-222MRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419344 [ RunTime:0.000218s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009207s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007557s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016916s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003952s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005011s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004373s ]
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 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025404s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LPS62%' OR `brand` LIKE 'LPS62%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022898s ]