SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002741s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.149659s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17283524 LIMIT 5 [ RunTime:0.045924s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17283524 ORDER BY `minOrder` ASC [ RunTime:0.026262s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17283524 ORDER BY `unit` DESC [ RunTime:0.020726s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17283524 LIMIT 2 [ RunTime:0.018709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17283524 ORDER BY `minOrder` ASC [ RunTime:0.016767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17283288 LIMIT 5 [ RunTime:0.036265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17283288 ORDER BY `minOrder` ASC [ RunTime:0.015892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17283288 ORDER BY `unit` DESC [ RunTime:0.062991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17283288 LIMIT 2 [ RunTime:0.028245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17283288 ORDER BY `minOrder` ASC [ RunTime:0.031605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17282941 LIMIT 5 [ RunTime:0.043533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17282941 ORDER BY `minOrder` ASC [ RunTime:0.029667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17282941 ORDER BY `unit` DESC [ RunTime:0.022928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17282941 LIMIT 2 [ RunTime:0.075829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17282941 ORDER BY `minOrder` ASC [ RunTime:0.015984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456906 LIMIT 5 [ RunTime:0.063186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456906 ORDER BY `minOrder` ASC [ RunTime:0.040560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12456906 ORDER BY `unit` DESC [ RunTime:0.057352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12456906 LIMIT 2 [ RunTime:0.064639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456906 ORDER BY `minOrder` ASC [ RunTime:0.021675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12438549 LIMIT 5 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12438549 ORDER BY `minOrder` ASC [ RunTime:0.070250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12438549 ORDER BY `unit` DESC [ RunTime:0.029820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12438549 LIMIT 2 [ RunTime:0.062414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12438549 ORDER BY `minOrder` ASC [ RunTime:0.019871s ]
select * from pdf where partno='52PM8A4D' and brandshort='Siemens' limit 1 [ RunTime:0.049204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12436770 LIMIT 5 [ RunTime:0.075272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12436770 ORDER BY `minOrder` ASC [ RunTime:0.103304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12436770 ORDER BY `unit` DESC [ RunTime:0.039301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12436770 LIMIT 2 [ RunTime:0.044912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12436770 ORDER BY `minOrder` ASC [ RunTime:0.126983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12436653 LIMIT 5 [ RunTime:0.028171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12436653 ORDER BY `minOrder` ASC [ RunTime:0.046947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12436653 ORDER BY `unit` DESC [ RunTime:0.020564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12436653 LIMIT 2 [ RunTime:0.014743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12436653 ORDER BY `minOrder` ASC [ RunTime:0.011794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12434508 LIMIT 5 [ RunTime:0.009108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434508 ORDER BY `minOrder` ASC [ RunTime:0.008590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12434508 ORDER BY `unit` DESC [ RunTime:0.008160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12434508 LIMIT 2 [ RunTime:0.027499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434508 ORDER BY `minOrder` ASC [ RunTime:0.021432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12434506 LIMIT 5 [ RunTime:0.011192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434506 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12434506 ORDER BY `unit` DESC [ RunTime:0.009248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12434506 LIMIT 2 [ RunTime:0.022856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434506 ORDER BY `minOrder` ASC [ RunTime:0.016639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12434505 LIMIT 5 [ RunTime:0.010160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434505 ORDER BY `minOrder` ASC [ RunTime:0.009915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12434505 ORDER BY `unit` DESC [ RunTime:0.012416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12434505 LIMIT 2 [ RunTime:0.006732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434505 ORDER BY `minOrder` ASC [ RunTime:0.014083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12434495 LIMIT 5 [ RunTime:0.029774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434495 ORDER BY `minOrder` ASC [ RunTime:0.005366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12434495 ORDER BY `unit` DESC [ RunTime:0.001305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12434495 LIMIT 2 [ RunTime:0.006969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12434495 ORDER BY `minOrder` ASC [ RunTime:0.012168s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005539s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58454845 LIMIT 5 [ RunTime:0.022474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58454845 ORDER BY `minOrder` ASC [ RunTime:0.031535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58454845 ORDER BY `unit` DESC [ RunTime:0.018520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58454845 LIMIT 2 [ RunTime:0.009997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58454845 ORDER BY `minOrder` ASC [ RunTime:0.004223s ]
select * from pdf where partno='52PM8A4' and brandshort='Siemens' limit 1 [ RunTime:0.018685s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.015864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43883462 LIMIT 5 [ RunTime:0.015201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43883462 ORDER BY `minOrder` ASC [ RunTime:0.014229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43883462 ORDER BY `unit` DESC [ RunTime:0.013776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43883462 LIMIT 2 [ RunTime:0.014781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43883462 ORDER BY `minOrder` ASC [ RunTime:0.013749s ]
select * from pdf where partno='52PM8A4D' and brandshort='Siemens' limit 1 [ RunTime:0.003397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4D' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.048419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43882744 LIMIT 5 [ RunTime:0.027014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43882744 ORDER BY `minOrder` ASC [ RunTime:0.012252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43882744 ORDER BY `unit` DESC [ RunTime:0.019488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43882744 LIMIT 2 [ RunTime:0.034422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43882744 ORDER BY `minOrder` ASC [ RunTime:0.027563s ]
select * from pdf where partno='52PM8A4C' and brandshort='Siemens' limit 1 [ RunTime:0.032933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4C' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.029754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43882059 LIMIT 5 [ RunTime:0.033796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43882059 ORDER BY `minOrder` ASC [ RunTime:0.035815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43882059 ORDER BY `unit` DESC [ RunTime:0.024110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43882059 LIMIT 2 [ RunTime:0.032555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43882059 ORDER BY `minOrder` ASC [ RunTime:0.012011s ]
select * from pdf where partno='52PM8A4B' and brandshort='Siemens' limit 1 [ RunTime:0.017524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4B' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.017284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43880635 LIMIT 5 [ RunTime:0.037442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880635 ORDER BY `minOrder` ASC [ RunTime:0.034291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43880635 ORDER BY `unit` DESC [ RunTime:0.010332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43880635 LIMIT 2 [ RunTime:0.055095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880635 ORDER BY `minOrder` ASC [ RunTime:0.048390s ]
select * from pdf where partno='52PM8A4G' and brandshort='Siemens' limit 1 [ RunTime:0.043444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4G' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.011469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43880634 LIMIT 5 [ RunTime:0.044087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880634 ORDER BY `minOrder` ASC [ RunTime:0.046004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43880634 ORDER BY `unit` DESC [ RunTime:0.021529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43880634 LIMIT 2 [ RunTime:0.074642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880634 ORDER BY `minOrder` ASC [ RunTime:0.033444s ]
select * from pdf where partno='52PM8A4F' and brandshort='Siemens' limit 1 [ RunTime:0.084860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4F' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.021731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43880521 LIMIT 5 [ RunTime:0.027194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880521 ORDER BY `minOrder` ASC [ RunTime:0.022840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43880521 ORDER BY `unit` DESC [ RunTime:0.028700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43880521 LIMIT 2 [ RunTime:0.040083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43880521 ORDER BY `minOrder` ASC [ RunTime:0.071612s ]
select * from pdf where partno='52PM8A4A' and brandshort='Siemens' limit 1 [ RunTime:0.038527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4A' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.040914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43879443 LIMIT 5 [ RunTime:0.094001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879443 ORDER BY `minOrder` ASC [ RunTime:0.047106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43879443 ORDER BY `unit` DESC [ RunTime:0.036531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43879443 LIMIT 2 [ RunTime:0.004163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879443 ORDER BY `minOrder` ASC [ RunTime:0.007102s ]
select * from pdf where partno='52PM8A4K' and brandshort='Siemens' limit 1 [ RunTime:0.051837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4K' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.055497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43879438 LIMIT 5 [ RunTime:0.023525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879438 ORDER BY `minOrder` ASC [ RunTime:0.042874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43879438 ORDER BY `unit` DESC [ RunTime:0.046673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43879438 LIMIT 2 [ RunTime:0.050936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879438 ORDER BY `minOrder` ASC [ RunTime:0.056011s ]
select * from pdf where partno='52PM8A4E' and brandshort='Siemens' limit 1 [ RunTime:0.052941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4E' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.079339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43879427 LIMIT 5 [ RunTime:0.075528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879427 ORDER BY `minOrder` ASC [ RunTime:0.053708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43879427 ORDER BY `unit` DESC [ RunTime:0.086431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43879427 LIMIT 2 [ RunTime:0.023632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879427 ORDER BY `minOrder` ASC [ RunTime:0.020298s ]
select * from pdf where partno='52PM8A4H' and brandshort='Siemens' limit 1 [ RunTime:0.084211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4H' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.051056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43879409 LIMIT 5 [ RunTime:0.049260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879409 ORDER BY `minOrder` ASC [ RunTime:0.035156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43879409 ORDER BY `unit` DESC [ RunTime:0.029890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43879409 LIMIT 2 [ RunTime:0.036848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43879409 ORDER BY `minOrder` ASC [ RunTime:0.023149s ]
select * from pdf where partno='52PM8A4J' and brandshort='Siemens' limit 1 [ RunTime:0.056709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52PM8A4J' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.026082s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017520s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032056s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020847s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021353s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081867s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027064s ]
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 '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022643s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '52PM8A4%' OR `brand` LIKE '52PM8A4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019485s ]