Magento 2 Debugging Tricks - MySQL Query, fetchAll, fetchRow, Data Hydrate & PHP xDebug by Matheus Gontijo

magento-2-debugging-tricks-mysql-query-fetchall-fetchrow-data-hydrate-and-xdebug.php

Magento 2 Debugging Tricks - MySQL Query, fetchAll, fetchRow, Data Hydrate & PHP xDebug by Matheus Gontijo
Video: https://www.youtube.com/watch?v=xLf3OwpAFhQ

-----------------------------------------------

1) Track MySQL queries

vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php::query
vendor/magento/zendframework1/library/Zend/Db/Select.php

// stripos($sql, 'tablenamehere') !== false

Real World examples:

Example 01 | What is the query for "catalog_product_entity_varchar" table?
Example 02 | What is the query for "eav_attribute_option_value" table?
Example 03 | What is the query for "review_detail" table?
Example 04 | What is the query for "catalog_product_entity_media_gallery" table?


-----------------------------------------------


2) Track the queries result's

vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php

Methods:

- fetchAll    (*) most used
- fetchRow    (*) most used
- fetchAssoc
- fetchCol
- fetchPairs
- fetchOne

<?php

foreach ($result as $row) {
    foreach ($row as $key => $value) {
        $breakpoint = null; // is_scalar($value) && stripos($value, 'montana') !== false
    }
}

?>

Real World examples:

Example 01 | Where is the "Montana Wind Jacket" product name is coming from?
Example 02 | Where is the "Purple"?
Example 03 | Where is the "talking about here" review description is coming from?
Example 04 | Where is the "mj03-black_back_1.jpg" image is coming from?