SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002237s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023422s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19545107 LIMIT 5 [ RunTime:0.015344s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19545107 ORDER BY `minOrder` ASC [ RunTime:0.007622s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19545107 ORDER BY `unit` DESC [ RunTime:0.004571s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19545107 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19545107 ORDER BY `minOrder` ASC [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543646 LIMIT 5 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543646 ORDER BY `minOrder` ASC [ RunTime:0.001837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543646 ORDER BY `unit` DESC [ RunTime:0.017891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543646 LIMIT 2 [ RunTime:0.016165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543646 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543645 LIMIT 5 [ RunTime:0.009056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543645 ORDER BY `minOrder` ASC [ RunTime:0.007389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543645 ORDER BY `unit` DESC [ RunTime:0.002343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543645 LIMIT 2 [ RunTime:0.004863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543645 ORDER BY `minOrder` ASC [ RunTime:0.003830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543644 LIMIT 5 [ RunTime:0.013361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543644 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543644 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543644 LIMIT 2 [ RunTime:0.003324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543644 ORDER BY `minOrder` ASC [ RunTime:0.005360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543643 LIMIT 5 [ RunTime:0.004315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543643 ORDER BY `minOrder` ASC [ RunTime:0.021903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543643 ORDER BY `unit` DESC [ RunTime:0.005900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543643 LIMIT 2 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543643 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543642 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543642 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543642 ORDER BY `unit` DESC [ RunTime:0.001552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543642 LIMIT 2 [ RunTime:0.001694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543642 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543641 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543641 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543641 ORDER BY `unit` DESC [ RunTime:0.004175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543641 LIMIT 2 [ RunTime:0.002571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543641 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543640 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543640 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543640 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543640 LIMIT 2 [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543640 ORDER BY `minOrder` ASC [ RunTime:0.004224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543639 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543639 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543639 ORDER BY `unit` DESC [ RunTime:0.001050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543639 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543639 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543638 LIMIT 5 [ RunTime:0.003556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543638 ORDER BY `minOrder` ASC [ RunTime:0.001424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543638 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543638 LIMIT 2 [ RunTime:0.001684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543638 ORDER BY `minOrder` ASC [ RunTime:0.006086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543637 LIMIT 5 [ RunTime:0.000740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543637 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543637 ORDER BY `unit` DESC [ RunTime:0.002528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543637 LIMIT 2 [ RunTime:0.006537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543637 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543636 LIMIT 5 [ RunTime:0.003794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543636 ORDER BY `minOrder` ASC [ RunTime:0.001862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543636 ORDER BY `unit` DESC [ RunTime:0.000912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543636 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543636 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543635 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543635 ORDER BY `minOrder` ASC [ RunTime:0.002095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543635 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543635 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543635 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543634 LIMIT 5 [ RunTime:0.003308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543634 ORDER BY `minOrder` ASC [ RunTime:0.003724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543634 ORDER BY `unit` DESC [ RunTime:0.003588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543634 LIMIT 2 [ RunTime:0.010203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543634 ORDER BY `minOrder` ASC [ RunTime:0.003813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543633 LIMIT 5 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543633 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543633 ORDER BY `unit` DESC [ RunTime:0.002758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543633 LIMIT 2 [ RunTime:0.006261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543633 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543632 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543632 ORDER BY `minOrder` ASC [ RunTime:0.006542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543632 ORDER BY `unit` DESC [ RunTime:0.008697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543632 LIMIT 2 [ RunTime:0.007846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543632 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543631 LIMIT 5 [ RunTime:0.003709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543631 ORDER BY `minOrder` ASC [ RunTime:0.007414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543631 ORDER BY `unit` DESC [ RunTime:0.001573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543631 LIMIT 2 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543631 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543560 LIMIT 5 [ RunTime:0.003695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543560 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543560 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543560 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543560 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543559 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543559 ORDER BY `minOrder` ASC [ RunTime:0.006067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543559 ORDER BY `unit` DESC [ RunTime:0.007064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543559 LIMIT 2 [ RunTime:0.001704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543559 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19543558 LIMIT 5 [ RunTime:0.009133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543558 ORDER BY `minOrder` ASC [ RunTime:0.012582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19543558 ORDER BY `unit` DESC [ RunTime:0.008160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19543558 LIMIT 2 [ RunTime:0.010563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19543558 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003284s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58401060 LIMIT 5 [ RunTime:0.013129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58401060 ORDER BY `minOrder` ASC [ RunTime:0.016733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58401060 ORDER BY `unit` DESC [ RunTime:0.020718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58401060 LIMIT 2 [ RunTime:0.009170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58401060 ORDER BY `minOrder` ASC [ RunTime:0.010779s ]
select * from pdf where partno='WLG2-LDFS-DTGJS03' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.012832s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDFS-DTGJS03' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.045349s ]
SELECT `id` FROM `stock` WHERE `id` <> 58401060 AND `partno` = 'WLG2-LDFS-DTGJS03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.012495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19545107 [ RunTime:0.009005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44507015 LIMIT 5 [ RunTime:0.007102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44507015 ORDER BY `minOrder` ASC [ RunTime:0.005913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44507015 ORDER BY `unit` DESC [ RunTime:0.005055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44507015 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44507015 ORDER BY `minOrder` ASC [ RunTime:0.003606s ]
select * from pdf where partno='WLG2-LDFS-DTGJS-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.019474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDFS-DTGJS-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.005755s ]
SELECT `id` FROM `stock` WHERE `id` <> 44507015 AND `partno` = 'WLG2-LDFS-DTGJS-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.025148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542196 [ RunTime:0.004544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506851 LIMIT 5 [ RunTime:0.009420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506851 ORDER BY `minOrder` ASC [ RunTime:0.004971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506851 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506851 LIMIT 2 [ RunTime:0.007631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506851 ORDER BY `minOrder` ASC [ RunTime:0.005337s ]
select * from pdf where partno='WLG2-LD-M1TGJ' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.007259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-M1TGJ' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.012012s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506851 AND `partno` = 'WLG2-LD-M1TGJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.006986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542191 [ RunTime:0.039799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506720 LIMIT 5 [ RunTime:0.004182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506720 ORDER BY `minOrder` ASC [ RunTime:0.014501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506720 ORDER BY `unit` DESC [ RunTime:0.041128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506720 LIMIT 2 [ RunTime:0.008049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506720 ORDER BY `minOrder` ASC [ RunTime:0.018163s ]
select * from pdf where partno='WLG2-LD-DGJ-N OMR' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.013803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-DGJ-N OMR' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.003783s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506720 AND `partno` = 'WLG2-LD-DGJ-N OMR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.024404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542049 [ RunTime:0.005978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506672 LIMIT 5 [ RunTime:0.016976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506672 ORDER BY `minOrder` ASC [ RunTime:0.046700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506672 ORDER BY `unit` DESC [ RunTime:0.006977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506672 LIMIT 2 [ RunTime:0.007601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506672 ORDER BY `minOrder` ASC [ RunTime:0.008283s ]
select * from pdf where partno='WLG2-LDK43' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.010612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDK43' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.001381s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506672 AND `partno` = 'WLG2-LDK43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.021776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542091 [ RunTime:0.032544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506612 LIMIT 5 [ RunTime:0.013216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506612 ORDER BY `minOrder` ASC [ RunTime:0.013049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506612 ORDER BY `unit` DESC [ RunTime:0.002806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506612 LIMIT 2 [ RunTime:0.020389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506612 ORDER BY `minOrder` ASC [ RunTime:0.009691s ]
select * from pdf where partno='WLG2-LDAS-DGJST-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDAS-DGJST-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.012069s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506612 AND `partno` = 'WLG2-LDAS-DGJST-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.005739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541986 [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506544 LIMIT 5 [ RunTime:0.039923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506544 ORDER BY `minOrder` ASC [ RunTime:0.009369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506544 ORDER BY `unit` DESC [ RunTime:0.000844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506544 LIMIT 2 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506544 ORDER BY `minOrder` ASC [ RunTime:0.011049s ]
select * from pdf where partno='WLG2-LDK43-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.005666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDK43-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506544 AND `partno` = 'WLG2-LDK43-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541968 [ RunTime:0.012142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506543 LIMIT 5 [ RunTime:0.017428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506543 ORDER BY `minOrder` ASC [ RunTime:0.021223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506543 ORDER BY `unit` DESC [ RunTime:0.009645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506543 LIMIT 2 [ RunTime:0.007318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506543 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='WLG2-LDK13-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.003010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDK13-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000766s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506543 AND `partno` = 'WLG2-LDK13-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.007236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541967 [ RunTime:0.004822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506541 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506541 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506541 ORDER BY `unit` DESC [ RunTime:0.008522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506541 LIMIT 2 [ RunTime:0.008684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506541 ORDER BY `minOrder` ASC [ RunTime:0.002350s ]
select * from pdf where partno='WLG2-LD-M1TJB' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-M1TJB' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000821s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506541 AND `partno` = 'WLG2-LD-M1TJB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.005219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542029 [ RunTime:0.003282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506412 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506412 ORDER BY `minOrder` ASC [ RunTime:0.006764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506412 ORDER BY `unit` DESC [ RunTime:0.014648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506412 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506412 ORDER BY `minOrder` ASC [ RunTime:0.015959s ]
select * from pdf where partno='WLG2-LD-M1J-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-M1J-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.020272s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506412 AND `partno` = 'WLG2-LD-M1J-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541912 [ RunTime:0.045336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506400 LIMIT 5 [ RunTime:0.018803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506400 ORDER BY `minOrder` ASC [ RunTime:0.031168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506400 ORDER BY `unit` DESC [ RunTime:0.015553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506400 LIMIT 2 [ RunTime:0.013886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506400 ORDER BY `minOrder` ASC [ RunTime:0.005528s ]
select * from pdf where partno='WLG2-LD-DTGJ03' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.024267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-DTGJ03' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.023875s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506400 AND `partno` = 'WLG2-LD-DTGJ03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.045384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17291036 [ RunTime:0.018411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506148 LIMIT 5 [ RunTime:0.011746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506148 ORDER BY `minOrder` ASC [ RunTime:0.015417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506148 ORDER BY `unit` DESC [ RunTime:0.012565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506148 LIMIT 2 [ RunTime:0.011583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506148 ORDER BY `minOrder` ASC [ RunTime:0.012281s ]
select * from pdf where partno='WLG2-LDK17-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.015530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDK17-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.008499s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506148 AND `partno` = 'WLG2-LDK17-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.007019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17290991 [ RunTime:0.013019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506064 LIMIT 5 [ RunTime:0.019132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506064 ORDER BY `minOrder` ASC [ RunTime:0.027108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506064 ORDER BY `unit` DESC [ RunTime:0.020858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506064 LIMIT 2 [ RunTime:0.011374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506064 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
select * from pdf where partno='WLG2-LDK15-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDK15-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.007796s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506064 AND `partno` = 'WLG2-LDK15-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.011840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17290985 [ RunTime:0.022161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506029 LIMIT 5 [ RunTime:0.008834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506029 ORDER BY `minOrder` ASC [ RunTime:0.013743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506029 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506029 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506029 ORDER BY `minOrder` ASC [ RunTime:0.004341s ]
select * from pdf where partno='WLG2-LDA' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDA' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.003520s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506029 AND `partno` = 'WLG2-LDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541787 [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44506005 LIMIT 5 [ RunTime:0.012167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506005 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44506005 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44506005 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44506005 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
select * from pdf where partno='WLG2-LD-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.005979s ]
SELECT `id` FROM `stock` WHERE `id` <> 44506005 AND `partno` = 'WLG2-LD-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.002795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15434703 [ RunTime:0.002484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44505688 LIMIT 5 [ RunTime:0.014359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44505688 ORDER BY `minOrder` ASC [ RunTime:0.015415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44505688 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44505688 LIMIT 2 [ RunTime:0.001699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44505688 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='WLG2-LDS-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.003943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDS-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.012398s ]
SELECT `id` FROM `stock` WHERE `id` <> 44505688 AND `partno` = 'WLG2-LDS-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.010268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541442 [ RunTime:0.007308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44505423 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44505423 ORDER BY `minOrder` ASC [ RunTime:0.007981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44505423 ORDER BY `unit` DESC [ RunTime:0.005628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44505423 LIMIT 2 [ RunTime:0.002534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44505423 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='WLG2-LDA-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.001531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDA-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000604s ]
SELECT `id` FROM `stock` WHERE `id` <> 44505423 AND `partno` = 'WLG2-LDA-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.000668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19541274 [ RunTime:0.003510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32945154 LIMIT 5 [ RunTime:0.002804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32945154 ORDER BY `minOrder` ASC [ RunTime:0.001888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32945154 ORDER BY `unit` DESC [ RunTime:0.001195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32945154 LIMIT 2 [ RunTime:0.001062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32945154 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='WLG2-LDFS-DTGJS-N' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LDFS-DTGJS-N' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT `id` FROM `stock` WHERE `id` <> 32945154 AND `partno` = 'WLG2-LDFS-DTGJS-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.000839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542196 [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32945008 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32945008 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32945008 ORDER BY `unit` DESC [ RunTime:0.003110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32945008 LIMIT 2 [ RunTime:0.009120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32945008 ORDER BY `minOrder` ASC [ RunTime:0.006168s ]
select * from pdf where partno='WLG2-LD-M1TGJ' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-M1TGJ' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT `id` FROM `stock` WHERE `id` <> 32945008 AND `partno` = 'WLG2-LD-M1TGJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.003247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542191 [ RunTime:0.008413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32944878 LIMIT 5 [ RunTime:0.002268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32944878 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32944878 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32944878 LIMIT 2 [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32944878 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='WLG2-LD-DGJ-N OMR' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLG2-LD-DGJ-N OMR' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.000435s ]
SELECT `id` FROM `stock` WHERE `id` <> 32944878 AND `partno` = 'WLG2-LD-DGJ-N OMR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542049 [ RunTime:0.000340s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001259s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004055s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002924s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002292s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004690s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002610s ]
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 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001341s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WLG2-LD%' OR `brand` LIKE 'WLG2-LD%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005454s ]