SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002630s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=R88M-GP10030T&search=1' [ RunTime:0.010126s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003538s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011279s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002454s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.008070s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002438s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003939s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002312s ]
SELECT * FROM `stock_search` WHERE `partno` = 'R88M-GP10030T' LIMIT 1 [ RunTime:0.028650s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-29 21:30:57' WHERE `partno` = 'R88M-GP10030T' [ RunTime:0.003852s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001374s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027542s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348809 LIMIT 5 [ RunTime:0.020222s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348809 ORDER BY `minOrder` ASC [ RunTime:0.043530s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348809 ORDER BY `unit` DESC [ RunTime:0.043017s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348809 LIMIT 2 [ RunTime:0.058667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348809 ORDER BY `minOrder` ASC [ RunTime:0.013788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348603 LIMIT 5 [ RunTime:0.006147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348603 ORDER BY `minOrder` ASC [ RunTime:0.032280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348603 ORDER BY `unit` DESC [ RunTime:0.033868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348603 LIMIT 2 [ RunTime:0.022881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348603 ORDER BY `minOrder` ASC [ RunTime:0.021948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348602 LIMIT 5 [ RunTime:0.009231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348602 ORDER BY `minOrder` ASC [ RunTime:0.058354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348602 ORDER BY `unit` DESC [ RunTime:0.025060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348602 LIMIT 2 [ RunTime:0.039278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348602 ORDER BY `minOrder` ASC [ RunTime:0.015685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348596 LIMIT 5 [ RunTime:0.012094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348596 ORDER BY `minOrder` ASC [ RunTime:0.061245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348596 ORDER BY `unit` DESC [ RunTime:0.065803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348596 LIMIT 2 [ RunTime:0.070256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348596 ORDER BY `minOrder` ASC [ RunTime:0.005427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348595 LIMIT 5 [ RunTime:0.010986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348595 ORDER BY `minOrder` ASC [ RunTime:0.021545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348595 ORDER BY `unit` DESC [ RunTime:0.018600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348595 LIMIT 2 [ RunTime:0.023962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348595 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469282 LIMIT 5 [ RunTime:0.020853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469282 ORDER BY `minOrder` ASC [ RunTime:0.045926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13469282 ORDER BY `unit` DESC [ RunTime:0.016271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13469282 LIMIT 2 [ RunTime:0.054819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469282 ORDER BY `minOrder` ASC [ RunTime:0.007439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469277 LIMIT 5 [ RunTime:0.011937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469277 ORDER BY `minOrder` ASC [ RunTime:0.007339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13469277 ORDER BY `unit` DESC [ RunTime:0.005267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13469277 LIMIT 2 [ RunTime:0.021065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469277 ORDER BY `minOrder` ASC [ RunTime:0.004728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469276 LIMIT 5 [ RunTime:0.003337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469276 ORDER BY `minOrder` ASC [ RunTime:0.007748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13469276 ORDER BY `unit` DESC [ RunTime:0.001388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13469276 LIMIT 2 [ RunTime:0.002053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13469276 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012362s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58301529 LIMIT 5 [ RunTime:0.011088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301529 ORDER BY `minOrder` ASC [ RunTime:0.006125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58301529 ORDER BY `unit` DESC [ RunTime:0.012086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58301529 LIMIT 2 [ RunTime:0.003745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301529 ORDER BY `minOrder` ASC [ RunTime:0.002335s ]
select * from pdf where partno='R88M-GP10030T-BOS2' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.010714s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-BOS2' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.017523s ]
SELECT `id` FROM `stock` WHERE `id` <> 58301529 AND `partno` = 'R88M-GP10030T-BOS2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469282 [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58301528 LIMIT 5 [ RunTime:0.017617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301528 ORDER BY `minOrder` ASC [ RunTime:0.007161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58301528 ORDER BY `unit` DESC [ RunTime:0.015711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58301528 LIMIT 2 [ RunTime:0.013116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301528 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='R88M-GP10030T-BO' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-BO' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000797s ]
SELECT `id` FROM `stock` WHERE `id` <> 58301528 AND `partno` = 'R88M-GP10030T-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.003766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348809 [ RunTime:0.009450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58301519 LIMIT 5 [ RunTime:0.006094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301519 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58301519 ORDER BY `unit` DESC [ RunTime:0.011968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58301519 LIMIT 2 [ RunTime:0.003847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301519 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='R88M-GP10030T-BS2' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.005124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-BS2' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.010017s ]
SELECT `id` FROM `stock` WHERE `id` <> 58301519 AND `partno` = 'R88M-GP10030T-BS2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.006625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469277 [ RunTime:0.002219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58301518 LIMIT 5 [ RunTime:0.003868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301518 ORDER BY `minOrder` ASC [ RunTime:0.003061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58301518 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58301518 LIMIT 2 [ RunTime:0.004777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58301518 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
select * from pdf where partno='R88M-GP10030T-B' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.003088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-B' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.018917s ]
SELECT `id` FROM `stock` WHERE `id` <> 58301518 AND `partno` = 'R88M-GP10030T-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.010735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13469276 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58300918 LIMIT 5 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300918 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58300918 ORDER BY `unit` DESC [ RunTime:0.009581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58300918 LIMIT 2 [ RunTime:0.011332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300918 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
select * from pdf where partno='R88M-GP10030T-OS2' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.006870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-OS2' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.009566s ]
SELECT `id` FROM `stock` WHERE `id` <> 58300918 AND `partno` = 'R88M-GP10030T-OS2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348603 [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58300917 LIMIT 5 [ RunTime:0.007995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300917 ORDER BY `minOrder` ASC [ RunTime:0.004522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58300917 ORDER BY `unit` DESC [ RunTime:0.006759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58300917 LIMIT 2 [ RunTime:0.005007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300917 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='R88M-GP10030T-O' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-O' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.007418s ]
SELECT `id` FROM `stock` WHERE `id` <> 58300917 AND `partno` = 'R88M-GP10030T-O' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348602 [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58300908 LIMIT 5 [ RunTime:0.006987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300908 ORDER BY `minOrder` ASC [ RunTime:0.010292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58300908 ORDER BY `unit` DESC [ RunTime:0.006561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58300908 LIMIT 2 [ RunTime:0.009348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300908 ORDER BY `minOrder` ASC [ RunTime:0.005729s ]
select * from pdf where partno='R88M-GP10030T-S2' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.008024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T-S2' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.015925s ]
SELECT `id` FROM `stock` WHERE `id` <> 58300908 AND `partno` = 'R88M-GP10030T-S2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.005151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348596 [ RunTime:0.008195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58300907 LIMIT 5 [ RunTime:0.002114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300907 ORDER BY `minOrder` ASC [ RunTime:0.014634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58300907 ORDER BY `unit` DESC [ RunTime:0.014270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58300907 LIMIT 2 [ RunTime:0.017161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58300907 ORDER BY `minOrder` ASC [ RunTime:0.002989s ]
select * from pdf where partno='R88M-GP10030T' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R88M-GP10030T' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.020685s ]
SELECT `id` FROM `stock` WHERE `id` <> 58300907 AND `partno` = 'R88M-GP10030T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.021158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348595 [ RunTime:0.021250s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025719s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035778s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019881s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023690s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025087s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030904s ]
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 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012900s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R88M-GP10030T%' OR `brand` LIKE 'R88M-GP10030T%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021964s ]