SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002359s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005842s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14264703 LIMIT 5 [ RunTime:0.020659s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14264703 ORDER BY `minOrder` ASC [ RunTime:0.021526s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.028753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14264703 ORDER BY `unit` DESC [ RunTime:0.021764s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14264703 LIMIT 2 [ RunTime:0.035976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14264703 ORDER BY `minOrder` ASC [ RunTime:0.084728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266546 LIMIT 5 [ RunTime:0.067126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266546 ORDER BY `minOrder` ASC [ RunTime:0.041081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14266546 ORDER BY `unit` DESC [ RunTime:0.055437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14266546 LIMIT 2 [ RunTime:0.113932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266546 ORDER BY `minOrder` ASC [ RunTime:0.040642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380087 LIMIT 5 [ RunTime:0.033265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13380087 ORDER BY `minOrder` ASC [ RunTime:0.064471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13380087 ORDER BY `unit` DESC [ RunTime:0.095140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13380087 LIMIT 2 [ RunTime:0.086935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13380087 ORDER BY `minOrder` ASC [ RunTime:0.030542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380086 LIMIT 5 [ RunTime:0.065807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13380086 ORDER BY `minOrder` ASC [ RunTime:0.096627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13380086 ORDER BY `unit` DESC [ RunTime:0.031004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13380086 LIMIT 2 [ RunTime:0.065471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13380086 ORDER BY `minOrder` ASC [ RunTime:0.008678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13376207 LIMIT 5 [ RunTime:0.035985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13376207 ORDER BY `minOrder` ASC [ RunTime:0.077086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13376207 ORDER BY `unit` DESC [ RunTime:0.059405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13376207 LIMIT 2 [ RunTime:0.114480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13376207 ORDER BY `minOrder` ASC [ RunTime:0.073887s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050412s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37910212 LIMIT 5 [ RunTime:0.077684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37910212 ORDER BY `minOrder` ASC [ RunTime:0.049881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37910212 ORDER BY `unit` DESC [ RunTime:0.123573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37910212 LIMIT 2 [ RunTime:0.074602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37910212 ORDER BY `minOrder` ASC [ RunTime:0.002494s ]
select * from pdf where partno='0059894A2' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.131399s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.107303s ]
SELECT `id` FROM `stock` WHERE `id` <> 37910212 AND `partno` = '0059894A2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.132394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14264703 [ RunTime:0.115889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50594860 LIMIT 5 [ RunTime:0.058784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50594860 ORDER BY `minOrder` ASC [ RunTime:0.061678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50594860 ORDER BY `unit` DESC [ RunTime:0.082906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50594860 LIMIT 2 [ RunTime:0.054093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50594860 ORDER BY `minOrder` ASC [ RunTime:0.021700s ]
select * from pdf where partno='0059894A2' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.034122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.008148s ]
SELECT `id` FROM `stock` WHERE `id` <> 50594860 AND `partno` = '0059894A2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.028930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14264703 [ RunTime:0.026598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50604757 LIMIT 5 [ RunTime:0.032337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604757 ORDER BY `minOrder` ASC [ RunTime:0.057355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50604757 ORDER BY `unit` DESC [ RunTime:0.031903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50604757 LIMIT 2 [ RunTime:0.044616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604757 ORDER BY `minOrder` ASC [ RunTime:0.064197s ]
select * from pdf where partno='0059894A2HT19' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.035750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT19' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.038751s ]
SELECT `id` FROM `stock` WHERE `id` <> 50604757 AND `partno` = '0059894A2HT19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.031672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13376207 [ RunTime:0.016921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50604324 LIMIT 5 [ RunTime:0.019962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604324 ORDER BY `minOrder` ASC [ RunTime:0.014724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50604324 ORDER BY `unit` DESC [ RunTime:0.021470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50604324 LIMIT 2 [ RunTime:0.097091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604324 ORDER BY `minOrder` ASC [ RunTime:0.025568s ]
select * from pdf where partno='0059894A2HT15S' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.019962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT15S' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.046252s ]
SELECT `id` FROM `stock` WHERE `id` <> 50604324 AND `partno` = '0059894A2HT15S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.021600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37925792 [ RunTime:0.029154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50604323 LIMIT 5 [ RunTime:0.018498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604323 ORDER BY `minOrder` ASC [ RunTime:0.046060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50604323 ORDER BY `unit` DESC [ RunTime:0.007261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50604323 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50604323 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='0059894A2HT15' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.002319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT15' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.019192s ]
SELECT `id` FROM `stock` WHERE `id` <> 50604323 AND `partno` = '0059894A2HT15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.012591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380086 [ RunTime:0.003126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50603967 LIMIT 5 [ RunTime:0.004466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50603967 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50603967 ORDER BY `unit` DESC [ RunTime:0.004132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50603967 LIMIT 2 [ RunTime:0.030093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50603967 ORDER BY `minOrder` ASC [ RunTime:0.005709s ]
select * from pdf where partno='0059894A2S01' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.005264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2S01' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.000832s ]
SELECT `id` FROM `stock` WHERE `id` <> 50603967 AND `partno` = '0059894A2S01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.008637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266546 [ RunTime:0.011982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37926422 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37926422 ORDER BY `minOrder` ASC [ RunTime:0.028791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37926422 ORDER BY `unit` DESC [ RunTime:0.005396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37926422 LIMIT 2 [ RunTime:0.007302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37926422 ORDER BY `minOrder` ASC [ RunTime:0.002548s ]
select * from pdf where partno='0059894A2HT19' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.000531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT19' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.001415s ]
SELECT `id` FROM `stock` WHERE `id` <> 37926422 AND `partno` = '0059894A2HT19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.001164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13376207 [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37925792 LIMIT 5 [ RunTime:0.003313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925792 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37925792 ORDER BY `unit` DESC [ RunTime:0.000914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37925792 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925792 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='0059894A2HT15S' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.000821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT15S' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.000386s ]
SELECT `id` FROM `stock` WHERE `id` <> 37925792 AND `partno` = '0059894A2HT15S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50604324 [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37925791 LIMIT 5 [ RunTime:0.010997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925791 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37925791 ORDER BY `unit` DESC [ RunTime:0.008448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37925791 LIMIT 2 [ RunTime:0.001577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925791 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
select * from pdf where partno='0059894A2HT15' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.000737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2HT15' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 37925791 AND `partno` = '0059894A2HT15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.003492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380086 [ RunTime:0.003015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37925234 LIMIT 5 [ RunTime:0.008839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925234 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37925234 ORDER BY `unit` DESC [ RunTime:0.004380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37925234 LIMIT 2 [ RunTime:0.003220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37925234 ORDER BY `minOrder` ASC [ RunTime:0.007873s ]
select * from pdf where partno='0059894A2S01' and brandshort='Magnetics, a division of Spang & Co.' limit 1 [ RunTime:0.001749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0059894A2S01' OR `brand` LIKE 'Magnetics, a division of Spang & Co.%' ) ) LIMIT 1 [ RunTime:0.009124s ]
SELECT `id` FROM `stock` WHERE `id` <> 37925234 AND `partno` = '0059894A2S01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%magnetics, a division of spang & co.%' ) [ RunTime:0.008380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266546 [ RunTime:0.000283s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000933s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004411s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002527s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000777s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000726s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001752s ]
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 '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008075s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0059894A2%' OR `brand` LIKE '0059894A2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004415s ]