Why magento2 outputs the query while showing data from ResourceModel collection Factory..?How to add filtering to custom table field column in Customers admin grid in Magento2?Magento 2.1 Create a filter in the product grid by new attributeMagento 2: toolbar url problems in custom module with custom routerMagento 2: I Want to add multiple product using checkboxI have created one field using product form field for my price i want save my field value at product creation time from backend magento2Magento 2.2.5: Add, Update and Delete existing products Custom OptionsMagento 2.3 Can't view module's front end page output?Magento2 REST API get all customers detailscannot save my custom attribut product before save event magento 2Why product collection query not showing “color” attribute in select?

Soft question: Examples where lack of mathematical rigour cause security breaches?

Preventing Employees from either switching to Competitors or Opening Their Own Business

How did students remember what to practise between lessons without any sheet music?

Russian equivalents of "no love lost"

How would a aircraft visually signal "in distress"?

Why is one of Madera Municipal's runways labelled with only "R" on both sides?

Arriving at the same result with the opposite hypotheses

Which comes first? Multiple Imputation, Splitting into train/test, or Standardization/Normalization

How do governments keep track of their issued currency?

Where does "0 packages can be updated." come from?

When conversion from Integer to Single may lose precision

Is an early checkout possible at a hotel before its reception opens?

Should I compare a std::string to "string" or "string"s?

How can drunken, homicidal elves successfully conduct a wild hunt?

My coworkers think I had a long honeymoon. Actually I was diagnosed with cancer. How do I talk about it?

Why doesn't Adrian Toomes give up Spider-Man's identity?

BGP convergence issue

Random Unitary Matrices

Payment instructions allegedly from HomeAway look fishy to me

What could have caused a rear derailleur to end up in the back wheel suddenly?

Movie about a boy who was born old and grew young

Are there downsides to using std::string as a buffer?

Is it a problem if <h4>, <h5> and <h6> are smaller than regular text?

How is water heavier than petrol, even though its molecular weight is less than petrol?



Why magento2 outputs the query while showing data from ResourceModel collection Factory..?


How to add filtering to custom table field column in Customers admin grid in Magento2?Magento 2.1 Create a filter in the product grid by new attributeMagento 2: toolbar url problems in custom module with custom routerMagento 2: I Want to add multiple product using checkboxI have created one field using product form field for my price i want save my field value at product creation time from backend magento2Magento 2.2.5: Add, Update and Delete existing products Custom OptionsMagento 2.3 Can't view module's front end page output?Magento2 REST API get all customers detailscannot save my custom attribut product before save event magento 2Why product collection query not showing “color” attribute in select?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















protected $productCollectionFactory;


public function __construct(
.....
CustomMyModuleModelResourceModelProductCollectionFactory $productCollectionFactory,
...
)
$this->productCollectionFactory = $productCollectionFactory;
....


public function execute()

$collection = $this->productCollectionFactory->create()->load(1)->getData();
var_dump($collection);
die();
return $collection;



Output:



SELECT `main_table`.* FROM `custom_mymodule` AS `main_table`
/home/magento2/Custom/MyModule/Controller/Product/products.php:68:
array (size=1)
0 =>
array (size=6)
'id' => string '1' (length=1)
'product_name' => string 'Moongoose' (length=30)
'product_sku' => string 'Moo74' (length=3)









share|improve this question






























    0















    protected $productCollectionFactory;


    public function __construct(
    .....
    CustomMyModuleModelResourceModelProductCollectionFactory $productCollectionFactory,
    ...
    )
    $this->productCollectionFactory = $productCollectionFactory;
    ....


    public function execute()

    $collection = $this->productCollectionFactory->create()->load(1)->getData();
    var_dump($collection);
    die();
    return $collection;



    Output:



    SELECT `main_table`.* FROM `custom_mymodule` AS `main_table`
    /home/magento2/Custom/MyModule/Controller/Product/products.php:68:
    array (size=1)
    0 =>
    array (size=6)
    'id' => string '1' (length=1)
    'product_name' => string 'Moongoose' (length=30)
    'product_sku' => string 'Moo74' (length=3)









    share|improve this question


























      0












      0








      0








      protected $productCollectionFactory;


      public function __construct(
      .....
      CustomMyModuleModelResourceModelProductCollectionFactory $productCollectionFactory,
      ...
      )
      $this->productCollectionFactory = $productCollectionFactory;
      ....


      public function execute()

      $collection = $this->productCollectionFactory->create()->load(1)->getData();
      var_dump($collection);
      die();
      return $collection;



      Output:



      SELECT `main_table`.* FROM `custom_mymodule` AS `main_table`
      /home/magento2/Custom/MyModule/Controller/Product/products.php:68:
      array (size=1)
      0 =>
      array (size=6)
      'id' => string '1' (length=1)
      'product_name' => string 'Moongoose' (length=30)
      'product_sku' => string 'Moo74' (length=3)









      share|improve this question
















      protected $productCollectionFactory;


      public function __construct(
      .....
      CustomMyModuleModelResourceModelProductCollectionFactory $productCollectionFactory,
      ...
      )
      $this->productCollectionFactory = $productCollectionFactory;
      ....


      public function execute()

      $collection = $this->productCollectionFactory->create()->load(1)->getData();
      var_dump($collection);
      die();
      return $collection;



      Output:



      SELECT `main_table`.* FROM `custom_mymodule` AS `main_table`
      /home/magento2/Custom/MyModule/Controller/Product/products.php:68:
      array (size=1)
      0 =>
      array (size=6)
      'id' => string '1' (length=1)
      'product_name' => string 'Moongoose' (length=30)
      'product_sku' => string 'Moo74' (length=3)






      magento2 collection query resource-model factory






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited May 30 at 5:34









      Muhammad Wasif

      15311




      15311










      asked May 29 at 12:03









      Arshad SyedArshad Syed

      73




      73




















          1 Answer
          1






          active

          oldest

          votes


















          1














          It's because you have pass 1 in load() method




          MagentoFrameworkDataCollectionAbstractDb check in abstrctDb class




           public function load($printQuery = false, $logQuery = false)

          if ($this->isLoaded())
          return $this;


          return $this->loadWithFilter($printQuery, $logQuery);



          if you pass 1 it means $printQuery=true
          that's why query printed






          share|improve this answer























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "479"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f276577%2fwhy-magento2-outputs-the-query-while-showing-data-from-resourcemodel-collection%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            It's because you have pass 1 in load() method




            MagentoFrameworkDataCollectionAbstractDb check in abstrctDb class




             public function load($printQuery = false, $logQuery = false)

            if ($this->isLoaded())
            return $this;


            return $this->loadWithFilter($printQuery, $logQuery);



            if you pass 1 it means $printQuery=true
            that's why query printed






            share|improve this answer



























              1














              It's because you have pass 1 in load() method




              MagentoFrameworkDataCollectionAbstractDb check in abstrctDb class




               public function load($printQuery = false, $logQuery = false)

              if ($this->isLoaded())
              return $this;


              return $this->loadWithFilter($printQuery, $logQuery);



              if you pass 1 it means $printQuery=true
              that's why query printed






              share|improve this answer

























                1












                1








                1







                It's because you have pass 1 in load() method




                MagentoFrameworkDataCollectionAbstractDb check in abstrctDb class




                 public function load($printQuery = false, $logQuery = false)

                if ($this->isLoaded())
                return $this;


                return $this->loadWithFilter($printQuery, $logQuery);



                if you pass 1 it means $printQuery=true
                that's why query printed






                share|improve this answer













                It's because you have pass 1 in load() method




                MagentoFrameworkDataCollectionAbstractDb check in abstrctDb class




                 public function load($printQuery = false, $logQuery = false)

                if ($this->isLoaded())
                return $this;


                return $this->loadWithFilter($printQuery, $logQuery);



                if you pass 1 it means $printQuery=true
                that's why query printed







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered May 29 at 12:18









                Rutvee SojitraRutvee Sojitra

                2,1151321




                2,1151321



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Magento Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f276577%2fwhy-magento2-outputs-the-query-while-showing-data-from-resourcemodel-collection%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

                    Circuit construction for execution of conditional statements using least significant bitHow are two different registers being used as “control”?How exactly is the stated composite state of the two registers being produced using the $R_zz$ controlled rotations?Efficiently performing controlled rotations in HHLWould this quantum algorithm implementation work?How to prepare a superposed states of odd integers from $1$ to $sqrtN$?Why is this implementation of the order finding algorithm not working?Circuit construction for Hamiltonian simulationHow can I invert the least significant bit of a certain term of a superposed state?Implementing an oracleImplementing a controlled sum operation

                    Magento 2 “No Payment Methods” in Admin New OrderHow to integrate Paypal Express Checkout with the Magento APIMagento 1.5 - Sales > Order > edit order and shipping methods disappearAuto Invoice Check/Money Order Payment methodAdd more simple payment methods?Shipping methods not showingWhat should I do to change payment methods if changing the configuration has no effects?1.9 - No Payment Methods showing upMy Payment Methods not Showing for downloadable/virtual product when checkout?Magento2 API to access internal payment methodHow to call an existing payment methods in the registration form?