SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001442s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=27396&search=1' [ RunTime:0.004694s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004500s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002425s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.005092s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.003646s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.005536s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005266s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002546s ]
SELECT * FROM `stock_search` WHERE `partno` = '27396' LIMIT 1 [ RunTime:0.002554s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-21 11:31:10' WHERE `partno` = '27396' [ RunTime:0.011747s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002887s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007364s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563187 LIMIT 5 [ RunTime:0.007960s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563187 ORDER BY `minOrder` ASC [ RunTime:0.002278s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563187 ORDER BY `unit` DESC [ RunTime:0.003926s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563187 LIMIT 2 [ RunTime:0.003696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563187 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185637 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185637 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11185637 ORDER BY `unit` DESC [ RunTime:0.002919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11185637 LIMIT 2 [ RunTime:0.003933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185637 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013624 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013624 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013624 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013624 LIMIT 2 [ RunTime:0.002303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013624 ORDER BY `minOrder` ASC [ RunTime:0.008158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655383 LIMIT 5 [ RunTime:0.001223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655383 ORDER BY `minOrder` ASC [ RunTime:0.003134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655383 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655383 LIMIT 2 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655383 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650968 LIMIT 5 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650968 ORDER BY `minOrder` ASC [ RunTime:0.027651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650968 ORDER BY `unit` DESC [ RunTime:0.010144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650968 LIMIT 2 [ RunTime:0.042432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650968 ORDER BY `minOrder` ASC [ RunTime:0.053116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650425 LIMIT 5 [ RunTime:0.036709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650425 ORDER BY `minOrder` ASC [ RunTime:0.025250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650425 ORDER BY `unit` DESC [ RunTime:0.017954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650425 LIMIT 2 [ RunTime:0.033122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650425 ORDER BY `minOrder` ASC [ RunTime:0.027148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686303 LIMIT 5 [ RunTime:0.029698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686303 ORDER BY `minOrder` ASC [ RunTime:0.021903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686303 ORDER BY `unit` DESC [ RunTime:0.019610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686303 LIMIT 2 [ RunTime:0.036149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686303 ORDER BY `minOrder` ASC [ RunTime:0.045205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11448850 LIMIT 5 [ RunTime:0.040239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11448850 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11448850 ORDER BY `unit` DESC [ RunTime:0.007301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11448850 LIMIT 2 [ RunTime:0.010105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11448850 ORDER BY `minOrder` ASC [ RunTime:0.003448s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008749s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53648238 LIMIT 5 [ RunTime:0.013057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648238 ORDER BY `minOrder` ASC [ RunTime:0.012935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53648238 ORDER BY `unit` DESC [ RunTime:0.005351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53648238 LIMIT 2 [ RunTime:0.009182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648238 ORDER BY `minOrder` ASC [ RunTime:0.001137s ]
select * from pdf where partno='2739600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018360s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029120s ]
SELECT `id` FROM `stock` WHERE `id` <> 53648238 AND `partno` = '2739600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563187 [ RunTime:0.009847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51709526 LIMIT 5 [ RunTime:0.014688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51709526 ORDER BY `minOrder` ASC [ RunTime:0.012078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51709526 ORDER BY `unit` DESC [ RunTime:0.015713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51709526 LIMIT 2 [ RunTime:0.013225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51709526 ORDER BY `minOrder` ASC [ RunTime:0.011593s ]
select * from pdf where partno='27396' and brandshort='Wiha' limit 1 [ RunTime:0.024540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27396' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.013486s ]
SELECT `id` FROM `stock` WHERE `id` <> 51709526 AND `partno` = '27396' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.018790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185637 [ RunTime:0.011155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50582219 LIMIT 5 [ RunTime:0.008267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50582219 ORDER BY `minOrder` ASC [ RunTime:0.003136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50582219 ORDER BY `unit` DESC [ RunTime:0.006838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50582219 LIMIT 2 [ RunTime:0.007006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50582219 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
select * from pdf where partno='2739630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005267s ]
SELECT `id` FROM `stock` WHERE `id` <> 50582219 AND `partno` = '2739630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013624 [ RunTime:0.005798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37889886 LIMIT 5 [ RunTime:0.005702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37889886 ORDER BY `minOrder` ASC [ RunTime:0.009694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37889886 ORDER BY `unit` DESC [ RunTime:0.007698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37889886 LIMIT 2 [ RunTime:0.006760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37889886 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
select * from pdf where partno='2739630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001989s ]
SELECT `id` FROM `stock` WHERE `id` <> 37889886 AND `partno` = '2739630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013624 [ RunTime:0.005953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53732892 LIMIT 5 [ RunTime:0.004796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732892 ORDER BY `minOrder` ASC [ RunTime:0.008985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53732892 ORDER BY `unit` DESC [ RunTime:0.015336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53732892 LIMIT 2 [ RunTime:0.012477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732892 ORDER BY `minOrder` ASC [ RunTime:0.006511s ]
select * from pdf where partno='2739650000' and brandshort='Weidmüller' limit 1 [ RunTime:0.023387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739650000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011647s ]
SELECT `id` FROM `stock` WHERE `id` <> 53732892 AND `partno` = '2739650000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655383 [ RunTime:0.005126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53726489 LIMIT 5 [ RunTime:0.014550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726489 ORDER BY `minOrder` ASC [ RunTime:0.010904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53726489 ORDER BY `unit` DESC [ RunTime:0.010826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53726489 LIMIT 2 [ RunTime:0.009091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726489 ORDER BY `minOrder` ASC [ RunTime:0.006453s ]
select * from pdf where partno='2739690000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739690000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017354s ]
SELECT `id` FROM `stock` WHERE `id` <> 53726489 AND `partno` = '2739690000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650425 [ RunTime:0.022603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53619213 LIMIT 5 [ RunTime:0.008483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53619213 ORDER BY `minOrder` ASC [ RunTime:0.015457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53619213 ORDER BY `unit` DESC [ RunTime:0.012468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53619213 LIMIT 2 [ RunTime:0.010474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53619213 ORDER BY `minOrder` ASC [ RunTime:0.005535s ]
select * from pdf where partno='27396' and brandshort='Weidmüller' limit 1 [ RunTime:0.007784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27396' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014395s ]
SELECT `id` FROM `stock` WHERE `id` <> 53619213 AND `partno` = '27396' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.021612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53516211 LIMIT 5 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53516211 ORDER BY `minOrder` ASC [ RunTime:0.019597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53516211 ORDER BY `unit` DESC [ RunTime:0.032047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53516211 LIMIT 2 [ RunTime:0.021103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53516211 ORDER BY `minOrder` ASC [ RunTime:0.021166s ]
select * from pdf where partno='2739640000' and brandshort='Weidmüller' limit 1 [ RunTime:0.026309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2739640000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012287s ]
SELECT `id` FROM `stock` WHERE `id` <> 53516211 AND `partno` = '2739640000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686303 [ RunTime:0.034343s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036013s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027742s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034740s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031198s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027671s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070498s ]
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 '27396%' OR `brand` LIKE '27396%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081928s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '27396%' OR `brand` LIKE '27396%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.071253s ]