SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001938s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010213s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391633 LIMIT 5 [ RunTime:0.000787s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391633 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391633 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391633 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391633 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11334971 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11334971 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11334971 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11334971 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11334971 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391815 LIMIT 5 [ RunTime:0.003107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391815 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391815 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391815 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391815 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265123 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265123 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265123 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265123 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265123 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391763 LIMIT 5 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391763 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391763 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391763 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391763 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391902 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391902 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391902 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391902 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391902 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391832 LIMIT 5 [ RunTime:0.002184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391832 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391832 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391832 LIMIT 2 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391832 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392819 LIMIT 5 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392819 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392819 ORDER BY `unit` DESC [ RunTime:0.000257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392819 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392819 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335345 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335345 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335345 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335345 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335345 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265261 LIMIT 5 [ RunTime:0.002080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265261 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265261 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265261 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265261 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265215 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265215 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265215 ORDER BY `unit` DESC [ RunTime:0.000242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265215 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265215 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392125 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392125 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392125 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392125 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392125 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392005 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392005 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392005 ORDER BY `unit` DESC [ RunTime:0.000251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392005 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392005 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335462 LIMIT 5 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335462 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335462 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335462 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335462 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265558 LIMIT 5 [ RunTime:0.004795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265558 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265558 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265558 LIMIT 2 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265558 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265265 LIMIT 5 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265265 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265265 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265265 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265265 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265161 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265161 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265161 ORDER BY `unit` DESC [ RunTime:0.000294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265161 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265161 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392139 LIMIT 5 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392139 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392139 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392139 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392139 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391773 LIMIT 5 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391773 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391773 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391773 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391773 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265189 LIMIT 5 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265189 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265189 ORDER BY `unit` DESC [ RunTime:0.000267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265189 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265189 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106549 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106549 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106549 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106549 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106549 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='mikroe-55' and brandshort='mikroe' limit 1 [ RunTime:0.001248s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-55' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104336 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104336 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104336 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104336 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104336 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='mikroe-5596' and brandshort='mikroe' limit 1 [ RunTime:0.000507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5596' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32292915 LIMIT 5 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292915 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32292915 ORDER BY `unit` DESC [ RunTime:0.000236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32292915 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32292915 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='mikroe-5538' and brandshort='mikroe' limit 1 [ RunTime:0.000442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5538' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104886 LIMIT 5 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104886 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104886 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104886 LIMIT 2 [ RunTime:0.000223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104886 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='mikroe-5598' and brandshort='mikroe' limit 1 [ RunTime:0.002009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5598' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104885 LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104885 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104885 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104885 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104885 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='mikroe-5586' and brandshort='mikroe' limit 1 [ RunTime:0.000380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5586' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51102874 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102874 ORDER BY `minOrder` ASC [ RunTime:0.002502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51102874 ORDER BY `unit` DESC [ RunTime:0.000238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51102874 LIMIT 2 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102874 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='mikroe-5565' and brandshort='mikroe' limit 1 [ RunTime:0.000369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5565' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51102873 LIMIT 5 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102873 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51102873 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51102873 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102873 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
select * from pdf where partno='mikroe-5560' and brandshort='mikroe' limit 1 [ RunTime:0.000361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5560' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32243654 LIMIT 5 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32243654 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32243654 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32243654 LIMIT 2 [ RunTime:0.000230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32243654 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='mikroe-5526' and brandshort='mikroe' limit 1 [ RunTime:0.000372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5526' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32195191 LIMIT 5 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32195191 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32195191 ORDER BY `unit` DESC [ RunTime:0.000243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32195191 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32195191 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='mikroe-5526' and brandshort='mikroe' limit 1 [ RunTime:0.000367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5526' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104884 LIMIT 5 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104884 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104884 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104884 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104884 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='mikroe-5530' and brandshort='mikroe' limit 1 [ RunTime:0.000376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mikroe-5530' OR `brand` LIKE 'mikroe%' ) ) LIMIT 1 [ RunTime:0.000367s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64048889 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048889 ORDER BY `minOrder` ASC [ RunTime:0.005524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64048889 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64048889 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048889 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='MIKROE-5543' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5543' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64048889 AND `partno` = 'MIKROE-5543' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391633 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64049285 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049285 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64049285 ORDER BY `unit` DESC [ RunTime:0.000597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64049285 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049285 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
select * from pdf where partno='MIKROE-5508' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5508' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id` FROM `stock` WHERE `id` <> 64049285 AND `partno` = 'MIKROE-5508' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392819 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050079 LIMIT 5 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050079 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050079 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050079 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050079 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
select * from pdf where partno='MIKROE-5548' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5548' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050079 AND `partno` = 'MIKROE-5548' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335364 [ RunTime:0.000946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050185 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050185 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050185 ORDER BY `unit` DESC [ RunTime:0.000677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050185 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050185 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
select * from pdf where partno='MIKROE-5538' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5538' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000819s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050185 AND `partno` = 'MIKROE-5538' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265123 [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050001 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050001 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050001 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050001 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050001 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
select * from pdf where partno='MIKROE-5574' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5574' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000787s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050001 AND `partno` = 'MIKROE-5574' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335345 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050605 LIMIT 5 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050605 ORDER BY `minOrder` ASC [ RunTime:0.002107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050605 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050605 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050605 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
select * from pdf where partno='MIKROE-5510' and brandshort='MikroElektronika' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5510' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000891s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050605 AND `partno` = 'MIKROE-5510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391832 [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050900 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050900 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050900 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050900 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050900 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
select * from pdf where partno='MIKROE-5536' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5536' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000740s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050900 AND `partno` = 'MIKROE-5536' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392125 [ RunTime:0.000747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050890 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050890 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050890 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050890 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050890 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='MIKROE-5572' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5572' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000802s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050890 AND `partno` = 'MIKROE-5572' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265261 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050421 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050421 ORDER BY `minOrder` ASC [ RunTime:0.000911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050421 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050421 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050421 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='MIKROE-5583' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5583' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000743s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050421 AND `partno` = 'MIKROE-5583' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393114 [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050219 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050219 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050219 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050219 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050219 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='MIKROE-5545' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5545' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000706s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050219 AND `partno` = 'MIKROE-5545' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391815 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050377 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050377 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050377 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050377 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050377 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
select * from pdf where partno='MIKROE-5529' and brandshort='MikroElektronika' limit 1 [ RunTime:0.001030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5529' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000706s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050377 AND `partno` = 'MIKROE-5529' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265161 [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050544 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050544 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050544 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050544 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050544 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
select * from pdf where partno='MIKROE-5501' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5501' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000757s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050544 AND `partno` = 'MIKROE-5501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392005 [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64053046 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053046 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64053046 ORDER BY `unit` DESC [ RunTime:0.000602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64053046 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053046 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
select * from pdf where partno='MIKROE-5595' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5595' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000708s ]
SELECT `id` FROM `stock` WHERE `id` <> 64053046 AND `partno` = 'MIKROE-5595' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265189 [ RunTime:0.000707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64052989 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052989 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64052989 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64052989 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052989 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='MIKROE-5547' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5547' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000772s ]
SELECT `id` FROM `stock` WHERE `id` <> 64052989 AND `partno` = 'MIKROE-5547' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336321 [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64053420 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053420 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64053420 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64053420 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053420 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
select * from pdf where partno='MIKROE-5575' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5575' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000767s ]
SELECT `id` FROM `stock` WHERE `id` <> 64053420 AND `partno` = 'MIKROE-5575' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335961 [ RunTime:0.001049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64053146 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053146 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64053146 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64053146 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64053146 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='MIKROE-5591' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5591' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 64053146 AND `partno` = 'MIKROE-5591' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265558 [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64052619 LIMIT 5 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052619 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64052619 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64052619 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052619 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='MIKROE-5531' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5531' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000705s ]
SELECT `id` FROM `stock` WHERE `id` <> 64052619 AND `partno` = 'MIKROE-5531' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393163 [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64052502 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052502 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64052502 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64052502 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052502 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
select * from pdf where partno='MIKROE-5539' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5539' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000757s ]
SELECT `id` FROM `stock` WHERE `id` <> 64052502 AND `partno` = 'MIKROE-5539' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393075 [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050686 LIMIT 5 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050686 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050686 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050686 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050686 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
select * from pdf where partno='MIKROE-5530' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5530' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050686 AND `partno` = 'MIKROE-5530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392055 [ RunTime:0.000833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050638 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050638 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050638 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050638 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050638 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
select * from pdf where partno='MIKROE-5599' and brandshort='MikroElektronika' limit 1 [ RunTime:0.000795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIKROE-5599' OR `brand` LIKE 'MikroElektronika%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050638 AND `partno` = 'MIKROE-5599' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mikroelektronika%' ) [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265924 [ RunTime:0.001143s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001458s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001309s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001278s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001247s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001084s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001105s ]
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 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001164s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'mikroe-55%' OR `brand` LIKE 'mikroe-55%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001623s ]