SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001373s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016695s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693337 LIMIT 5 [ RunTime:0.006217s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693337 ORDER BY `minOrder` ASC [ RunTime:0.029324s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693337 ORDER BY `unit` DESC [ RunTime:0.020912s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693337 LIMIT 2 [ RunTime:0.007569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693337 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690128 LIMIT 5 [ RunTime:0.032231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690128 ORDER BY `minOrder` ASC [ RunTime:0.027919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690128 ORDER BY `unit` DESC [ RunTime:0.026250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690128 LIMIT 2 [ RunTime:0.041955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690128 ORDER BY `minOrder` ASC [ RunTime:0.024290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690134 LIMIT 5 [ RunTime:0.016424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690134 ORDER BY `minOrder` ASC [ RunTime:0.032496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690134 ORDER BY `unit` DESC [ RunTime:0.014992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690134 LIMIT 2 [ RunTime:0.030988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690134 ORDER BY `minOrder` ASC [ RunTime:0.038044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171370 LIMIT 5 [ RunTime:0.022771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171370 ORDER BY `minOrder` ASC [ RunTime:0.040743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171370 ORDER BY `unit` DESC [ RunTime:0.024124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171370 LIMIT 2 [ RunTime:0.023064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171370 ORDER BY `minOrder` ASC [ RunTime:0.011082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991455 LIMIT 5 [ RunTime:0.038712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991455 ORDER BY `minOrder` ASC [ RunTime:0.013390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991455 ORDER BY `unit` DESC [ RunTime:0.013055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991455 LIMIT 2 [ RunTime:0.014253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991455 ORDER BY `minOrder` ASC [ RunTime:0.013002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693340 LIMIT 5 [ RunTime:0.020500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693340 ORDER BY `minOrder` ASC [ RunTime:0.017858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693340 ORDER BY `unit` DESC [ RunTime:0.007364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693340 LIMIT 2 [ RunTime:0.019532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693340 ORDER BY `minOrder` ASC [ RunTime:0.011219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691225 LIMIT 5 [ RunTime:0.011303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691225 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691225 ORDER BY `unit` DESC [ RunTime:0.005643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691225 LIMIT 2 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691225 ORDER BY `minOrder` ASC [ RunTime:0.003355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691224 LIMIT 5 [ RunTime:0.010202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691224 ORDER BY `minOrder` ASC [ RunTime:0.008542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691224 ORDER BY `unit` DESC [ RunTime:0.008773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691224 LIMIT 2 [ RunTime:0.006436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691224 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690137 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690137 ORDER BY `minOrder` ASC [ RunTime:0.008070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690137 ORDER BY `unit` DESC [ RunTime:0.003972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690137 LIMIT 2 [ RunTime:0.003247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690137 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691232 LIMIT 5 [ RunTime:0.004199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691232 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691232 ORDER BY `unit` DESC [ RunTime:0.006137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691232 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691232 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 26299 LIMIT 5 [ RunTime:0.013217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 26299 ORDER BY `minOrder` ASC [ RunTime:0.018160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 26299 ORDER BY `unit` DESC [ RunTime:0.016493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 26299 LIMIT 2 [ RunTime:0.014671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 26299 ORDER BY `minOrder` ASC [ RunTime:0.002669s ]
select * from pdf where partno='TLP521-2GB' and brandshort='TOSHIBA' limit 1 [ RunTime:0.017802s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GB' OR `brand` LIKE 'TOSHIBA%' ) ) LIMIT 1 [ RunTime:0.007129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24624 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24624 ORDER BY `minOrder` ASC [ RunTime:0.003165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24624 ORDER BY `unit` DESC [ RunTime:0.002080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24624 LIMIT 2 [ RunTime:0.001619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24624 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
select * from pdf where partno='TLP521-2' and brandshort='NA' limit 1 [ RunTime:0.001940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2' OR `brand` LIKE 'NA%' ) ) LIMIT 1 [ RunTime:0.004519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691094 LIMIT 5 [ RunTime:0.003557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691094 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691094 ORDER BY `unit` DESC [ RunTime:0.000791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691094 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691094 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170969 LIMIT 5 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170969 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170969 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170969 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170969 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691189 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691189 ORDER BY `minOrder` ASC [ RunTime:0.003620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691189 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691189 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691189 ORDER BY `minOrder` ASC [ RunTime:0.006559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691100 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691100 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691100 ORDER BY `unit` DESC [ RunTime:0.000395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691100 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691100 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171056 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171056 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171056 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171056 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171056 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691708 LIMIT 5 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691708 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691708 ORDER BY `unit` DESC [ RunTime:0.002467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691708 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691708 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693230 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693230 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693230 ORDER BY `unit` DESC [ RunTime:0.001128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693230 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693230 ORDER BY `minOrder` ASC [ RunTime:0.001998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693201 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693201 ORDER BY `minOrder` ASC [ RunTime:0.003275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693201 ORDER BY `unit` DESC [ RunTime:0.002280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693201 LIMIT 2 [ RunTime:0.001190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693201 ORDER BY `minOrder` ASC [ RunTime:0.001094s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003337s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57449668 LIMIT 5 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57449668 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57449668 ORDER BY `unit` DESC [ RunTime:0.001551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57449668 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57449668 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='TLP521-2GB' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.002439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GB' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006760s ]
SELECT `id` FROM `stock` WHERE `id` <> 57449668 AND `partno` = 'TLP521-2GB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693337 [ RunTime:0.003590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450691 LIMIT 5 [ RunTime:0.002945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450691 ORDER BY `minOrder` ASC [ RunTime:0.003364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450691 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450691 LIMIT 2 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450691 ORDER BY `minOrder` ASC [ RunTime:0.005407s ]
select * from pdf where partno='TLP521-2XGR' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGR' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.007667s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450691 AND `partno` = 'TLP521-2XGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690128 [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450713 LIMIT 5 [ RunTime:0.004524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450713 ORDER BY `minOrder` ASC [ RunTime:0.007723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450713 ORDER BY `unit` DESC [ RunTime:0.007179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450713 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450713 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
select * from pdf where partno='TLP521-2XG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.002576s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450713 AND `partno` = 'TLP521-2XG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690134 [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57449527 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57449527 ORDER BY `minOrder` ASC [ RunTime:0.008815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57449527 ORDER BY `unit` DESC [ RunTime:0.003437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57449527 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57449527 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='TLP521-2XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.001895s ]
SELECT `id` FROM `stock` WHERE `id` <> 57449527 AND `partno` = 'TLP521-2XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690599 [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57451725 LIMIT 5 [ RunTime:0.005185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451725 ORDER BY `minOrder` ASC [ RunTime:0.000986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57451725 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57451725 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451725 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='TLP521-2X' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2X' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.004382s ]
SELECT `id` FROM `stock` WHERE `id` <> 57451725 AND `partno` = 'TLP521-2X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.009032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693340 [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57451726 LIMIT 5 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451726 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57451726 ORDER BY `unit` DESC [ RunTime:0.000938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57451726 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451726 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='TLP521-2XGB' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGB' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.004007s ]
SELECT `id` FROM `stock` WHERE `id` <> 57451726 AND `partno` = 'TLP521-2XGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.009410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171370 [ RunTime:0.005762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57451917 LIMIT 5 [ RunTime:0.001492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451917 ORDER BY `minOrder` ASC [ RunTime:0.001237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57451917 ORDER BY `unit` DESC [ RunTime:0.003904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57451917 LIMIT 2 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57451917 ORDER BY `minOrder` ASC [ RunTime:0.008130s ]
select * from pdf where partno='TLP521-2XGRSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGRSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.001025s ]
SELECT `id` FROM `stock` WHERE `id` <> 57451917 AND `partno` = 'TLP521-2XGRSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690137 [ RunTime:0.007271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450733 LIMIT 5 [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450733 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450733 ORDER BY `unit` DESC [ RunTime:0.006513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450733 LIMIT 2 [ RunTime:0.001592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450733 ORDER BY `minOrder` ASC [ RunTime:0.004856s ]
select * from pdf where partno='TLP521-2XGBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006411s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450733 AND `partno` = 'TLP521-2XGBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.020812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991455 [ RunTime:0.007468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450735 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450735 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450735 ORDER BY `unit` DESC [ RunTime:0.009561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450735 LIMIT 2 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450735 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
select * from pdf where partno='TLP521-2XSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.007304s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450735 AND `partno` = 'TLP521-2XSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691232 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57452521 LIMIT 5 [ RunTime:0.005086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452521 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57452521 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57452521 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452521 ORDER BY `minOrder` ASC [ RunTime:0.000887s ]
select * from pdf where partno='TLP521-2XBLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XBLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000517s ]
SELECT `id` FROM `stock` WHERE `id` <> 57452521 AND `partno` = 'TLP521-2XBLSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170969 [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57452507 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452507 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57452507 ORDER BY `unit` DESC [ RunTime:0.004365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57452507 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452507 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
select * from pdf where partno='TLP521-2XGRG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGRG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000554s ]
SELECT `id` FROM `stock` WHERE `id` <> 57452507 AND `partno` = 'TLP521-2XGRG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.008100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691094 [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57452543 LIMIT 5 [ RunTime:0.001266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452543 ORDER BY `minOrder` ASC [ RunTime:0.007411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57452543 ORDER BY `unit` DESC [ RunTime:0.006263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57452543 LIMIT 2 [ RunTime:0.001035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57452543 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='TLP521-2XBLG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.007346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XBLG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000612s ]
SELECT `id` FROM `stock` WHERE `id` <> 57452543 AND `partno` = 'TLP521-2XBLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.008063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691189 [ RunTime:0.002530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57453135 LIMIT 5 [ RunTime:0.011993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57453135 ORDER BY `minOrder` ASC [ RunTime:0.004795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57453135 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57453135 LIMIT 2 [ RunTime:0.008188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57453135 ORDER BY `minOrder` ASC [ RunTime:0.002952s ]
select * from pdf where partno='TLP521-2XGBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006256s ]
SELECT `id` FROM `stock` WHERE `id` <> 57453135 AND `partno` = 'TLP521-2XGBSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691100 [ RunTime:0.001267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57453136 LIMIT 5 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57453136 ORDER BY `minOrder` ASC [ RunTime:0.004991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57453136 ORDER BY `unit` DESC [ RunTime:0.004196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57453136 LIMIT 2 [ RunTime:0.016231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57453136 ORDER BY `minOrder` ASC [ RunTime:0.001747s ]
select * from pdf where partno='TLP521-2XGBG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.010619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2XGBG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010184s ]
SELECT `id` FROM `stock` WHERE `id` <> 57453136 AND `partno` = 'TLP521-2XGBG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.020074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171056 [ RunTime:0.002950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456649 LIMIT 5 [ RunTime:0.003221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456649 ORDER BY `minOrder` ASC [ RunTime:0.014774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456649 ORDER BY `unit` DESC [ RunTime:0.002020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456649 LIMIT 2 [ RunTime:0.001538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456649 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
select * from pdf where partno='TLP521-2GBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006502s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456649 AND `partno` = 'TLP521-2GBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.003435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693230 [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456627 LIMIT 5 [ RunTime:0.001771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456627 ORDER BY `minOrder` ASC [ RunTime:0.005369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456627 ORDER BY `unit` DESC [ RunTime:0.008623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456627 LIMIT 2 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456627 ORDER BY `minOrder` ASC [ RunTime:0.001442s ]
select * from pdf where partno='TLP521-2GRSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.010347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GRSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.029594s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456627 AND `partno` = 'TLP521-2GRSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.012112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171348 [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456605 LIMIT 5 [ RunTime:0.017733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456605 ORDER BY `minOrder` ASC [ RunTime:0.003752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456605 ORDER BY `unit` DESC [ RunTime:0.005230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456605 LIMIT 2 [ RunTime:0.001981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456605 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
select * from pdf where partno='TLP521-2BLSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2BLSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.003885s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456605 AND `partno` = 'TLP521-2BLSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.003262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693201 [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456323 LIMIT 5 [ RunTime:0.011639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456323 ORDER BY `minOrder` ASC [ RunTime:0.007041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456323 ORDER BY `unit` DESC [ RunTime:0.009117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456323 LIMIT 2 [ RunTime:0.004013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456323 ORDER BY `minOrder` ASC [ RunTime:0.002908s ]
select * from pdf where partno='TLP521-2GRSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GRSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.009217s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456323 AND `partno` = 'TLP521-2GRSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.044724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693105 [ RunTime:0.010721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456307 LIMIT 5 [ RunTime:0.008505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456307 ORDER BY `minOrder` ASC [ RunTime:0.005968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456307 ORDER BY `unit` DESC [ RunTime:0.002900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456307 LIMIT 2 [ RunTime:0.008506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456307 ORDER BY `minOrder` ASC [ RunTime:0.004731s ]
select * from pdf where partno='TLP521-2GBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.014900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2GBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.014854s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456307 AND `partno` = 'TLP521-2GBSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.023720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693095 [ RunTime:0.003979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456306 LIMIT 5 [ RunTime:0.016148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456306 ORDER BY `minOrder` ASC [ RunTime:0.000904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456306 ORDER BY `unit` DESC [ RunTime:0.005888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456306 LIMIT 2 [ RunTime:0.021176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456306 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
select * from pdf where partno='TLP521-2SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.021056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-2SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.008462s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456306 AND `partno` = 'TLP521-2SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.013363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693094 [ RunTime:0.032495s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010683s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017047s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014125s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001465s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020154s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008281s ]
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 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006650s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TLP521-2%' OR `brand` LIKE 'TLP521-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006790s ]