SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001253s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=86007&search=1' [ RunTime:0.002906s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002150s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001460s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001549s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004905s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001615s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015686s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001428s ]
SELECT * FROM `stock_search` WHERE `partno` = '86007' LIMIT 1 [ RunTime:0.002303s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-22 20:59:18' WHERE `partno` = '86007' [ RunTime:0.005721s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001450s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011050s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387985 LIMIT 5 [ RunTime:0.008315s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387985 ORDER BY `minOrder` ASC [ RunTime:0.012244s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387985 ORDER BY `unit` DESC [ RunTime:0.017954s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387985 LIMIT 2 [ RunTime:0.020363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387985 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
select * from pdf where partno='86007CY SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389969 LIMIT 5 [ RunTime:0.053951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389969 ORDER BY `minOrder` ASC [ RunTime:0.015206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389969 ORDER BY `unit` DESC [ RunTime:0.038302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389969 LIMIT 2 [ RunTime:0.021336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389969 ORDER BY `minOrder` ASC [ RunTime:0.033795s ]
select * from pdf where partno='86007CY SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.049127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394267 LIMIT 5 [ RunTime:0.018938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394267 ORDER BY `minOrder` ASC [ RunTime:0.016853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394267 ORDER BY `unit` DESC [ RunTime:0.049059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394267 LIMIT 2 [ RunTime:0.018769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394267 ORDER BY `minOrder` ASC [ RunTime:0.038967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377483 LIMIT 5 [ RunTime:0.024804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377483 ORDER BY `minOrder` ASC [ RunTime:0.030837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377483 ORDER BY `unit` DESC [ RunTime:0.021804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377483 LIMIT 2 [ RunTime:0.029096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377483 ORDER BY `minOrder` ASC [ RunTime:0.010273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377279 LIMIT 5 [ RunTime:0.034443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377279 ORDER BY `minOrder` ASC [ RunTime:0.007034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377279 ORDER BY `unit` DESC [ RunTime:0.026082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377279 LIMIT 2 [ RunTime:0.010737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377279 ORDER BY `minOrder` ASC [ RunTime:0.012162s ]
select * from pdf where partno='86007 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.028376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377027 LIMIT 5 [ RunTime:0.065026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377027 ORDER BY `minOrder` ASC [ RunTime:0.044528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377027 ORDER BY `unit` DESC [ RunTime:0.048987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377027 LIMIT 2 [ RunTime:0.039376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377027 ORDER BY `minOrder` ASC [ RunTime:0.012417s ]
select * from pdf where partno='86007 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.013740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376568 LIMIT 5 [ RunTime:0.034947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376568 ORDER BY `minOrder` ASC [ RunTime:0.031871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376568 ORDER BY `unit` DESC [ RunTime:0.037530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376568 LIMIT 2 [ RunTime:0.004785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376568 ORDER BY `minOrder` ASC [ RunTime:0.019824s ]
select * from pdf where partno='86007CY SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.027030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13500772 LIMIT 5 [ RunTime:0.047999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13500772 ORDER BY `minOrder` ASC [ RunTime:0.013745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13500772 ORDER BY `unit` DESC [ RunTime:0.007627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13500772 LIMIT 2 [ RunTime:0.029596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13500772 ORDER BY `minOrder` ASC [ RunTime:0.013955s ]
select * from pdf where partno='86007 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.020349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499467 LIMIT 5 [ RunTime:0.032792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499467 ORDER BY `minOrder` ASC [ RunTime:0.027038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13499467 ORDER BY `unit` DESC [ RunTime:0.052859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13499467 LIMIT 2 [ RunTime:0.035232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499467 ORDER BY `minOrder` ASC [ RunTime:0.023024s ]
select * from pdf where partno='86007 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12172466 LIMIT 5 [ RunTime:0.030640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12172466 ORDER BY `minOrder` ASC [ RunTime:0.094573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12172466 ORDER BY `unit` DESC [ RunTime:0.031990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12172466 LIMIT 2 [ RunTime:0.027022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12172466 ORDER BY `minOrder` ASC [ RunTime:0.037809s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027291s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998270 LIMIT 5 [ RunTime:0.060284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998270 ORDER BY `minOrder` ASC [ RunTime:0.034498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998270 ORDER BY `unit` DESC [ RunTime:0.039517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998270 LIMIT 2 [ RunTime:0.041671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998270 ORDER BY `minOrder` ASC [ RunTime:0.034249s ]
select * from pdf where partno='86007CY SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.031090s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007CY SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.063327s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998270 AND `partno` = '86007CY SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.077895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387985 [ RunTime:0.028218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000271 LIMIT 5 [ RunTime:0.052676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000271 ORDER BY `minOrder` ASC [ RunTime:0.031724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000271 ORDER BY `unit` DESC [ RunTime:0.086381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000271 LIMIT 2 [ RunTime:0.057093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000271 ORDER BY `minOrder` ASC [ RunTime:0.025357s ]
select * from pdf where partno='86007CY SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.018374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007CY SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.032587s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000271 AND `partno` = '86007CY SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.043009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389969 [ RunTime:0.120107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64510803 LIMIT 5 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510803 ORDER BY `minOrder` ASC [ RunTime:0.074196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64510803 ORDER BY `unit` DESC [ RunTime:0.046191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64510803 LIMIT 2 [ RunTime:0.047943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510803 ORDER BY `minOrder` ASC [ RunTime:0.030322s ]
select * from pdf where partno='86007' and brandshort='Brady Corporation' limit 1 [ RunTime:0.029510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.039222s ]
SELECT `id` FROM `stock` WHERE `id` <> 64510803 AND `partno` = '86007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394267 [ RunTime:0.009522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63019738 LIMIT 5 [ RunTime:0.013883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019738 ORDER BY `minOrder` ASC [ RunTime:0.024570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63019738 ORDER BY `unit` DESC [ RunTime:0.038860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63019738 LIMIT 2 [ RunTime:0.034051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019738 ORDER BY `minOrder` ASC [ RunTime:0.010557s ]
select * from pdf where partno='86007CY SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.022975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007CY SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.013889s ]
SELECT `id` FROM `stock` WHERE `id` <> 63019738 AND `partno` = '86007CY SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377483 [ RunTime:0.034111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63019251 LIMIT 5 [ RunTime:0.019610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019251 ORDER BY `minOrder` ASC [ RunTime:0.056335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63019251 ORDER BY `unit` DESC [ RunTime:0.004637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63019251 LIMIT 2 [ RunTime:0.021832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019251 ORDER BY `minOrder` ASC [ RunTime:0.013804s ]
select * from pdf where partno='86007 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.039936s ]
SELECT `id` FROM `stock` WHERE `id` <> 63019251 AND `partno` = '86007 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377279 [ RunTime:0.028794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63004145 LIMIT 5 [ RunTime:0.037731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63004145 ORDER BY `minOrder` ASC [ RunTime:0.027893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63004145 ORDER BY `unit` DESC [ RunTime:0.028235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63004145 LIMIT 2 [ RunTime:0.003517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63004145 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='86007 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.011402s ]
SELECT `id` FROM `stock` WHERE `id` <> 63004145 AND `partno` = '86007 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499467 [ RunTime:0.019487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63003840 LIMIT 5 [ RunTime:0.057397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003840 ORDER BY `minOrder` ASC [ RunTime:0.057605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63003840 ORDER BY `unit` DESC [ RunTime:0.014281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63003840 LIMIT 2 [ RunTime:0.035412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003840 ORDER BY `minOrder` ASC [ RunTime:0.057280s ]
select * from pdf where partno='86007CY SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007CY SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.009980s ]
SELECT `id` FROM `stock` WHERE `id` <> 63003840 AND `partno` = '86007CY SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.049524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376568 [ RunTime:0.020838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63003780 LIMIT 5 [ RunTime:0.018515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003780 ORDER BY `minOrder` ASC [ RunTime:0.030190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63003780 ORDER BY `unit` DESC [ RunTime:0.015976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63003780 LIMIT 2 [ RunTime:0.016698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003780 ORDER BY `minOrder` ASC [ RunTime:0.027614s ]
select * from pdf where partno='86007 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.013059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.053221s ]
SELECT `id` FROM `stock` WHERE `id` <> 63003780 AND `partno` = '86007 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13500772 [ RunTime:0.067344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63003019 LIMIT 5 [ RunTime:0.034480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003019 ORDER BY `minOrder` ASC [ RunTime:0.044539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63003019 ORDER BY `unit` DESC [ RunTime:0.050682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63003019 LIMIT 2 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003019 ORDER BY `minOrder` ASC [ RunTime:0.026006s ]
select * from pdf where partno='86007 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86007 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.012492s ]
SELECT `id` FROM `stock` WHERE `id` <> 63003019 AND `partno` = '86007 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.017559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377027 [ RunTime:0.060198s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001283s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034610s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016545s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028407s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028044s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046626s ]
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 '86007%' OR `brand` LIKE '86007%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038267s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '86007%' OR `brand` LIKE '86007%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.066382s ]