StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to get information how doctrine query was build
text
Body
copied!<p>I use doctrine 1.2, in symfony 1.4.8 . Here is my code:</p> <pre><code>private function getWithMaxProductsQ($limit){ $query = Doctrine_Query::create() ->select('m.name, COUNT(p.manufacturer_id) AS c') ->from('manufacturer m') ->innerJoin('m.Product p') ->where('p.is_published = 1') ->addWhere('p.is_available = 1') ->groupBy('p.manufacturer_id') ->orderBy('c DESC') ->limit($limit); //die($query->getSqlQuery()); return $query; } public function getManufacturersForCategoryDeep(Category $cat, $limit = 7){ $ids = $cat->getDescendantsAndMeIds(); $q = $this->getWithMaxProductsQ($limit); $q->innerJoin('p.Category c')->whereIn('c.id', $ids); die($q->getSqlQuery()); $mans = $q->execute(); return $mans; } </code></pre> <p>As you may notice there is <code>die</code> call inside <code>getManufacturersForCategoryDeep</code> which gives me info what query will be executed. Here is sql query:</p> <pre><code>SELECT `m`.`id` AS `m__id`, `m`.`name` AS `m__name`, COUNT(`p`.`manufacturer_id`) AS `p__0` FROM `manufacturer` `m` INNER JOIN `product` `p` ON `m`.`id` = `p`.`manufacturer_id` INNER JOIN `category` `c` ON `p`.`category_id` = `c`.`id` WHERE `m`.`id` IN ('49', '43', '127', '42', '65', '134', '113') AND (`p`.`is_published` = 1 AND `p`.`is_available` = 1 AND `c`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `p`.`manufacturer_id` ORDER BY `p__0` DESC </code></pre> <p>And I dont know why this line appear in query <code>WHERE m.id IN ('49', '43', '127', '42', '65', '134', '113')</code> I used apc and memcached caching for DQL query parsing caching, but it was disabled a month ago. So how i can find out what is happening with this query ?</p> <p><strong>UPDATE:</strong> this line is dissapears after removal <code>limit()</code> invocation</p> <p><strong>UPDATE2:</strong> here is open bug <a href="http://www.doctrine-project.org/jira/browse/DC-1052?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab" rel="nofollow">http://www.doctrine-project.org/jira/browse/DC-1052?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload