What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hello Team Please let me know how can I know which database query is running behind the scenes. Is t

U03TXRYL7U7
U03TXRYL7U7 Posts: 64 🧑🏻‍🚀 - Cadet

Hello Team
Please let me know how can I know which database query is running behind the scenes. Is there any query log or any function where database query can be printed

Comments

  • Chemaclass
    Chemaclass Tech Lead Spryker Solution Partner Posts: 213 🧑🏻‍🚀 - Cadet
    edited August 2022

    Yes, add to your config_local.php 🎯

    use Spryker\Shared\Propel\PropelConstants;
    
    $config[PropelConstants::PROPEL_DEBUG] = true;
    

    Then, you’ll have the raw SQL 👉🏼 data/logs/ZED/propel.log

    💡 Check Spryker\Zed\Propel::getLogPath()
    ```

    public function getLogPath(): string

    {
    $basePath = APPLICATION_ROOT_DIR . '/data/logs/';

    if (!is_writable($basePath)) {
        $basePath = $this->getBCBaseLogPath();
    }
    
    $defaultPath = $basePath . 'ZED/propel.log';
    
    return $this->get(PropelConstants::LOG_FILE_PATH, $defaultPath);
    

    }

    ```
    >

  • U03TXRYL7U7
    U03TXRYL7U7 Posts: 64 🧑🏻‍🚀 - Cadet

    ok thanks!