SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001630s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018804s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797634 LIMIT 5 [ RunTime:0.003802s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797634 ORDER BY `minOrder` ASC [ RunTime:0.013398s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797634 ORDER BY `unit` DESC [ RunTime:0.025640s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797634 LIMIT 2 [ RunTime:0.048533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797634 ORDER BY `minOrder` ASC [ RunTime:0.050714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797177 LIMIT 5 [ RunTime:0.056165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797177 ORDER BY `minOrder` ASC [ RunTime:0.033508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797177 ORDER BY `unit` DESC [ RunTime:0.062768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797177 LIMIT 2 [ RunTime:0.070231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797177 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796136 LIMIT 5 [ RunTime:0.091278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796136 ORDER BY `minOrder` ASC [ RunTime:0.064576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18796136 ORDER BY `unit` DESC [ RunTime:0.029573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18796136 LIMIT 2 [ RunTime:0.108627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796136 ORDER BY `minOrder` ASC [ RunTime:0.052308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790399 LIMIT 5 [ RunTime:0.028264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790399 ORDER BY `minOrder` ASC [ RunTime:0.019016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18790399 ORDER BY `unit` DESC [ RunTime:0.059127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18790399 LIMIT 2 [ RunTime:0.065157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790399 ORDER BY `minOrder` ASC [ RunTime:0.037375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789589 LIMIT 5 [ RunTime:0.021374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789589 ORDER BY `minOrder` ASC [ RunTime:0.099837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789589 ORDER BY `unit` DESC [ RunTime:0.062586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789589 LIMIT 2 [ RunTime:0.033331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789589 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014359 LIMIT 5 [ RunTime:0.051623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014359 ORDER BY `minOrder` ASC [ RunTime:0.020878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17014359 ORDER BY `unit` DESC [ RunTime:0.027057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17014359 LIMIT 2 [ RunTime:0.040760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014359 ORDER BY `minOrder` ASC [ RunTime:0.010127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012956 LIMIT 5 [ RunTime:0.014216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012956 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012956 ORDER BY `unit` DESC [ RunTime:0.008511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012956 LIMIT 2 [ RunTime:0.013451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012956 ORDER BY `minOrder` ASC [ RunTime:0.003916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012755 LIMIT 5 [ RunTime:0.015967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012755 ORDER BY `minOrder` ASC [ RunTime:0.022083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012755 ORDER BY `unit` DESC [ RunTime:0.012016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012755 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012755 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011598 LIMIT 5 [ RunTime:0.005711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011598 ORDER BY `minOrder` ASC [ RunTime:0.014492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011598 ORDER BY `unit` DESC [ RunTime:0.000968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011598 LIMIT 2 [ RunTime:0.002606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011598 ORDER BY `minOrder` ASC [ RunTime:0.006878s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32238228 LIMIT 5 [ RunTime:0.001445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32238228 ORDER BY `minOrder` ASC [ RunTime:0.002845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32238228 ORDER BY `unit` DESC [ RunTime:0.002249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32238228 LIMIT 2 [ RunTime:0.015067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32238228 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
select * from pdf where partno='e2c-x1r5a-5' and brandshort='omron automation and safety' limit 1 [ RunTime:0.005943s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'e2c-x1r5a-5' OR `brand` LIKE 'omron automation and safety%' ) ) LIMIT 1 [ RunTime:0.010337s ]
SELECT `id` FROM `stock` WHERE `id` <> 32238228 AND `partno` = 'e2c-x1r5a-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789589 [ RunTime:0.000510s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797248 LIMIT 5 [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797248 ORDER BY `minOrder` ASC [ RunTime:0.001084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797248 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797248 LIMIT 2 [ RunTime:0.002250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797248 ORDER BY `minOrder` ASC [ RunTime:0.015768s ]
select * from pdf where partno='E2C-X1R5AH' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.010628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5AH' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.004043s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797248 AND `partno` = 'E2C-X1R5AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.010535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790399 [ RunTime:0.005314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796658 LIMIT 5 [ RunTime:0.004221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796658 ORDER BY `minOrder` ASC [ RunTime:0.025593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796658 ORDER BY `unit` DESC [ RunTime:0.034215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796658 LIMIT 2 [ RunTime:0.027731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796658 ORDER BY `minOrder` ASC [ RunTime:0.017133s ]
select * from pdf where partno='E2C-X1R5A-5 0.6M' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.005906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-5 0.6M' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.019917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796658 AND `partno` = 'E2C-X1R5A-5 0.6M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.047833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012956 [ RunTime:0.008001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796503 LIMIT 5 [ RunTime:0.004052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796503 ORDER BY `minOrder` ASC [ RunTime:0.016352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796503 ORDER BY `unit` DESC [ RunTime:0.001113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796503 LIMIT 2 [ RunTime:0.002955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796503 ORDER BY `minOrder` ASC [ RunTime:0.004144s ]
select * from pdf where partno='E2C-X1R5A-5' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.009307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-5' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.008261s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796503 AND `partno` = 'E2C-X1R5A-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.017257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789589 [ RunTime:0.008164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796481 LIMIT 5 [ RunTime:0.008272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796481 ORDER BY `minOrder` ASC [ RunTime:0.032207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796481 ORDER BY `unit` DESC [ RunTime:0.053922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796481 LIMIT 2 [ RunTime:0.042555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796481 ORDER BY `minOrder` ASC [ RunTime:0.014240s ]
select * from pdf where partno='E2C-X1R5A-5 3M' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.003667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-5 3M' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.042668s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796481 AND `partno` = 'E2C-X1R5A-5 3M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.036129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011598 [ RunTime:0.036817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795795 LIMIT 5 [ RunTime:0.013866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795795 ORDER BY `minOrder` ASC [ RunTime:0.013363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795795 ORDER BY `unit` DESC [ RunTime:0.033180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795795 LIMIT 2 [ RunTime:0.018049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795795 ORDER BY `minOrder` ASC [ RunTime:0.022991s ]
select * from pdf where partno='E2C-X1R5A-2' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.023375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-2' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.063395s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795795 AND `partno` = 'E2C-X1R5A-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.041237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012755 [ RunTime:0.007794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795379 LIMIT 5 [ RunTime:0.025818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795379 ORDER BY `minOrder` ASC [ RunTime:0.021051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795379 ORDER BY `unit` DESC [ RunTime:0.064544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795379 LIMIT 2 [ RunTime:0.077482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795379 ORDER BY `minOrder` ASC [ RunTime:0.085478s ]
select * from pdf where partno='E2C-X1R5A 5M' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.024931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A 5M' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.046188s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795379 AND `partno` = 'E2C-X1R5A 5M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.028327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797634 [ RunTime:0.028578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64795253 LIMIT 5 [ RunTime:0.020929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795253 ORDER BY `minOrder` ASC [ RunTime:0.054500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64795253 ORDER BY `unit` DESC [ RunTime:0.015934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64795253 LIMIT 2 [ RunTime:0.038895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64795253 ORDER BY `minOrder` ASC [ RunTime:0.008255s ]
select * from pdf where partno='E2C-X1R5A-3' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.070280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-3' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.014536s ]
SELECT `id` FROM `stock` WHERE `id` <> 64795253 AND `partno` = 'E2C-X1R5A-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.064130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014359 [ RunTime:0.031832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64794765 LIMIT 5 [ RunTime:0.021511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64794765 ORDER BY `minOrder` ASC [ RunTime:0.028910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64794765 ORDER BY `unit` DESC [ RunTime:0.024772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64794765 LIMIT 2 [ RunTime:0.034708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64794765 ORDER BY `minOrder` ASC [ RunTime:0.008335s ]
select * from pdf where partno='E2C-X1R5A-4' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.018869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A-4' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.018983s ]
SELECT `id` FROM `stock` WHERE `id` <> 64794765 AND `partno` = 'E2C-X1R5A-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.040483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797177 [ RunTime:0.015190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64792850 LIMIT 5 [ RunTime:0.012158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64792850 ORDER BY `minOrder` ASC [ RunTime:0.018222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64792850 ORDER BY `unit` DESC [ RunTime:0.011896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64792850 LIMIT 2 [ RunTime:0.010462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64792850 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
select * from pdf where partno='E2C-X1R5A' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.021604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E2C-X1R5A' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.013891s ]
SELECT `id` FROM `stock` WHERE `id` <> 64792850 AND `partno` = 'E2C-X1R5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.013486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796136 [ RunTime:0.011416s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008578s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020212s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010012s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003287s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002219s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005447s ]
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 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000685s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'E2C-X1R5A%' OR `brand` LIKE 'E2C-X1R5A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000739s ]