SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001071s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040464s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628447 LIMIT 5 [ RunTime:0.019051s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628447 ORDER BY `minOrder` ASC [ RunTime:0.030073s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16628447 ORDER BY `unit` DESC [ RunTime:0.025703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16628447 LIMIT 2 [ RunTime:0.032121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628447 ORDER BY `minOrder` ASC [ RunTime:0.004129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628448 LIMIT 5 [ RunTime:0.019992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628448 ORDER BY `minOrder` ASC [ RunTime:0.028303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16628448 ORDER BY `unit` DESC [ RunTime:0.015421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16628448 LIMIT 2 [ RunTime:0.004215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628448 ORDER BY `minOrder` ASC [ RunTime:0.015144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14705274 LIMIT 5 [ RunTime:0.069661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14705274 ORDER BY `minOrder` ASC [ RunTime:0.060198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14705274 ORDER BY `unit` DESC [ RunTime:0.013231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14705274 LIMIT 2 [ RunTime:0.025783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14705274 ORDER BY `minOrder` ASC [ RunTime:0.010238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628237 LIMIT 5 [ RunTime:0.001267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628237 ORDER BY `minOrder` ASC [ RunTime:0.003550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16628237 ORDER BY `unit` DESC [ RunTime:0.014549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16628237 LIMIT 2 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16628237 ORDER BY `minOrder` ASC [ RunTime:0.018808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260361 LIMIT 5 [ RunTime:0.023484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260361 ORDER BY `minOrder` ASC [ RunTime:0.013613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260361 ORDER BY `unit` DESC [ RunTime:0.007909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260361 LIMIT 2 [ RunTime:0.013683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260361 ORDER BY `minOrder` ASC [ RunTime:0.012411s ]
select * from pdf where partno='14606' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.027270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706551 LIMIT 5 [ RunTime:0.012665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706551 ORDER BY `minOrder` ASC [ RunTime:0.005285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706551 ORDER BY `unit` DESC [ RunTime:0.006366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706551 LIMIT 2 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706551 ORDER BY `minOrder` ASC [ RunTime:0.002969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13480189 LIMIT 5 [ RunTime:0.003898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13480189 ORDER BY `minOrder` ASC [ RunTime:0.025581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13480189 ORDER BY `unit` DESC [ RunTime:0.003973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13480189 LIMIT 2 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13480189 ORDER BY `minOrder` ASC [ RunTime:0.007531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734166 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734166 ORDER BY `minOrder` ASC [ RunTime:0.002314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12734166 ORDER BY `unit` DESC [ RunTime:0.002414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12734166 LIMIT 2 [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734166 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
select * from pdf where partno='146069-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.038290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11257792 LIMIT 5 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257792 ORDER BY `minOrder` ASC [ RunTime:0.041834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11257792 ORDER BY `unit` DESC [ RunTime:0.046586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11257792 LIMIT 2 [ RunTime:0.003239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11257792 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029245s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51309031 LIMIT 5 [ RunTime:0.002690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309031 ORDER BY `minOrder` ASC [ RunTime:0.010334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51309031 ORDER BY `unit` DESC [ RunTime:0.001183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51309031 LIMIT 2 [ RunTime:0.013715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309031 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='1460600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000547s ]
SELECT `id` FROM `stock` WHERE `id` <> 51309031 AND `partno` = '1460600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14705274 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51309032 LIMIT 5 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309032 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51309032 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51309032 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309032 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='1460620000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460620000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 51309032 AND `partno` = '1460620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628448 [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51309033 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309033 ORDER BY `minOrder` ASC [ RunTime:0.007372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51309033 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51309033 LIMIT 2 [ RunTime:0.001225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51309033 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='1460610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 51309033 AND `partno` = '1460610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628447 [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51308229 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51308229 ORDER BY `minOrder` ASC [ RunTime:0.002143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51308229 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51308229 LIMIT 2 [ RunTime:0.003358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51308229 ORDER BY `minOrder` ASC [ RunTime:0.007154s ]
select * from pdf where partno='1460640000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460640000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 51308229 AND `partno` = '1460640000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16628237 [ RunTime:0.008387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52797537 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52797537 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52797537 ORDER BY `unit` DESC [ RunTime:0.005057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52797537 LIMIT 2 [ RunTime:0.002856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52797537 ORDER BY `minOrder` ASC [ RunTime:0.002957s ]
select * from pdf where partno='146069-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '146069-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003004s ]
SELECT `id` FROM `stock` WHERE `id` <> 52797537 AND `partno` = '146069-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734166 [ RunTime:0.005426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52527198 LIMIT 5 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52527198 ORDER BY `minOrder` ASC [ RunTime:0.003846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52527198 ORDER BY `unit` DESC [ RunTime:0.005716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52527198 LIMIT 2 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52527198 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
select * from pdf where partno='1460630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009712s ]
SELECT `id` FROM `stock` WHERE `id` <> 52527198 AND `partno` = '1460630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51311800 LIMIT 5 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51311800 ORDER BY `minOrder` ASC [ RunTime:0.004045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51311800 ORDER BY `unit` DESC [ RunTime:0.006318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51311800 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51311800 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='1460650000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1460650000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000409s ]
SELECT `id` FROM `stock` WHERE `id` <> 51311800 AND `partno` = '1460650000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706551 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51249722 LIMIT 5 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51249722 ORDER BY `minOrder` ASC [ RunTime:0.016935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51249722 ORDER BY `unit` DESC [ RunTime:0.002435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51249722 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51249722 ORDER BY `minOrder` ASC [ RunTime:0.005932s ]
select * from pdf where partno='14606' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14606' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 51249722 AND `partno` = '14606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260361 [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50690657 LIMIT 5 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50690657 ORDER BY `minOrder` ASC [ RunTime:0.007476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50690657 ORDER BY `unit` DESC [ RunTime:0.006995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50690657 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50690657 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
select * from pdf where partno='146069' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '146069' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000393s ]
SELECT `id` FROM `stock` WHERE `id` <> 50690657 AND `partno` = '146069' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13480189 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38056628 LIMIT 5 [ RunTime:0.005393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38056628 ORDER BY `minOrder` ASC [ RunTime:0.039620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38056628 ORDER BY `unit` DESC [ RunTime:0.033336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38056628 LIMIT 2 [ RunTime:0.007141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38056628 ORDER BY `minOrder` ASC [ RunTime:0.001552s ]
select * from pdf where partno='146069' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '146069' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002114s ]
SELECT `id` FROM `stock` WHERE `id` <> 38056628 AND `partno` = '146069' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13480189 [ RunTime:0.001498s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006334s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012756s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013841s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022976s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008866s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018197s ]
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 '14606%' OR `brand` LIKE '14606%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005553s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14606%' OR `brand` LIKE '14606%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011045s ]