SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001806s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003498s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848423 LIMIT 5 [ RunTime:0.010878s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848423 ORDER BY `minOrder` ASC [ RunTime:0.003943s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18848423 ORDER BY `unit` DESC [ RunTime:0.001667s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18848423 LIMIT 2 [ RunTime:0.003692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848423 ORDER BY `minOrder` ASC [ RunTime:0.006356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848394 LIMIT 5 [ RunTime:0.003894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848394 ORDER BY `minOrder` ASC [ RunTime:0.005976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18848394 ORDER BY `unit` DESC [ RunTime:0.007535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18848394 LIMIT 2 [ RunTime:0.002540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848394 ORDER BY `minOrder` ASC [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848318 LIMIT 5 [ RunTime:0.003720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848318 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18848318 ORDER BY `unit` DESC [ RunTime:0.004364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18848318 LIMIT 2 [ RunTime:0.010391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18848318 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14186357 LIMIT 5 [ RunTime:0.010292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186357 ORDER BY `minOrder` ASC [ RunTime:0.006288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14186357 ORDER BY `unit` DESC [ RunTime:0.009182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14186357 LIMIT 2 [ RunTime:0.001664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186357 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001634s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266751 LIMIT 5 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266751 ORDER BY `minOrder` ASC [ RunTime:0.004199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266751 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266751 LIMIT 2 [ RunTime:0.001323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266751 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
select * from pdf where partno='CN8202-R1-R2-LV-C2' and brandshort='Omega' limit 1 [ RunTime:0.010201s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-C2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.014940s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266751 AND `partno` = 'CN8202-R1-R2-LV-C2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.006078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266737 LIMIT 5 [ RunTime:0.002659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266737 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266737 ORDER BY `unit` DESC [ RunTime:0.001630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266737 LIMIT 2 [ RunTime:0.002296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266737 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
select * from pdf where partno='CN8202-R1-R2-LV-C4MP4' and brandshort='Omega' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-C4MP4' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.009914s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266737 AND `partno` = 'CN8202-R1-R2-LV-C4MP4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.006014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266736 LIMIT 5 [ RunTime:0.003041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266736 ORDER BY `minOrder` ASC [ RunTime:0.006844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266736 ORDER BY `unit` DESC [ RunTime:0.000791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266736 LIMIT 2 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266736 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
select * from pdf where partno='CN8202-R1-R2-LV-C4MP2' and brandshort='Omega' limit 1 [ RunTime:0.002527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-C4MP2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.003509s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266736 AND `partno` = 'CN8202-R1-R2-LV-C4MP2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.004732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266735 LIMIT 5 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266735 ORDER BY `minOrder` ASC [ RunTime:0.001896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266735 ORDER BY `unit` DESC [ RunTime:0.002891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266735 LIMIT 2 [ RunTime:0.001725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266735 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
select * from pdf where partno='CN8202-R1-R2-LV-C4MP1' and brandshort='Omega' limit 1 [ RunTime:0.000992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-C4MP1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.004622s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266735 AND `partno` = 'CN8202-R1-R2-LV-C4MP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266729 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266729 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266729 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266729 LIMIT 2 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266729 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
select * from pdf where partno='CN8202-R1-R2-LV-C4MP3' and brandshort='Omega' limit 1 [ RunTime:0.000831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-C4MP3' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.003241s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266729 AND `partno` = 'CN8202-R1-R2-LV-C4MP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266548 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266548 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266548 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266548 LIMIT 2 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266548 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
select * from pdf where partno='CN8202-R1-R2-C2' and brandshort='Omega' limit 1 [ RunTime:0.001980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000942s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266548 AND `partno` = 'CN8202-R1-R2-C2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848423 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266216 LIMIT 5 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266216 ORDER BY `minOrder` ASC [ RunTime:0.002854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266216 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266216 LIMIT 2 [ RunTime:0.002439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266216 ORDER BY `minOrder` ASC [ RunTime:0.002643s ]
select * from pdf where partno='CN8202-R1-R2-232' and brandshort='Omega' limit 1 [ RunTime:0.002495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-232' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000836s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266216 AND `partno` = 'CN8202-R1-R2-232' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57266215 LIMIT 5 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266215 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57266215 ORDER BY `unit` DESC [ RunTime:0.000568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57266215 LIMIT 2 [ RunTime:0.000948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57266215 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
select * from pdf where partno='CN8202-R1-R2-RSP1' and brandshort='Omega' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-RSP1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001559s ]
SELECT `id` FROM `stock` WHERE `id` <> 57266215 AND `partno` = 'CN8202-R1-R2-RSP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848394 [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265985 LIMIT 5 [ RunTime:0.001410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265985 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265985 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265985 LIMIT 2 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265985 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
select * from pdf where partno='CN8202-R1-R2-PVSV1' and brandshort='Omega' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-PVSV1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002302s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265985 AND `partno` = 'CN8202-R1-R2-PVSV1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265927 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265927 ORDER BY `minOrder` ASC [ RunTime:0.001047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265927 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265927 LIMIT 2 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265927 ORDER BY `minOrder` ASC [ RunTime:0.000818s ]
select * from pdf where partno='CN8202-R1-R2-LV-PVSV1' and brandshort='Omega' limit 1 [ RunTime:0.000856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-PVSV1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002996s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265927 AND `partno` = 'CN8202-R1-R2-LV-PVSV1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265626 LIMIT 5 [ RunTime:0.000912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265626 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265626 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265626 LIMIT 2 [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265626 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
select * from pdf where partno='CN8202-R1-R2-C4MP4' and brandshort='Omega' limit 1 [ RunTime:0.000695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C4MP4' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001918s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265626 AND `partno` = 'CN8202-R1-R2-C4MP4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265622 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265622 ORDER BY `minOrder` ASC [ RunTime:0.000960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265622 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265622 LIMIT 2 [ RunTime:0.001094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265622 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
select * from pdf where partno='CN8202-R1-R2-C4MP2' and brandshort='Omega' limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C4MP2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001977s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265622 AND `partno` = 'CN8202-R1-R2-C4MP2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265618 LIMIT 5 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265618 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265618 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265618 LIMIT 2 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265618 ORDER BY `minOrder` ASC [ RunTime:0.000920s ]
select * from pdf where partno='CN8202-R1-R2-C4MP3' and brandshort='Omega' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C4MP3' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001847s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265618 AND `partno` = 'CN8202-R1-R2-C4MP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265613 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265613 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265613 ORDER BY `unit` DESC [ RunTime:0.003369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265613 LIMIT 2 [ RunTime:0.001303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265613 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
select * from pdf where partno='CN8202-R1-R2-C4MP1' and brandshort='Omega' limit 1 [ RunTime:0.002986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C4MP1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001866s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265613 AND `partno` = 'CN8202-R1-R2-C4MP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265611 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265611 ORDER BY `minOrder` ASC [ RunTime:0.001326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265611 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265611 LIMIT 2 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265611 ORDER BY `minOrder` ASC [ RunTime:0.000967s ]
select * from pdf where partno='CN8202-R1-R2-C4' and brandshort='Omega' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-C4' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007655s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265611 AND `partno` = 'CN8202-R1-R2-C4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265491 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265491 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265491 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265491 LIMIT 2 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265491 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
select * from pdf where partno='CN8202-R1-R2' and brandshort='Omega' limit 1 [ RunTime:0.001144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001091s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265491 AND `partno` = 'CN8202-R1-R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18848318 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265343 LIMIT 5 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265343 ORDER BY `minOrder` ASC [ RunTime:0.004486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265343 ORDER BY `unit` DESC [ RunTime:0.003745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265343 LIMIT 2 [ RunTime:0.002362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265343 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
select * from pdf where partno='CN8202-R1-R2-LV-AL3' and brandshort='Omega' limit 1 [ RunTime:0.004294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-AL3' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007602s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265343 AND `partno` = 'CN8202-R1-R2-LV-AL3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.010338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265342 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265342 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265342 ORDER BY `unit` DESC [ RunTime:0.002192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265342 LIMIT 2 [ RunTime:0.002927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265342 ORDER BY `minOrder` ASC [ RunTime:0.004183s ]
select * from pdf where partno='CN8202-R1-R2-LV-AL1' and brandshort='Omega' limit 1 [ RunTime:0.006156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-LV-AL1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007332s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265342 AND `partno` = 'CN8202-R1-R2-LV-AL1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265276 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265276 ORDER BY `minOrder` ASC [ RunTime:0.003019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265276 ORDER BY `unit` DESC [ RunTime:0.002075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265276 LIMIT 2 [ RunTime:0.003120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265276 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
select * from pdf where partno='CN8202-R1-R2-AL2' and brandshort='Omega' limit 1 [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-AL2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002849s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265276 AND `partno` = 'CN8202-R1-R2-AL2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57265265 LIMIT 5 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265265 ORDER BY `minOrder` ASC [ RunTime:0.007351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57265265 ORDER BY `unit` DESC [ RunTime:0.005433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57265265 LIMIT 2 [ RunTime:0.007808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57265265 ORDER BY `minOrder` ASC [ RunTime:0.002299s ]
select * from pdf where partno='CN8202-R1-R2-XP3' and brandshort='Omega' limit 1 [ RunTime:0.001528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CN8202-R1-R2-XP3' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.006178s ]
SELECT `id` FROM `stock` WHERE `id` <> 57265265 AND `partno` = 'CN8202-R1-R2-XP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.007533s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002116s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001745s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003690s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001047s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001978s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001039s ]
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 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005524s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CN8202-R1-R2%' OR `brand` LIKE 'CN8202-R1-R2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002275s ]