SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002781s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103868s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13129885 LIMIT 5 [ RunTime:0.065578s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.032216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129885 ORDER BY `minOrder` ASC [ RunTime:0.124132s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13129885 ORDER BY `unit` DESC [ RunTime:0.015356s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13129885 LIMIT 2 [ RunTime:0.069950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129885 ORDER BY `minOrder` ASC [ RunTime:0.110823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13129884 LIMIT 5 [ RunTime:0.054164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129884 ORDER BY `minOrder` ASC [ RunTime:0.082872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13129884 ORDER BY `unit` DESC [ RunTime:0.120723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13129884 LIMIT 2 [ RunTime:0.034227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129884 ORDER BY `minOrder` ASC [ RunTime:0.041289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13129883 LIMIT 5 [ RunTime:0.009409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129883 ORDER BY `minOrder` ASC [ RunTime:0.096403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13129883 ORDER BY `unit` DESC [ RunTime:0.041082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13129883 LIMIT 2 [ RunTime:0.049313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129883 ORDER BY `minOrder` ASC [ RunTime:0.054874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13129882 LIMIT 5 [ RunTime:0.071272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129882 ORDER BY `minOrder` ASC [ RunTime:0.064607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13129882 ORDER BY `unit` DESC [ RunTime:0.074059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13129882 LIMIT 2 [ RunTime:0.058903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13129882 ORDER BY `minOrder` ASC [ RunTime:0.025204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127960 LIMIT 5 [ RunTime:0.042443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127960 ORDER BY `minOrder` ASC [ RunTime:0.037535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127960 ORDER BY `unit` DESC [ RunTime:0.014386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127960 LIMIT 2 [ RunTime:0.006425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127960 ORDER BY `minOrder` ASC [ RunTime:0.004695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13125441 LIMIT 5 [ RunTime:0.015040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13125441 ORDER BY `minOrder` ASC [ RunTime:0.034206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13125441 ORDER BY `unit` DESC [ RunTime:0.011438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13125441 LIMIT 2 [ RunTime:0.036697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13125441 ORDER BY `minOrder` ASC [ RunTime:0.009948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13123732 LIMIT 5 [ RunTime:0.029409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13123732 ORDER BY `minOrder` ASC [ RunTime:0.082875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13123732 ORDER BY `unit` DESC [ RunTime:0.065402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13123732 LIMIT 2 [ RunTime:0.045908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13123732 ORDER BY `minOrder` ASC [ RunTime:0.024375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13115119 LIMIT 5 [ RunTime:0.059634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13115119 ORDER BY `minOrder` ASC [ RunTime:0.040148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13115119 ORDER BY `unit` DESC [ RunTime:0.058435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13115119 LIMIT 2 [ RunTime:0.010483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13115119 ORDER BY `minOrder` ASC [ RunTime:0.018290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11872599 LIMIT 5 [ RunTime:0.033343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872599 ORDER BY `minOrder` ASC [ RunTime:0.084589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11872599 ORDER BY `unit` DESC [ RunTime:0.033250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11872599 LIMIT 2 [ RunTime:0.022052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872599 ORDER BY `minOrder` ASC [ RunTime:0.011673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11872598 LIMIT 5 [ RunTime:0.022076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872598 ORDER BY `minOrder` ASC [ RunTime:0.030794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11872598 ORDER BY `unit` DESC [ RunTime:0.127965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11872598 LIMIT 2 [ RunTime:0.030060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872598 ORDER BY `minOrder` ASC [ RunTime:0.013797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11872597 LIMIT 5 [ RunTime:0.080366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872597 ORDER BY `minOrder` ASC [ RunTime:0.088331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11872597 ORDER BY `unit` DESC [ RunTime:0.074108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11872597 LIMIT 2 [ RunTime:0.012577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872597 ORDER BY `minOrder` ASC [ RunTime:0.014452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11872596 LIMIT 5 [ RunTime:0.066390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872596 ORDER BY `minOrder` ASC [ RunTime:0.048790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11872596 ORDER BY `unit` DESC [ RunTime:0.057300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11872596 LIMIT 2 [ RunTime:0.055243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11872596 ORDER BY `minOrder` ASC [ RunTime:0.002225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870407 LIMIT 5 [ RunTime:0.109657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870407 ORDER BY `minOrder` ASC [ RunTime:0.045715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870407 ORDER BY `unit` DESC [ RunTime:0.036252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870407 LIMIT 2 [ RunTime:0.041867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870407 ORDER BY `minOrder` ASC [ RunTime:0.008393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11869434 LIMIT 5 [ RunTime:0.036501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11869434 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11869434 ORDER BY `unit` DESC [ RunTime:0.051291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11869434 LIMIT 2 [ RunTime:0.031040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11869434 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253116 LIMIT 5 [ RunTime:0.009436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253116 ORDER BY `minOrder` ASC [ RunTime:0.044432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253116 ORDER BY `unit` DESC [ RunTime:0.019493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253116 LIMIT 2 [ RunTime:0.016574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253116 ORDER BY `minOrder` ASC [ RunTime:0.011871s ]
select * from pdf where partno='l717sdeg09p' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.002701s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l717sdeg09p' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.006305s ]
SELECT `id` FROM `stock` WHERE `id` <> 32253116 AND `partno` = 'l717sdeg09p' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.053040s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55116261 LIMIT 5 [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55116261 ORDER BY `minOrder` ASC [ RunTime:0.016399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55116261 ORDER BY `unit` DESC [ RunTime:0.026173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55116261 LIMIT 2 [ RunTime:0.041981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55116261 ORDER BY `minOrder` ASC [ RunTime:0.039510s ]
select * from pdf where partno='L717SDEG09POL2C309' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.006889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09POL2C309' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.011412s ]
SELECT `id` FROM `stock` WHERE `id` <> 55116261 AND `partno` = 'L717SDEG09POL2C309' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.016934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13115119 [ RunTime:0.014344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55129814 LIMIT 5 [ RunTime:0.013388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129814 ORDER BY `minOrder` ASC [ RunTime:0.019292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55129814 ORDER BY `unit` DESC [ RunTime:0.033622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55129814 LIMIT 2 [ RunTime:0.022581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129814 ORDER BY `minOrder` ASC [ RunTime:0.015572s ]
select * from pdf where partno='L717SDEG09POL2RM8C309' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.025649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09POL2RM8C309' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.044063s ]
SELECT `id` FROM `stock` WHERE `id` <> 55129814 AND `partno` = 'L717SDEG09POL2RM8C309' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.029362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870407 [ RunTime:0.016514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55129646 LIMIT 5 [ RunTime:0.005391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129646 ORDER BY `minOrder` ASC [ RunTime:0.035238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55129646 ORDER BY `unit` DESC [ RunTime:0.038366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55129646 LIMIT 2 [ RunTime:0.030271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129646 ORDER BY `minOrder` ASC [ RunTime:0.020100s ]
select * from pdf where partno='L717SDEG09POL2RM5' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.096393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09POL2RM5' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.009083s ]
SELECT `id` FROM `stock` WHERE `id` <> 55129646 AND `partno` = 'L717SDEG09POL2RM5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11869434 [ RunTime:0.028319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55129560 LIMIT 5 [ RunTime:0.012749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129560 ORDER BY `minOrder` ASC [ RunTime:0.023475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55129560 ORDER BY `unit` DESC [ RunTime:0.008003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55129560 LIMIT 2 [ RunTime:0.007488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129560 ORDER BY `minOrder` ASC [ RunTime:0.019283s ]
select * from pdf where partno='L717SDEG09PC309' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.002168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09PC309' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.026117s ]
SELECT `id` FROM `stock` WHERE `id` <> 55129560 AND `partno` = 'L717SDEG09PC309' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13125441 [ RunTime:0.028632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55129304 LIMIT 5 [ RunTime:0.044610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129304 ORDER BY `minOrder` ASC [ RunTime:0.029679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55129304 ORDER BY `unit` DESC [ RunTime:0.039746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55129304 LIMIT 2 [ RunTime:0.209932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55129304 ORDER BY `minOrder` ASC [ RunTime:0.070880s ]
select * from pdf where partno='L717SDEG09P' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.052627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09P' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.080999s ]
SELECT `id` FROM `stock` WHERE `id` <> 55129304 AND `partno` = 'L717SDEG09P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.053597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13123732 [ RunTime:0.134927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35303975 LIMIT 5 [ RunTime:0.005427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35303975 ORDER BY `minOrder` ASC [ RunTime:0.026024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35303975 ORDER BY `unit` DESC [ RunTime:0.017892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35303975 LIMIT 2 [ RunTime:0.019199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35303975 ORDER BY `minOrder` ASC [ RunTime:0.021844s ]
select * from pdf where partno='L717SDEG09POL2RM5G' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.005452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L717SDEG09POL2RM5G' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.012987s ]
SELECT `id` FROM `stock` WHERE `id` <> 35303975 AND `partno` = 'L717SDEG09POL2RM5G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.033977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127960 [ RunTime:0.018273s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099360s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112310s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021667s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.121675s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104534s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054331s ]
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 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083546s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'L717SDEG09P%' OR `brand` LIKE 'L717SDEG09P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.053409s ]