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

                    Get product attribute by attribute group code in magento 2get product attribute by product attribute group in magento 2Magento 2 Log Bundle Product Data in List Page?How to get all product attribute of a attribute group of Default attribute set?Magento 2.1 Create a filter in the product grid by new attributeMagento 2 : Get Product Attribute values By GroupMagento 2 How to get all existing values for one attributeMagento 2 get custom attribute of a single product inside a pluginMagento 2.3 How to get all the Multi Source Inventory (MSI) locations collection in custom module?Magento2: how to develop rest API to get new productsGet product attribute by attribute group code ( [attribute_group_code] ) in magento 2

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

                    Magento 2.3: How do i solve this, Not registered handle, on custom form?How can i rewrite TierPrice Block in Magento2magento 2 captcha not rendering if I override layout xmlmain.CRITICAL: Plugin class doesn't existMagento 2 : Problem while adding custom button order view page?Magento 2.2.5: Overriding Admin Controller sales/orderMagento 2.2.5: Add, Update and Delete existing products Custom OptionsMagento 2.3 : File Upload issue in UI Component FormMagento2 Not registered handleHow to configured Form Builder Js in my custom magento 2.3.0 module?Magento 2.3. How to create image upload field in an admin form