SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001243s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010105s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474159 LIMIT 5 [ RunTime:0.017739s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474159 ORDER BY `minOrder` ASC [ RunTime:0.034895s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474159 ORDER BY `unit` DESC [ RunTime:0.035064s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474159 LIMIT 2 [ RunTime:0.042013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474159 ORDER BY `minOrder` ASC [ RunTime:0.021222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474154 LIMIT 5 [ RunTime:0.032446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474154 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474154 ORDER BY `unit` DESC [ RunTime:0.008222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474154 LIMIT 2 [ RunTime:0.012819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474154 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17154080 LIMIT 5 [ RunTime:0.007321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154080 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17154080 ORDER BY `unit` DESC [ RunTime:0.009596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17154080 LIMIT 2 [ RunTime:0.030829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154080 ORDER BY `minOrder` ASC [ RunTime:0.049714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19295625 LIMIT 5 [ RunTime:0.008658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19295625 ORDER BY `minOrder` ASC [ RunTime:0.017310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19295625 ORDER BY `unit` DESC [ RunTime:0.000853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19295625 LIMIT 2 [ RunTime:0.020348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19295625 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353146 LIMIT 5 [ RunTime:0.001329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353146 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14353146 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14353146 LIMIT 2 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14353146 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476570 LIMIT 5 [ RunTime:0.001115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13476570 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13476570 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13476570 LIMIT 2 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13476570 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298873 LIMIT 5 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298873 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298873 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298873 LIMIT 2 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298873 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298872 LIMIT 5 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298872 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298872 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298872 LIMIT 2 [ RunTime:0.001903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298872 ORDER BY `minOrder` ASC [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298871 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298871 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298871 ORDER BY `unit` DESC [ RunTime:0.000827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298871 LIMIT 2 [ RunTime:0.002960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298871 ORDER BY `minOrder` ASC [ RunTime:0.001719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298450 LIMIT 5 [ RunTime:0.006956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298450 ORDER BY `minOrder` ASC [ RunTime:0.006366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298450 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298450 LIMIT 2 [ RunTime:0.002794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298450 ORDER BY `minOrder` ASC [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298449 LIMIT 5 [ RunTime:0.000999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298449 ORDER BY `minOrder` ASC [ RunTime:0.008422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298449 ORDER BY `unit` DESC [ RunTime:0.007651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298449 LIMIT 2 [ RunTime:0.005488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298449 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298448 LIMIT 5 [ RunTime:0.003064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298448 ORDER BY `minOrder` ASC [ RunTime:0.003747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298448 ORDER BY `unit` DESC [ RunTime:0.004328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298448 LIMIT 2 [ RunTime:0.010273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298448 ORDER BY `minOrder` ASC [ RunTime:0.005178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298447 LIMIT 5 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298447 ORDER BY `minOrder` ASC [ RunTime:0.002686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298447 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298447 LIMIT 2 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298447 ORDER BY `minOrder` ASC [ RunTime:0.001568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19298446 LIMIT 5 [ RunTime:0.006057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298446 ORDER BY `minOrder` ASC [ RunTime:0.004592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19298446 ORDER BY `unit` DESC [ RunTime:0.002784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19298446 LIMIT 2 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19298446 ORDER BY `minOrder` ASC [ RunTime:0.002267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292559 LIMIT 5 [ RunTime:0.003960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292559 ORDER BY `minOrder` ASC [ RunTime:0.011598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19292559 ORDER BY `unit` DESC [ RunTime:0.010045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19292559 LIMIT 2 [ RunTime:0.005894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292559 ORDER BY `minOrder` ASC [ RunTime:0.005100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292558 LIMIT 5 [ RunTime:0.000848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292558 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19292558 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19292558 LIMIT 2 [ RunTime:0.009130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292558 ORDER BY `minOrder` ASC [ RunTime:0.005042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292557 LIMIT 5 [ RunTime:0.003539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292557 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19292557 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19292557 LIMIT 2 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292557 ORDER BY `minOrder` ASC [ RunTime:0.001908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292556 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292556 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19292556 ORDER BY `unit` DESC [ RunTime:0.000815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19292556 LIMIT 2 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19292556 ORDER BY `minOrder` ASC [ RunTime:0.001568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17153899 LIMIT 5 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17153899 ORDER BY `minOrder` ASC [ RunTime:0.001700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17153899 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17153899 LIMIT 2 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17153899 ORDER BY `minOrder` ASC [ RunTime:0.001777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15374501 LIMIT 5 [ RunTime:0.001137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15374501 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15374501 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15374501 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15374501 ORDER BY `minOrder` ASC [ RunTime:0.001971s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001703s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687135 LIMIT 5 [ RunTime:0.007271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687135 ORDER BY `minOrder` ASC [ RunTime:0.006056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687135 ORDER BY `unit` DESC [ RunTime:0.007674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687135 LIMIT 2 [ RunTime:0.001838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687135 ORDER BY `minOrder` ASC [ RunTime:0.010223s ]
select * from pdf where partno='MC-500-595-CL-BK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009655s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-CL-BK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002436s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687135 AND `partno` = 'MC-500-595-CL-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476521 [ RunTime:0.001407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57660382 LIMIT 5 [ RunTime:0.005187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57660382 ORDER BY `minOrder` ASC [ RunTime:0.004347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57660382 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57660382 LIMIT 2 [ RunTime:0.005737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57660382 ORDER BY `minOrder` ASC [ RunTime:0.004269s ]
select * from pdf where partno='MC-50A-AC120V' and brandshort='Altech Corporation' limit 1 [ RunTime:0.007001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-50A-AC120V' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.004002s ]
SELECT `id` FROM `stock` WHERE `id` <> 57660382 AND `partno` = 'MC-50A-AC120V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19295625 [ RunTime:0.006068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57661801 LIMIT 5 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57661801 ORDER BY `minOrder` ASC [ RunTime:0.010567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57661801 ORDER BY `unit` DESC [ RunTime:0.007812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57661801 LIMIT 2 [ RunTime:0.003186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57661801 ORDER BY `minOrder` ASC [ RunTime:0.005910s ]
select * from pdf where partno='MC-50A-AC208V' and brandshort='Altech Corporation' limit 1 [ RunTime:0.011250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-50A-AC208V' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.002720s ]
SELECT `id` FROM `stock` WHERE `id` <> 57661801 AND `partno` = 'MC-50A-AC208V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.003546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17154080 [ RunTime:0.000870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63114605 LIMIT 5 [ RunTime:0.001044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114605 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63114605 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63114605 LIMIT 2 [ RunTime:0.008041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114605 ORDER BY `minOrder` ASC [ RunTime:0.003560s ]
select * from pdf where partno='MC-500-584' and brandshort='L-com' limit 1 [ RunTime:0.003814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-584' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.013386s ]
SELECT `id` FROM `stock` WHERE `id` <> 63114605 AND `partno` = 'MC-500-584' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14403233 [ RunTime:0.001231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63114405 LIMIT 5 [ RunTime:0.004718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114405 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63114405 ORDER BY `unit` DESC [ RunTime:0.006739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63114405 LIMIT 2 [ RunTime:0.008320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114405 ORDER BY `minOrder` ASC [ RunTime:0.006310s ]
select * from pdf where partno='MC-500-595-OR-BK' and brandshort='L-com' limit 1 [ RunTime:0.008094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-OR-BK' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.019125s ]
SELECT `id` FROM `stock` WHERE `id` <> 63114405 AND `partno` = 'MC-500-595-OR-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14403181 [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57688874 LIMIT 5 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688874 ORDER BY `minOrder` ASC [ RunTime:0.004317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57688874 ORDER BY `unit` DESC [ RunTime:0.005569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57688874 LIMIT 2 [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688874 ORDER BY `minOrder` ASC [ RunTime:0.002320s ]
select * from pdf where partno='MC-500-584-YL' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-584-YL' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003145s ]
SELECT `id` FROM `stock` WHERE `id` <> 57688874 AND `partno` = 'MC-500-584-YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353599 [ RunTime:0.001580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57688832 LIMIT 5 [ RunTime:0.003637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688832 ORDER BY `minOrder` ASC [ RunTime:0.003290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57688832 ORDER BY `unit` DESC [ RunTime:0.004730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57688832 LIMIT 2 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688832 ORDER BY `minOrder` ASC [ RunTime:0.002439s ]
select * from pdf where partno='MC-500-584' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-584' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002042s ]
SELECT `id` FROM `stock` WHERE `id` <> 57688832 AND `partno` = 'MC-500-584' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477604 [ RunTime:0.002122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57688218 LIMIT 5 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688218 ORDER BY `minOrder` ASC [ RunTime:0.008045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57688218 ORDER BY `unit` DESC [ RunTime:0.003055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57688218 LIMIT 2 [ RunTime:0.009946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57688218 ORDER BY `minOrder` ASC [ RunTime:0.003499s ]
select * from pdf where partno='MC-500-492' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-492' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009993s ]
SELECT `id` FROM `stock` WHERE `id` <> 57688218 AND `partno` = 'MC-500-492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13477093 [ RunTime:0.001804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687898 LIMIT 5 [ RunTime:0.012524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687898 ORDER BY `minOrder` ASC [ RunTime:0.007078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687898 ORDER BY `unit` DESC [ RunTime:0.003159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687898 LIMIT 2 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687898 ORDER BY `minOrder` ASC [ RunTime:0.003005s ]
select * from pdf where partno='MC-500-499' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-499' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005735s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687898 AND `partno` = 'MC-500-499' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353252 [ RunTime:0.004188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687412 LIMIT 5 [ RunTime:0.007254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687412 ORDER BY `minOrder` ASC [ RunTime:0.003268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687412 ORDER BY `unit` DESC [ RunTime:0.013392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687412 LIMIT 2 [ RunTime:0.011187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687412 ORDER BY `minOrder` ASC [ RunTime:0.010242s ]
select * from pdf where partno='MC-500-595-WT-RD' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-WT-RD' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008885s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687412 AND `partno` = 'MC-500-595-WT-RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476534 [ RunTime:0.003712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687396 LIMIT 5 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687396 ORDER BY `minOrder` ASC [ RunTime:0.014518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687396 ORDER BY `unit` DESC [ RunTime:0.004642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687396 LIMIT 2 [ RunTime:0.007586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687396 ORDER BY `minOrder` ASC [ RunTime:0.004522s ]
select * from pdf where partno='MC-500-595-YL-BK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-YL-BK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006191s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687396 AND `partno` = 'MC-500-595-YL-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476525 [ RunTime:0.009003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687395 LIMIT 5 [ RunTime:0.019930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687395 ORDER BY `minOrder` ASC [ RunTime:0.011069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687395 ORDER BY `unit` DESC [ RunTime:0.016594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687395 LIMIT 2 [ RunTime:0.020303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687395 ORDER BY `minOrder` ASC [ RunTime:0.009230s ]
select * from pdf where partno='MC-500-595-OR-BK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-OR-BK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005445s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687395 AND `partno` = 'MC-500-595-OR-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476524 [ RunTime:0.002738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687394 LIMIT 5 [ RunTime:0.004172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687394 ORDER BY `minOrder` ASC [ RunTime:0.003481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687394 ORDER BY `unit` DESC [ RunTime:0.005875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687394 LIMIT 2 [ RunTime:0.015712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687394 ORDER BY `minOrder` ASC [ RunTime:0.006413s ]
select * from pdf where partno='MC-500-595-WT-BK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-WT-BK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010382s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687394 AND `partno` = 'MC-500-595-WT-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476523 [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687393 LIMIT 5 [ RunTime:0.004989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687393 ORDER BY `minOrder` ASC [ RunTime:0.007553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687393 ORDER BY `unit` DESC [ RunTime:0.013990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687393 LIMIT 2 [ RunTime:0.008955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687393 ORDER BY `minOrder` ASC [ RunTime:0.020484s ]
select * from pdf where partno='MC-500-595-CL-WT' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-CL-WT' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001005s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687393 AND `partno` = 'MC-500-595-CL-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476522 [ RunTime:0.006512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687392 LIMIT 5 [ RunTime:0.023469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687392 ORDER BY `minOrder` ASC [ RunTime:0.005731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687392 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687392 LIMIT 2 [ RunTime:0.004728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687392 ORDER BY `minOrder` ASC [ RunTime:0.008129s ]
select * from pdf where partno='MC-500-595-RD-WT' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-RD-WT' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006837s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687392 AND `partno` = 'MC-500-595-RD-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476520 [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687391 LIMIT 5 [ RunTime:0.001313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687391 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687391 ORDER BY `unit` DESC [ RunTime:0.004815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687391 LIMIT 2 [ RunTime:0.007581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687391 ORDER BY `minOrder` ASC [ RunTime:0.007047s ]
select * from pdf where partno='MC-500-595-BL-WT' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-BL-WT' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010795s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687391 AND `partno` = 'MC-500-595-BL-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13476519 [ RunTime:0.015597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57687390 LIMIT 5 [ RunTime:0.016513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687390 ORDER BY `minOrder` ASC [ RunTime:0.016114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57687390 ORDER BY `unit` DESC [ RunTime:0.014016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57687390 LIMIT 2 [ RunTime:0.005932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57687390 ORDER BY `minOrder` ASC [ RunTime:0.004265s ]
select * from pdf where partno='MC-500-595-BK-WT' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500-595-BK-WT' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020710s ]
SELECT `id` FROM `stock` WHERE `id` <> 57687390 AND `partno` = 'MC-500-595-BK-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14353147 [ RunTime:0.011713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57671817 LIMIT 5 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671817 ORDER BY `minOrder` ASC [ RunTime:0.012392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57671817 ORDER BY `unit` DESC [ RunTime:0.003850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57671817 LIMIT 2 [ RunTime:0.008039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671817 ORDER BY `minOrder` ASC [ RunTime:0.004586s ]
select * from pdf where partno='MC-500A-500V' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500A-500V' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.003570s ]
SELECT `id` FROM `stock` WHERE `id` <> 57671817 AND `partno` = 'MC-500A-500V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.006773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15373365 [ RunTime:0.007453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57671816 LIMIT 5 [ RunTime:0.004497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671816 ORDER BY `minOrder` ASC [ RunTime:0.004026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57671816 ORDER BY `unit` DESC [ RunTime:0.003016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57671816 LIMIT 2 [ RunTime:0.008073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671816 ORDER BY `minOrder` ASC [ RunTime:0.001164s ]
select * from pdf where partno='MC-500A-400V' and brandshort='Altech Corporation' limit 1 [ RunTime:0.006882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500A-400V' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.004198s ]
SELECT `id` FROM `stock` WHERE `id` <> 57671816 AND `partno` = 'MC-500A-400V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.015856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292559 [ RunTime:0.008451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57671815 LIMIT 5 [ RunTime:0.013233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671815 ORDER BY `minOrder` ASC [ RunTime:0.006571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57671815 ORDER BY `unit` DESC [ RunTime:0.008028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57671815 LIMIT 2 [ RunTime:0.010919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57671815 ORDER BY `minOrder` ASC [ RunTime:0.010019s ]
select * from pdf where partno='MC-500A-300V' and brandshort='Altech Corporation' limit 1 [ RunTime:0.010359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC-500A-300V' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.006897s ]
SELECT `id` FROM `stock` WHERE `id` <> 57671815 AND `partno` = 'MC-500A-300V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.003988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19292558 [ RunTime:0.004670s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006046s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002863s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008661s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001450s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003387s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006113s ]
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 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002213s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MC-5%' OR `brand` LIKE 'MC-5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004999s ]