Query Metrics
7
Database Queries
7
Different statements
113.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русском языке"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.36 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 652931 653459 653512 670818 659216 663347 659323 661528 570866 588730 593989 601454 617342 625215 626385 614906 616089 621239 610419 600407 617597 618943 524524 652947 590493 599144 598142 652893 614953 611984 623404 603994 614609 421907 439534 443425 554928 659328 659369 613880 623678 625359 625983 590448 601947 620236 621228 619539 622832 626062 685469 595862 605416 605865 602655 614013 597975 603765 617056 620124 597134 598954 603971 606002 618359 620215 601924 609225 609259 620995 621988 467867 572344 597002 613179 623405 626126 591176 613318 625884 575794 600069 598215 625870 513604 625001 541866 649185 593372 ] |
||||||||||||||||||||||||||||||
| 4 | 2.30 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 421907 439534 443425 467867 513604 524524 541866 554928 570866 572344 575794 588730 590448 590493 591176 593372 593989 595862 597002 597134 597975 598142 598215 598954 599144 600069 600407 601454 601924 601947 602655 603765 603971 603994 605416 605865 606002 609225 609259 610419 611984 613179 613318 613880 614013 614609 614906 614953 616089 617056 617342 617597 618359 618943 619539 620124 620215 620236 620995 621228 621239 621988 622832 623404 623405 623678 625001 625215 625359 625870 625884 625983 626062 626126 626385 649185 652893 652931 652947 653459 653512 659216 659323 659328 659369 661528 663347 670818 685469 ] |
||||||||||||||||||||||||||||||
| 5 | 84.76 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 421907 439534 443425 467867 513604 524524 541866 554928 570866 572344 575794 588730 590448 590493 591176 593372 593989 595862 597002 597134 597975 598142 598215 598954 599144 600069 600407 601454 601924 601947 602655 603765 603971 603994 605416 605865 606002 609225 609259 610419 611984 613179 613318 613880 614013 614609 614906 614953 616089 617056 617342 617597 618359 618943 619539 620124 620215 620236 620995 621228 621239 621988 622832 623404 623405 623678 625001 625215 625359 625870 625884 625983 626062 626126 626385 649185 652893 652931 652947 653459 653512 659216 659323 659328 659369 661528 663347 670818 685469 ] |
||||||||||||||||||||||||||||||
| 6 | 1.72 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск язык"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.41 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск язык"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.