SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001240s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020694s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394788 LIMIT 5 [ RunTime:0.001180s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394788 ORDER BY `minOrder` ASC [ RunTime:0.014733s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394788 ORDER BY `unit` DESC [ RunTime:0.009773s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394788 LIMIT 2 [ RunTime:0.001866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394788 ORDER BY `minOrder` ASC [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394785 LIMIT 5 [ RunTime:0.026640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394785 ORDER BY `minOrder` ASC [ RunTime:0.035797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394785 ORDER BY `unit` DESC [ RunTime:0.039075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394785 LIMIT 2 [ RunTime:0.009485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394785 ORDER BY `minOrder` ASC [ RunTime:0.020877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394784 LIMIT 5 [ RunTime:0.008989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394784 ORDER BY `minOrder` ASC [ RunTime:0.035160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394784 ORDER BY `unit` DESC [ RunTime:0.011969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394784 LIMIT 2 [ RunTime:0.037260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394784 ORDER BY `minOrder` ASC [ RunTime:0.020858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394772 LIMIT 5 [ RunTime:0.019530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394772 ORDER BY `minOrder` ASC [ RunTime:0.013496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394772 ORDER BY `unit` DESC [ RunTime:0.008339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394772 LIMIT 2 [ RunTime:0.009189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394772 ORDER BY `minOrder` ASC [ RunTime:0.004294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394769 LIMIT 5 [ RunTime:0.006049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394769 ORDER BY `minOrder` ASC [ RunTime:0.026053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394769 ORDER BY `unit` DESC [ RunTime:0.010642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394769 LIMIT 2 [ RunTime:0.008529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394769 ORDER BY `minOrder` ASC [ RunTime:0.013089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394763 LIMIT 5 [ RunTime:0.006132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394763 ORDER BY `minOrder` ASC [ RunTime:0.010226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394763 ORDER BY `unit` DESC [ RunTime:0.008651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394763 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394763 ORDER BY `minOrder` ASC [ RunTime:0.003716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394753 LIMIT 5 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394753 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394753 ORDER BY `unit` DESC [ RunTime:0.009896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394753 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394753 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394749 LIMIT 5 [ RunTime:0.006754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394749 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394749 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394749 LIMIT 2 [ RunTime:0.005328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394749 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394747 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394747 ORDER BY `minOrder` ASC [ RunTime:0.004211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394747 ORDER BY `unit` DESC [ RunTime:0.001971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394747 LIMIT 2 [ RunTime:0.011806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394747 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394744 LIMIT 5 [ RunTime:0.010538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394744 ORDER BY `minOrder` ASC [ RunTime:0.018967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394744 ORDER BY `unit` DESC [ RunTime:0.009740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394744 LIMIT 2 [ RunTime:0.006553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394744 ORDER BY `minOrder` ASC [ RunTime:0.005484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394740 LIMIT 5 [ RunTime:0.003782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394740 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394740 ORDER BY `unit` DESC [ RunTime:0.004964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394740 LIMIT 2 [ RunTime:0.006287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394740 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394737 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394737 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394737 ORDER BY `unit` DESC [ RunTime:0.003745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394737 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394737 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394730 LIMIT 5 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394730 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394730 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394730 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394730 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394729 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394729 ORDER BY `minOrder` ASC [ RunTime:0.011720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394729 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394729 LIMIT 2 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394729 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523180 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523180 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523180 ORDER BY `unit` DESC [ RunTime:0.012270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523180 LIMIT 2 [ RunTime:0.018648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523180 ORDER BY `minOrder` ASC [ RunTime:0.007267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523179 LIMIT 5 [ RunTime:0.000908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523179 ORDER BY `minOrder` ASC [ RunTime:0.006510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523179 ORDER BY `unit` DESC [ RunTime:0.014818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523179 LIMIT 2 [ RunTime:0.007122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523179 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523175 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523175 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523175 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523175 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523175 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523174 LIMIT 5 [ RunTime:0.006948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523174 ORDER BY `minOrder` ASC [ RunTime:0.001591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523174 ORDER BY `unit` DESC [ RunTime:0.000952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523174 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523174 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523167 LIMIT 5 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523167 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523167 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523167 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523167 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523164 LIMIT 5 [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523164 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523164 ORDER BY `unit` DESC [ RunTime:0.006215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523164 LIMIT 2 [ RunTime:0.003023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523164 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002600s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696140 LIMIT 5 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696140 ORDER BY `minOrder` ASC [ RunTime:0.002555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696140 ORDER BY `unit` DESC [ RunTime:0.002544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696140 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696140 ORDER BY `minOrder` ASC [ RunTime:0.006886s ]
select * from pdf where partno='5160P-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002164s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000884s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696140 AND `partno` = '5160P-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523180 [ RunTime:0.003953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696139 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696139 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696139 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696139 LIMIT 2 [ RunTime:0.002768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696139 ORDER BY `minOrder` ASC [ RunTime:0.002165s ]
select * from pdf where partno='5160P-4' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-4' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003648s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696139 AND `partno` = '5160P-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523179 [ RunTime:0.005412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696135 LIMIT 5 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696135 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696135 ORDER BY `unit` DESC [ RunTime:0.000177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696135 LIMIT 2 [ RunTime:0.000194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696135 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
select * from pdf where partno='5160P-Q' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-Q' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000189s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696135 AND `partno` = '5160P-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523175 [ RunTime:0.000162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696134 LIMIT 5 [ RunTime:0.004117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696134 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696134 ORDER BY `unit` DESC [ RunTime:0.007343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696134 LIMIT 2 [ RunTime:0.002125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696134 ORDER BY `minOrder` ASC [ RunTime:0.000201s ]
select * from pdf where partno='5160P-P' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-P' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000441s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696134 AND `partno` = '5160P-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523174 [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696129 LIMIT 5 [ RunTime:0.000192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696129 ORDER BY `minOrder` ASC [ RunTime:0.003095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696129 ORDER BY `unit` DESC [ RunTime:0.004190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696129 LIMIT 2 [ RunTime:0.000201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696129 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
select * from pdf where partno='5160P-T' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-T' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000179s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696129 AND `partno` = '5160P-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394788 [ RunTime:0.003933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696126 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696126 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696126 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696126 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696126 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
select * from pdf where partno='5160P-R' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-R' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696126 AND `partno` = '5160P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394785 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696123 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696123 ORDER BY `minOrder` ASC [ RunTime:0.011840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696123 ORDER BY `unit` DESC [ RunTime:0.003481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696123 LIMIT 2 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696123 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='5160P-5' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-5' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018173s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696123 AND `partno` = '5160P-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394784 [ RunTime:0.005802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696119 LIMIT 5 [ RunTime:0.005499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696119 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696119 ORDER BY `unit` DESC [ RunTime:0.002397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696119 LIMIT 2 [ RunTime:0.000217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696119 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
select * from pdf where partno='5160P-9' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-9' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000256s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696119 AND `partno` = '5160P-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523167 [ RunTime:0.006116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696116 LIMIT 5 [ RunTime:0.008101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696116 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696116 ORDER BY `unit` DESC [ RunTime:0.005759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696116 LIMIT 2 [ RunTime:0.001451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696116 ORDER BY `minOrder` ASC [ RunTime:0.002115s ]
select * from pdf where partno='5160P-U' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-U' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000677s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696116 AND `partno` = '5160P-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523164 [ RunTime:0.000204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696115 LIMIT 5 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696115 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696115 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696115 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696115 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
select * from pdf where partno='5160P-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003182s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696115 AND `partno` = '5160P-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523163 [ RunTime:0.001153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696105 LIMIT 5 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696105 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696105 ORDER BY `unit` DESC [ RunTime:0.004181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696105 LIMIT 2 [ RunTime:0.004873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696105 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
select * from pdf where partno='5160P-Y' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-Y' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001711s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696105 AND `partno` = '5160P-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523157 [ RunTime:0.005248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696104 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696104 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696104 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696104 LIMIT 2 [ RunTime:0.001863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696104 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
select * from pdf where partno='5160P-L' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-L' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001644s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696104 AND `partno` = '5160P-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523156 [ RunTime:0.002895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696095 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696095 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696095 ORDER BY `unit` DESC [ RunTime:0.000205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696095 LIMIT 2 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696095 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
select * from pdf where partno='5160P-J' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-J' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000215s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696095 AND `partno` = '5160P-J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394772 [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696092 LIMIT 5 [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696092 ORDER BY `minOrder` ASC [ RunTime:0.005439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696092 ORDER BY `unit` DESC [ RunTime:0.002396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696092 LIMIT 2 [ RunTime:0.009006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696092 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
select * from pdf where partno='5160P-G' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-G' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004709s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696092 AND `partno` = '5160P-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.035056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394769 [ RunTime:0.018056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696091 LIMIT 5 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696091 ORDER BY `minOrder` ASC [ RunTime:0.003818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696091 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696091 LIMIT 2 [ RunTime:0.003259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696091 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='5160P-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000459s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696091 AND `partno` = '5160P-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523151 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696090 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696090 ORDER BY `minOrder` ASC [ RunTime:0.001531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696090 ORDER BY `unit` DESC [ RunTime:0.003111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696090 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696090 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='5160P-S' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-S' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000496s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696090 AND `partno` = '5160P-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523150 [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696089 LIMIT 5 [ RunTime:0.006407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696089 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696089 ORDER BY `unit` DESC [ RunTime:0.002843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696089 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696089 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='5160P-0' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-0' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003674s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696089 AND `partno` = '5160P-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523149 [ RunTime:0.003673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696078 LIMIT 5 [ RunTime:0.007408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696078 ORDER BY `minOrder` ASC [ RunTime:0.007628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696078 ORDER BY `unit` DESC [ RunTime:0.012284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696078 LIMIT 2 [ RunTime:0.007989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696078 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
select * from pdf where partno='5160P-Z' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-Z' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013668s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696078 AND `partno` = '5160P-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523142 [ RunTime:0.002226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696076 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696076 ORDER BY `minOrder` ASC [ RunTime:0.003694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696076 ORDER BY `unit` DESC [ RunTime:0.004388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696076 LIMIT 2 [ RunTime:0.009753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696076 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
select * from pdf where partno='5160P-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.019568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002318s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696076 AND `partno` = '5160P-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394763 [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696073 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696073 ORDER BY `minOrder` ASC [ RunTime:0.004024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696073 ORDER BY `unit` DESC [ RunTime:0.008753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696073 LIMIT 2 [ RunTime:0.007982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696073 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='5160P-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5160P-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004453s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696073 AND `partno` = '5160P-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523141 [ RunTime:0.011236s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001408s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002985s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011413s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002883s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008030s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008743s ]
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 '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001166s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5160P-%' OR `brand` LIKE '5160P-%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021641s ]