SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002178s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=R0.25D12-3.315&search=1' [ RunTime:0.003972s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002039s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000536s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002354s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002628s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002469s ]
SELECT * FROM `stock_search` WHERE `partno` = 'R0.25D12-3.315' LIMIT 1 [ RunTime:0.002163s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 12:02:21' WHERE `partno` = 'R0.25D12-3.315' [ RunTime:0.010549s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002472s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016224s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16638072 LIMIT 5 [ RunTime:0.007233s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16638072 ORDER BY `minOrder` ASC [ RunTime:0.001134s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16638072 ORDER BY `unit` DESC [ RunTime:0.005163s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16638072 LIMIT 2 [ RunTime:0.003673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16638072 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637961 LIMIT 5 [ RunTime:0.001387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637961 ORDER BY `minOrder` ASC [ RunTime:0.010645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637961 ORDER BY `unit` DESC [ RunTime:0.012913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637961 LIMIT 2 [ RunTime:0.005054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637961 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637960 LIMIT 5 [ RunTime:0.005634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637960 ORDER BY `minOrder` ASC [ RunTime:0.009167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637960 ORDER BY `unit` DESC [ RunTime:0.019504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637960 LIMIT 2 [ RunTime:0.005987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637960 ORDER BY `minOrder` ASC [ RunTime:0.003480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637716 LIMIT 5 [ RunTime:0.011699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637716 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637716 ORDER BY `unit` DESC [ RunTime:0.001527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637716 LIMIT 2 [ RunTime:0.019929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637716 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637344 LIMIT 5 [ RunTime:0.012530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637344 ORDER BY `minOrder` ASC [ RunTime:0.009313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637344 ORDER BY `unit` DESC [ RunTime:0.008324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637344 LIMIT 2 [ RunTime:0.007587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637344 ORDER BY `minOrder` ASC [ RunTime:0.005409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772823 LIMIT 5 [ RunTime:0.004953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772823 ORDER BY `minOrder` ASC [ RunTime:0.003192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772823 ORDER BY `unit` DESC [ RunTime:0.007224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772823 LIMIT 2 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772823 ORDER BY `minOrder` ASC [ RunTime:0.007668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879473 LIMIT 5 [ RunTime:0.011626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879473 ORDER BY `minOrder` ASC [ RunTime:0.009597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13879473 ORDER BY `unit` DESC [ RunTime:0.006675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13879473 LIMIT 2 [ RunTime:0.023745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879473 ORDER BY `minOrder` ASC [ RunTime:0.010172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879317 LIMIT 5 [ RunTime:0.001883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879317 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13879317 ORDER BY `unit` DESC [ RunTime:0.025053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13879317 LIMIT 2 [ RunTime:0.001039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879317 ORDER BY `minOrder` ASC [ RunTime:0.002946s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018557s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57530410 LIMIT 5 [ RunTime:0.002510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57530410 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57530410 ORDER BY `unit` DESC [ RunTime:0.005634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57530410 LIMIT 2 [ RunTime:0.007989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57530410 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
select * from pdf where partno='R0.25D12-3.315/HP' and brandshort='Recom Power' limit 1 [ RunTime:0.009052s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/HP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.008692s ]
SELECT `id` FROM `stock` WHERE `id` <> 57530410 AND `partno` = 'R0.25D12-3.315/HP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.007391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16638072 [ RunTime:0.006147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57530187 LIMIT 5 [ RunTime:0.006816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57530187 ORDER BY `minOrder` ASC [ RunTime:0.008418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57530187 ORDER BY `unit` DESC [ RunTime:0.001097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57530187 LIMIT 2 [ RunTime:0.011539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57530187 ORDER BY `minOrder` ASC [ RunTime:0.006245s ]
select * from pdf where partno='R0.25D12-3.315/HP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.005058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/HP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.001825s ]
SELECT `id` FROM `stock` WHERE `id` <> 57530187 AND `partno` = 'R0.25D12-3.315/HP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.008889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772823 [ RunTime:0.006186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57529183 LIMIT 5 [ RunTime:0.007074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529183 ORDER BY `minOrder` ASC [ RunTime:0.007992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57529183 ORDER BY `unit` DESC [ RunTime:0.010418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57529183 LIMIT 2 [ RunTime:0.004663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529183 ORDER BY `minOrder` ASC [ RunTime:0.005084s ]
select * from pdf where partno='R0.25D12-3.315/P' and brandshort='Recom Power' limit 1 [ RunTime:0.009891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.009687s ]
SELECT `id` FROM `stock` WHERE `id` <> 57529183 AND `partno` = 'R0.25D12-3.315/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.019717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879473 [ RunTime:0.002166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57529182 LIMIT 5 [ RunTime:0.002312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529182 ORDER BY `minOrder` ASC [ RunTime:0.004302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57529182 ORDER BY `unit` DESC [ RunTime:0.001647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57529182 LIMIT 2 [ RunTime:0.002552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529182 ORDER BY `minOrder` ASC [ RunTime:0.007814s ]
select * from pdf where partno='R0.25D12-3.315/H' and brandshort='Recom Power' limit 1 [ RunTime:0.011224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.006756s ]
SELECT `id` FROM `stock` WHERE `id` <> 57529182 AND `partno` = 'R0.25D12-3.315/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.003841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637716 [ RunTime:0.015110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57528891 LIMIT 5 [ RunTime:0.002753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528891 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57528891 ORDER BY `unit` DESC [ RunTime:0.010090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57528891 LIMIT 2 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528891 ORDER BY `minOrder` ASC [ RunTime:0.007673s ]
select * from pdf where partno='R0.25D12-3.315/P-R' and brandshort='Recom Power' limit 1 [ RunTime:0.009069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/P-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.004082s ]
SELECT `id` FROM `stock` WHERE `id` <> 57528891 AND `partno` = 'R0.25D12-3.315/P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.015727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637961 [ RunTime:0.004741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57528877 LIMIT 5 [ RunTime:0.007563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528877 ORDER BY `minOrder` ASC [ RunTime:0.006796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57528877 ORDER BY `unit` DESC [ RunTime:0.002284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57528877 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528877 ORDER BY `minOrder` ASC [ RunTime:0.000934s ]
select * from pdf where partno='R0.25D12-3.315/H-R' and brandshort='Recom Power' limit 1 [ RunTime:0.010128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315/H-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.019146s ]
SELECT `id` FROM `stock` WHERE `id` <> 57528877 AND `partno` = 'R0.25D12-3.315/H-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.007373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637960 [ RunTime:0.010402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57526573 LIMIT 5 [ RunTime:0.008664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526573 ORDER BY `minOrder` ASC [ RunTime:0.018585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57526573 ORDER BY `unit` DESC [ RunTime:0.024292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57526573 LIMIT 2 [ RunTime:0.010851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526573 ORDER BY `minOrder` ASC [ RunTime:0.006545s ]
select * from pdf where partno='R0.25D12-3.315-R' and brandshort='Recom Power' limit 1 [ RunTime:0.016510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.012821s ]
SELECT `id` FROM `stock` WHERE `id` <> 57526573 AND `partno` = 'R0.25D12-3.315-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.026020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879317 [ RunTime:0.006930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50528447 LIMIT 5 [ RunTime:0.008726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50528447 ORDER BY `minOrder` ASC [ RunTime:0.013338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50528447 ORDER BY `unit` DESC [ RunTime:0.012384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50528447 LIMIT 2 [ RunTime:0.012208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50528447 ORDER BY `minOrder` ASC [ RunTime:0.002196s ]
select * from pdf where partno='R0.25D12-3.315' and brandshort='Recom Power' limit 1 [ RunTime:0.018216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.010054s ]
SELECT `id` FROM `stock` WHERE `id` <> 50528447 AND `partno` = 'R0.25D12-3.315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.012445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637344 [ RunTime:0.024698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37754074 LIMIT 5 [ RunTime:0.009403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37754074 ORDER BY `minOrder` ASC [ RunTime:0.007263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37754074 ORDER BY `unit` DESC [ RunTime:0.021553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37754074 LIMIT 2 [ RunTime:0.014591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37754074 ORDER BY `minOrder` ASC [ RunTime:0.007486s ]
select * from pdf where partno='R0.25D12-3.315' and brandshort='Recom Power' limit 1 [ RunTime:0.009296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-3.315' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.030640s ]
SELECT `id` FROM `stock` WHERE `id` <> 37754074 AND `partno` = 'R0.25D12-3.315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.020014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637344 [ RunTime:0.016923s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022057s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024859s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011753s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021513s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010431s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022691s ]
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 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022703s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.25D12-3.315%' OR `brand` LIKE 'R0.25D12-3.315%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025165s ]