SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002666s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016899s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634484 LIMIT 5 [ RunTime:0.001768s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634484 ORDER BY `minOrder` ASC [ RunTime:0.010688s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634484 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634484 LIMIT 2 [ RunTime:0.009950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634484 ORDER BY `minOrder` ASC [ RunTime:0.010538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448198 LIMIT 5 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448198 ORDER BY `minOrder` ASC [ RunTime:0.013172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448198 ORDER BY `unit` DESC [ RunTime:0.007853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448198 LIMIT 2 [ RunTime:0.004892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448198 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552859 LIMIT 5 [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552859 ORDER BY `minOrder` ASC [ RunTime:0.025960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12552859 ORDER BY `unit` DESC [ RunTime:0.043580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12552859 LIMIT 2 [ RunTime:0.018412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552859 ORDER BY `minOrder` ASC [ RunTime:0.027596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552576 LIMIT 5 [ RunTime:0.022722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552576 ORDER BY `minOrder` ASC [ RunTime:0.027796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12552576 ORDER BY `unit` DESC [ RunTime:0.017957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12552576 LIMIT 2 [ RunTime:0.022464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552576 ORDER BY `minOrder` ASC [ RunTime:0.005560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12551717 LIMIT 5 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12551717 ORDER BY `minOrder` ASC [ RunTime:0.026938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12551717 ORDER BY `unit` DESC [ RunTime:0.027934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12551717 LIMIT 2 [ RunTime:0.023159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12551717 ORDER BY `minOrder` ASC [ RunTime:0.022976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12550805 LIMIT 5 [ RunTime:0.020487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12550805 ORDER BY `minOrder` ASC [ RunTime:0.017783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12550805 ORDER BY `unit` DESC [ RunTime:0.022850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12550805 LIMIT 2 [ RunTime:0.003837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12550805 ORDER BY `minOrder` ASC [ RunTime:0.004739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11440201 LIMIT 5 [ RunTime:0.030327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11440201 ORDER BY `minOrder` ASC [ RunTime:0.011905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11440201 ORDER BY `unit` DESC [ RunTime:0.012440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11440201 LIMIT 2 [ RunTime:0.016709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11440201 ORDER BY `minOrder` ASC [ RunTime:0.002509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439544 LIMIT 5 [ RunTime:0.019000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439544 ORDER BY `minOrder` ASC [ RunTime:0.015804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11439544 ORDER BY `unit` DESC [ RunTime:0.013023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11439544 LIMIT 2 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439544 ORDER BY `minOrder` ASC [ RunTime:0.004806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438957 LIMIT 5 [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438957 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11438957 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11438957 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438957 ORDER BY `minOrder` ASC [ RunTime:0.002521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438594 LIMIT 5 [ RunTime:0.000984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438594 ORDER BY `minOrder` ASC [ RunTime:0.006196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11438594 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11438594 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438594 ORDER BY `minOrder` ASC [ RunTime:0.001750s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002567s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53769375 LIMIT 5 [ RunTime:0.004289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53769375 ORDER BY `minOrder` ASC [ RunTime:0.001358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53769375 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53769375 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53769375 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='38.2119' and brandshort='Altech Corporation' limit 1 [ RunTime:0.007143s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2119' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.002897s ]
SELECT `id` FROM `stock` WHERE `id` <> 53769375 AND `partno` = '38.2119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.005248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552859 [ RunTime:0.016292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53768821 LIMIT 5 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53768821 ORDER BY `minOrder` ASC [ RunTime:0.007779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53768821 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53768821 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53768821 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='38.2118' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2118' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.004222s ]
SELECT `id` FROM `stock` WHERE `id` <> 53768821 AND `partno` = '38.2118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.006318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552576 [ RunTime:0.000714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53768293 LIMIT 5 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53768293 ORDER BY `minOrder` ASC [ RunTime:0.006699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53768293 ORDER BY `unit` DESC [ RunTime:0.002414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53768293 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53768293 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='38.2117' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2117' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.002948s ]
SELECT `id` FROM `stock` WHERE `id` <> 53768293 AND `partno` = '38.2117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.005172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11440201 [ RunTime:0.010243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53767720 LIMIT 5 [ RunTime:0.004158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767720 ORDER BY `minOrder` ASC [ RunTime:0.008660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53767720 ORDER BY `unit` DESC [ RunTime:0.003188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53767720 LIMIT 2 [ RunTime:0.022322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767720 ORDER BY `minOrder` ASC [ RunTime:0.003184s ]
select * from pdf where partno='38.2116' and brandshort='Altech Corporation' limit 1 [ RunTime:0.012370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2116' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.003818s ]
SELECT `id` FROM `stock` WHERE `id` <> 53767720 AND `partno` = '38.2116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53767060 LIMIT 5 [ RunTime:0.002646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767060 ORDER BY `minOrder` ASC [ RunTime:0.008067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53767060 ORDER BY `unit` DESC [ RunTime:0.010186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53767060 LIMIT 2 [ RunTime:0.016220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767060 ORDER BY `minOrder` ASC [ RunTime:0.007099s ]
select * from pdf where partno='38.2115' and brandshort='Altech Corporation' limit 1 [ RunTime:0.006623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2115' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.025896s ]
SELECT `id` FROM `stock` WHERE `id` <> 53767060 AND `partno` = '38.2115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12551717 [ RunTime:0.009294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53766335 LIMIT 5 [ RunTime:0.008264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53766335 ORDER BY `minOrder` ASC [ RunTime:0.001800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53766335 ORDER BY `unit` DESC [ RunTime:0.005706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53766335 LIMIT 2 [ RunTime:0.024109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53766335 ORDER BY `minOrder` ASC [ RunTime:0.001297s ]
select * from pdf where partno='38.2114' and brandshort='Altech Corporation' limit 1 [ RunTime:0.002733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2114' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.013717s ]
SELECT `id` FROM `stock` WHERE `id` <> 53766335 AND `partno` = '38.2114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439544 [ RunTime:0.013848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53765410 LIMIT 5 [ RunTime:0.013059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53765410 ORDER BY `minOrder` ASC [ RunTime:0.005771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53765410 ORDER BY `unit` DESC [ RunTime:0.012005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53765410 LIMIT 2 [ RunTime:0.009564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53765410 ORDER BY `minOrder` ASC [ RunTime:0.005841s ]
select * from pdf where partno='38.2113' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2113' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.007140s ]
SELECT `id` FROM `stock` WHERE `id` <> 53765410 AND `partno` = '38.2113' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.012764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12550805 [ RunTime:0.009725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53764390 LIMIT 5 [ RunTime:0.009384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53764390 ORDER BY `minOrder` ASC [ RunTime:0.020117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53764390 ORDER BY `unit` DESC [ RunTime:0.001781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53764390 LIMIT 2 [ RunTime:0.003687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53764390 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='38.2112' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2112' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.003229s ]
SELECT `id` FROM `stock` WHERE `id` <> 53764390 AND `partno` = '38.2112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.001107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438957 [ RunTime:0.000404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53763275 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53763275 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53763275 ORDER BY `unit` DESC [ RunTime:0.001828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53763275 LIMIT 2 [ RunTime:0.005570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53763275 ORDER BY `minOrder` ASC [ RunTime:0.007690s ]
select * from pdf where partno='38.2111' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2111' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.001140s ]
SELECT `id` FROM `stock` WHERE `id` <> 53763275 AND `partno` = '38.2111' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.014725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438594 [ RunTime:0.002793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53704760 LIMIT 5 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704760 ORDER BY `minOrder` ASC [ RunTime:0.015420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53704760 ORDER BY `unit` DESC [ RunTime:0.007152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53704760 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704760 ORDER BY `minOrder` ASC [ RunTime:0.006059s ]
select * from pdf where partno='38.2110' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.2110' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.005311s ]
SELECT `id` FROM `stock` WHERE `id` <> 53704760 AND `partno` = '38.2110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.015414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634484 [ RunTime:0.004235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53700833 LIMIT 5 [ RunTime:0.009514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700833 ORDER BY `minOrder` ASC [ RunTime:0.005601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53700833 ORDER BY `unit` DESC [ RunTime:0.004229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53700833 LIMIT 2 [ RunTime:0.012373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700833 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
select * from pdf where partno='38.211' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '38.211' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.001018s ]
SELECT `id` FROM `stock` WHERE `id` <> 53700833 AND `partno` = '38.211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.024880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448198 [ RunTime:0.016670s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015856s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001485s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004044s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004304s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011806s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005273s ]
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 '38.211%' OR `brand` LIKE '38.211%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001432s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '38.211%' OR `brand` LIKE '38.211%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001714s ]