Query Metrics
7
Database Queries
7
Different statements
163.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.60 ms (84.62%) |
1 |
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 46283 61762 65883 69063 69782 124400 361909 382420 382613 383224 387296 389146 389749 389926 390922 392739 393462 394218 395901 395934 396346 396424 396887 397222 397388 397619 397874 397948 398809 400822 401649 402700 402842 403870 406278 406362 407809 407877 411397 411752 418133 423793 426005 426389 428283 432338 443335 443972 444202 446249 446763 448931 453633 455448 456945 457218 457371 459665 461504 469402 469486 474398 474413 476021 478123 479054 480760 485251 488069 488070 489327 493888 496574 496669 498907 498915 499707 499998 502241 506100 506318 508508 509812 510110 518815 519183 523269 526048 527804 535206 548224 553714 555854 559997 563207 563686 567074 570084 573756 574519 591171 598988 627654 697704 716268 716460 733799 742138 768709 773408 773904 780906 782227 783155 788001 788371 788872 791016 791414 794616 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (9.00%) |
1 |
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 523269 493888 498907 527804 489327 509812 506318 510110 526048 426005 383224 395901 395934 69063 387296 396424 397222 426389 411752 446249 469486 457218 453633 469402 474398 697704 563207 598988 788872 397874 432338 455448 397619 411397 443972 461504 382613 396346 401649 716268 563686 773904 124400 390922 574519 627654 398809 406278 423793 407809 443335 480760 535206 485251 570084 553714 555854 548224 559997 567074 573756 591171 444202 476021 418133 479054 478123 428283 488069 496669 508508 496574 498915 499707 502241 506100 518815 519183 499998 65883 394218 361909 61762 389926 396887 397948 400822 448931 456945 474413 457371 488070 716460 780906 782227 788371 788001 791016 794616 783155 791414 733799 742138 768709 773408 46283 392739 402842 403870 389146 389749 397388 402700 407877 69782 393462 446763 459665 382420 406362 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.59%) |
1 |
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 46283 61762 65883 69063 69782 124400 361909 382420 382613 383224 387296 389146 389749 389926 390922 392739 393462 394218 395901 395934 396346 396424 396887 397222 397388 397619 397874 397948 398809 400822 401649 402700 402842 403870 406278 406362 407809 407877 411397 411752 418133 423793 426005 426389 428283 432338 443335 443972 444202 446249 446763 448931 453633 455448 456945 457218 457371 459665 461504 469402 469486 474398 474413 476021 478123 479054 480760 485251 488069 488070 489327 493888 496574 496669 498907 498915 499707 499998 502241 506100 506318 508508 509812 510110 518815 519183 523269 526048 527804 535206 548224 553714 555854 559997 563207 563686 567074 570084 573756 574519 591171 598988 627654 697704 716268 716460 733799 742138 768709 773408 773904 780906 782227 783155 788001 788371 788872 791016 791414 794616 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"парень кончает спермой"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен сперм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.96%) |
1 |
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.