SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001401s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=PLT2I-M&search=1' [ RunTime:0.004067s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001265s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000446s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001354s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001691s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001274s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PLT2I-M' LIMIT 1 [ RunTime:0.010041s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-12 02:53:24' WHERE `partno` = 'PLT2I-M' [ RunTime:0.007367s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001449s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011423s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406673 LIMIT 5 [ RunTime:0.009956s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406673 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14406673 ORDER BY `unit` DESC [ RunTime:0.004172s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14406673 LIMIT 2 [ RunTime:0.003460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406673 ORDER BY `minOrder` ASC [ RunTime:0.004028s ]
select * from pdf where partno='PLT2I-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.020128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536233 LIMIT 5 [ RunTime:0.019920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536233 ORDER BY `minOrder` ASC [ RunTime:0.021603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536233 ORDER BY `unit` DESC [ RunTime:0.010741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536233 LIMIT 2 [ RunTime:0.011715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536233 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
select * from pdf where partno='PLT2I-M0' and brandshort='Panduit Corp' limit 1 [ RunTime:0.016129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420947 LIMIT 5 [ RunTime:0.012261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420947 ORDER BY `minOrder` ASC [ RunTime:0.010120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16420947 ORDER BY `unit` DESC [ RunTime:0.025922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16420947 LIMIT 2 [ RunTime:0.008071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420947 ORDER BY `minOrder` ASC [ RunTime:0.029935s ]
select * from pdf where partno='PLT2I-M76' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537898 LIMIT 5 [ RunTime:0.010466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537898 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13537898 ORDER BY `unit` DESC [ RunTime:0.038294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13537898 LIMIT 2 [ RunTime:0.028828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537898 ORDER BY `minOrder` ASC [ RunTime:0.009527s ]
select * from pdf where partno='PLT2I-M14' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408198 LIMIT 5 [ RunTime:0.027787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408198 ORDER BY `minOrder` ASC [ RunTime:0.005404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408198 ORDER BY `unit` DESC [ RunTime:0.012594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408198 LIMIT 2 [ RunTime:0.021969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408198 ORDER BY `minOrder` ASC [ RunTime:0.011111s ]
select * from pdf where partno='PLT2I-M30' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536323 LIMIT 5 [ RunTime:0.016011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536323 ORDER BY `minOrder` ASC [ RunTime:0.012587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536323 ORDER BY `unit` DESC [ RunTime:0.002832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536323 LIMIT 2 [ RunTime:0.020788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536323 ORDER BY `minOrder` ASC [ RunTime:0.014829s ]
select * from pdf where partno='PLT2I-M7' and brandshort='Panduit Corp' limit 1 [ RunTime:0.025071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537436 LIMIT 5 [ RunTime:0.010831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537436 ORDER BY `minOrder` ASC [ RunTime:0.016075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13537436 ORDER BY `unit` DESC [ RunTime:0.017154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13537436 LIMIT 2 [ RunTime:0.014332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537436 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
select * from pdf where partno='PLT2I-M69' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422357 LIMIT 5 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422357 ORDER BY `minOrder` ASC [ RunTime:0.003870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422357 ORDER BY `unit` DESC [ RunTime:0.017341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422357 LIMIT 2 [ RunTime:0.030928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422357 ORDER BY `minOrder` ASC [ RunTime:0.008484s ]
select * from pdf where partno='PLT2I-M300' and brandshort='Panduit Corp' limit 1 [ RunTime:0.030682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408199 LIMIT 5 [ RunTime:0.007817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408199 ORDER BY `minOrder` ASC [ RunTime:0.007910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408199 ORDER BY `unit` DESC [ RunTime:0.012173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408199 LIMIT 2 [ RunTime:0.015456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408199 ORDER BY `minOrder` ASC [ RunTime:0.016376s ]
select * from pdf where partno='PLT2I-M20' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536325 LIMIT 5 [ RunTime:0.008899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536325 ORDER BY `minOrder` ASC [ RunTime:0.011852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536325 ORDER BY `unit` DESC [ RunTime:0.010310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536325 LIMIT 2 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536325 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
select * from pdf where partno='PLT2I-M55' and brandshort='Panduit Corp' limit 1 [ RunTime:0.011203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406844 LIMIT 5 [ RunTime:0.013549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406844 ORDER BY `minOrder` ASC [ RunTime:0.002336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14406844 ORDER BY `unit` DESC [ RunTime:0.037016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14406844 LIMIT 2 [ RunTime:0.057652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14406844 ORDER BY `minOrder` ASC [ RunTime:0.017540s ]
select * from pdf where partno='PLT2I-M10' and brandshort='Panduit Corp' limit 1 [ RunTime:0.020777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407219 LIMIT 5 [ RunTime:0.038809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407219 ORDER BY `minOrder` ASC [ RunTime:0.031596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407219 ORDER BY `unit` DESC [ RunTime:0.018919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407219 LIMIT 2 [ RunTime:0.029731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407219 ORDER BY `minOrder` ASC [ RunTime:0.013290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407214 LIMIT 5 [ RunTime:0.010518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407214 ORDER BY `minOrder` ASC [ RunTime:0.011764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407214 ORDER BY `unit` DESC [ RunTime:0.002860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407214 LIMIT 2 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407214 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
select * from pdf where partno='PLT2I-M54' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536700 LIMIT 5 [ RunTime:0.019215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536700 ORDER BY `minOrder` ASC [ RunTime:0.017663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13536700 ORDER BY `unit` DESC [ RunTime:0.028450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13536700 LIMIT 2 [ RunTime:0.030579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13536700 ORDER BY `minOrder` ASC [ RunTime:0.004332s ]
select * from pdf where partno='PLT2I-M6' and brandshort='Panduit Corp' limit 1 [ RunTime:0.030595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421481 LIMIT 5 [ RunTime:0.020991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421481 ORDER BY `minOrder` ASC [ RunTime:0.031849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16421481 ORDER BY `unit` DESC [ RunTime:0.063847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16421481 LIMIT 2 [ RunTime:0.060350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421481 ORDER BY `minOrder` ASC [ RunTime:0.027382s ]
select * from pdf where partno='PLT2I-M8' and brandshort='Panduit Corp' limit 1 [ RunTime:0.032444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421453 LIMIT 5 [ RunTime:0.034447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421453 ORDER BY `minOrder` ASC [ RunTime:0.009890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16421453 ORDER BY `unit` DESC [ RunTime:0.004334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16421453 LIMIT 2 [ RunTime:0.036861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421453 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421201 LIMIT 5 [ RunTime:0.008884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421201 ORDER BY `minOrder` ASC [ RunTime:0.011495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16421201 ORDER BY `unit` DESC [ RunTime:0.008314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16421201 LIMIT 2 [ RunTime:0.035472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16421201 ORDER BY `minOrder` ASC [ RunTime:0.005543s ]
select * from pdf where partno='PLT2I-M59' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407555 LIMIT 5 [ RunTime:0.034307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407555 ORDER BY `minOrder` ASC [ RunTime:0.047444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14407555 ORDER BY `unit` DESC [ RunTime:0.052201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14407555 LIMIT 2 [ RunTime:0.012124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14407555 ORDER BY `minOrder` ASC [ RunTime:0.017985s ]
select * from pdf where partno='PLT2I-M3' and brandshort='Panduit Corp' limit 1 [ RunTime:0.040726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537832 LIMIT 5 [ RunTime:0.033218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537832 ORDER BY `minOrder` ASC [ RunTime:0.044073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13537832 ORDER BY `unit` DESC [ RunTime:0.010581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13537832 LIMIT 2 [ RunTime:0.130478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537832 ORDER BY `minOrder` ASC [ RunTime:0.014359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537247 LIMIT 5 [ RunTime:0.011424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537247 ORDER BY `minOrder` ASC [ RunTime:0.021281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13537247 ORDER BY `unit` DESC [ RunTime:0.023836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13537247 LIMIT 2 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13537247 ORDER BY `minOrder` ASC [ RunTime:0.015842s ]
select * from pdf where partno='PLT2I-M53' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002382s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047627s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63087590 LIMIT 5 [ RunTime:0.022755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63087590 ORDER BY `minOrder` ASC [ RunTime:0.028354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63087590 ORDER BY `unit` DESC [ RunTime:0.011204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63087590 LIMIT 2 [ RunTime:0.045587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63087590 ORDER BY `minOrder` ASC [ RunTime:0.004459s ]
select * from pdf where partno='PLT2I-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000745s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.039235s ]
SELECT `id` FROM `stock` WHERE `id` <> 63087590 AND `partno` = 'PLT2I-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.027917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406673 [ RunTime:0.034897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088127 LIMIT 5 [ RunTime:0.010252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088127 ORDER BY `minOrder` ASC [ RunTime:0.043343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088127 ORDER BY `unit` DESC [ RunTime:0.056464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088127 LIMIT 2 [ RunTime:0.017545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088127 ORDER BY `minOrder` ASC [ RunTime:0.009960s ]
select * from pdf where partno='PLT2I-M10' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M10' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.049870s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088127 AND `partno` = 'PLT2I-M10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.047011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14406844 [ RunTime:0.043529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088160 LIMIT 5 [ RunTime:0.025935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088160 ORDER BY `minOrder` ASC [ RunTime:0.055389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088160 ORDER BY `unit` DESC [ RunTime:0.021017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088160 LIMIT 2 [ RunTime:0.021050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088160 ORDER BY `minOrder` ASC [ RunTime:0.006220s ]
select * from pdf where partno='PLT2I-M300' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M300' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007337s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088160 AND `partno` = 'PLT2I-M300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.030966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422357 [ RunTime:0.014544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088798 LIMIT 5 [ RunTime:0.006999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088798 ORDER BY `minOrder` ASC [ RunTime:0.002786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088798 ORDER BY `unit` DESC [ RunTime:0.005783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088798 LIMIT 2 [ RunTime:0.008901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088798 ORDER BY `minOrder` ASC [ RunTime:0.011476s ]
select * from pdf where partno='PLT2I-M55' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M55' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.008092s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088798 AND `partno` = 'PLT2I-M55' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536325 [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088253 LIMIT 5 [ RunTime:0.011221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088253 ORDER BY `minOrder` ASC [ RunTime:0.015099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088253 ORDER BY `unit` DESC [ RunTime:0.023558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088253 LIMIT 2 [ RunTime:0.022063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088253 ORDER BY `minOrder` ASC [ RunTime:0.006894s ]
select * from pdf where partno='PLT2I-M69' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M69' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004920s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088253 AND `partno` = 'PLT2I-M69' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.019523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537436 [ RunTime:0.032754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089631 LIMIT 5 [ RunTime:0.002826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089631 ORDER BY `minOrder` ASC [ RunTime:0.018230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089631 ORDER BY `unit` DESC [ RunTime:0.013199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089631 LIMIT 2 [ RunTime:0.013349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089631 ORDER BY `minOrder` ASC [ RunTime:0.009063s ]
select * from pdf where partno='PLT2I-M54' and brandshort='Panduit Corp' limit 1 [ RunTime:0.010604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M54' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.013139s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089631 AND `partno` = 'PLT2I-M54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.021491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407214 [ RunTime:0.016499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089432 LIMIT 5 [ RunTime:0.015422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089432 ORDER BY `minOrder` ASC [ RunTime:0.034661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089432 ORDER BY `unit` DESC [ RunTime:0.014082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089432 LIMIT 2 [ RunTime:0.010507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089432 ORDER BY `minOrder` ASC [ RunTime:0.012777s ]
select * from pdf where partno='PLT2I-M30' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M30' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.008534s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089432 AND `partno` = 'PLT2I-M30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.013825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408198 [ RunTime:0.009083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089071 LIMIT 5 [ RunTime:0.025150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089071 ORDER BY `minOrder` ASC [ RunTime:0.011801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089071 ORDER BY `unit` DESC [ RunTime:0.007744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089071 LIMIT 2 [ RunTime:0.030314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089071 ORDER BY `minOrder` ASC [ RunTime:0.010894s ]
select * from pdf where partno='PLT2I-M20' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M20' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007069s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089071 AND `partno` = 'PLT2I-M20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.028958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408199 [ RunTime:0.015749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089438 LIMIT 5 [ RunTime:0.020343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089438 ORDER BY `minOrder` ASC [ RunTime:0.026039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089438 ORDER BY `unit` DESC [ RunTime:0.035354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089438 LIMIT 2 [ RunTime:0.023730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089438 ORDER BY `minOrder` ASC [ RunTime:0.023504s ]
select * from pdf where partno='PLT2I-M6' and brandshort='Panduit Corp' limit 1 [ RunTime:0.018755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M6' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.025523s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089438 AND `partno` = 'PLT2I-M6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.015083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536700 [ RunTime:0.028300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089096 LIMIT 5 [ RunTime:0.009082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089096 ORDER BY `minOrder` ASC [ RunTime:0.015758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089096 ORDER BY `unit` DESC [ RunTime:0.020301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089096 LIMIT 2 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089096 ORDER BY `minOrder` ASC [ RunTime:0.035000s ]
select * from pdf where partno='PLT2I-M7' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M7' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012940s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089096 AND `partno` = 'PLT2I-M7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.036601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536323 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63091058 LIMIT 5 [ RunTime:0.024960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091058 ORDER BY `minOrder` ASC [ RunTime:0.032193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63091058 ORDER BY `unit` DESC [ RunTime:0.059005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63091058 LIMIT 2 [ RunTime:0.029355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091058 ORDER BY `minOrder` ASC [ RunTime:0.017709s ]
select * from pdf where partno='PLT2I-M4Y' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M4Y' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005272s ]
SELECT `id` FROM `stock` WHERE `id` <> 63091058 AND `partno` = 'PLT2I-M4Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407219 [ RunTime:0.050227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090977 LIMIT 5 [ RunTime:0.005293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090977 ORDER BY `minOrder` ASC [ RunTime:0.008007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090977 ORDER BY `unit` DESC [ RunTime:0.004863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090977 LIMIT 2 [ RunTime:0.007925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090977 ORDER BY `minOrder` ASC [ RunTime:0.006569s ]
select * from pdf where partno='PLT2I-M53' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M53' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004560s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090977 AND `partno` = 'PLT2I-M53' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537247 [ RunTime:0.002131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090967 LIMIT 5 [ RunTime:0.018145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090967 ORDER BY `minOrder` ASC [ RunTime:0.020541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090967 ORDER BY `unit` DESC [ RunTime:0.028807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090967 LIMIT 2 [ RunTime:0.078738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090967 ORDER BY `minOrder` ASC [ RunTime:0.018144s ]
select * from pdf where partno='PLT2I-M59' and brandshort='Panduit Corp' limit 1 [ RunTime:0.020340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M59' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.025194s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090967 AND `partno` = 'PLT2I-M59' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.023412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421201 [ RunTime:0.003961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090959 LIMIT 5 [ RunTime:0.018566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090959 ORDER BY `minOrder` ASC [ RunTime:0.012531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090959 ORDER BY `unit` DESC [ RunTime:0.017922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090959 LIMIT 2 [ RunTime:0.038522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090959 ORDER BY `minOrder` ASC [ RunTime:0.013309s ]
select * from pdf where partno='PLT2I-M1' and brandshort='Panduit Corp' limit 1 [ RunTime:0.051372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M1' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012477s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090959 AND `partno` = 'PLT2I-M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536973 [ RunTime:0.036791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090799 LIMIT 5 [ RunTime:0.005797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090799 ORDER BY `minOrder` ASC [ RunTime:0.003391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090799 ORDER BY `unit` DESC [ RunTime:0.019160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090799 LIMIT 2 [ RunTime:0.018099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090799 ORDER BY `minOrder` ASC [ RunTime:0.023362s ]
select * from pdf where partno='PLT2I-M4' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M4' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.033117s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090799 AND `partno` = 'PLT2I-M4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.019532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421453 [ RunTime:0.008109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090258 LIMIT 5 [ RunTime:0.003768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090258 ORDER BY `minOrder` ASC [ RunTime:0.012211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090258 ORDER BY `unit` DESC [ RunTime:0.014674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090258 LIMIT 2 [ RunTime:0.017654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090258 ORDER BY `minOrder` ASC [ RunTime:0.012762s ]
select * from pdf where partno='PLT2I-M3' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M3' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012218s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090258 AND `partno` = 'PLT2I-M3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.036540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14407555 [ RunTime:0.022484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090254 LIMIT 5 [ RunTime:0.017105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090254 ORDER BY `minOrder` ASC [ RunTime:0.020102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090254 ORDER BY `unit` DESC [ RunTime:0.026625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090254 LIMIT 2 [ RunTime:0.004094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090254 ORDER BY `minOrder` ASC [ RunTime:0.012977s ]
select * from pdf where partno='PLT2I-M5' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M5' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004697s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090254 AND `partno` = 'PLT2I-M5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.016775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537240 [ RunTime:0.016523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090252 LIMIT 5 [ RunTime:0.021157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090252 ORDER BY `minOrder` ASC [ RunTime:0.005168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090252 ORDER BY `unit` DESC [ RunTime:0.005483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090252 LIMIT 2 [ RunTime:0.008190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090252 ORDER BY `minOrder` ASC [ RunTime:0.026820s ]
select * from pdf where partno='PLT2I-M8' and brandshort='Panduit Corp' limit 1 [ RunTime:0.009824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M8' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007904s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090252 AND `partno` = 'PLT2I-M8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16421481 [ RunTime:0.009900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63090251 LIMIT 5 [ RunTime:0.033224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090251 ORDER BY `minOrder` ASC [ RunTime:0.057281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63090251 ORDER BY `unit` DESC [ RunTime:0.073556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63090251 LIMIT 2 [ RunTime:0.015066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63090251 ORDER BY `minOrder` ASC [ RunTime:0.029558s ]
select * from pdf where partno='PLT2I-M2' and brandshort='Panduit Corp' limit 1 [ RunTime:0.018641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M2' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.042172s ]
SELECT `id` FROM `stock` WHERE `id` <> 63090251 AND `partno` = 'PLT2I-M2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.053013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537239 [ RunTime:0.079493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63089871 LIMIT 5 [ RunTime:0.042484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089871 ORDER BY `minOrder` ASC [ RunTime:0.052604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63089871 ORDER BY `unit` DESC [ RunTime:0.035696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63089871 LIMIT 2 [ RunTime:0.046215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63089871 ORDER BY `minOrder` ASC [ RunTime:0.038421s ]
select * from pdf where partno='PLT2I-M14' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT2I-M14' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.011597s ]
SELECT `id` FROM `stock` WHERE `id` <> 63089871 AND `partno` = 'PLT2I-M14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.072319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13537898 [ RunTime:0.032714s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037136s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053843s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041234s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014264s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017982s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034645s ]
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 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029714s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PLT2I-M%' OR `brand` LIKE 'PLT2I-M%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024212s ]