Query Metrics
7
Database Queries
7
Different statements
199.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.81 ms (82.91%) |
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 7365 32999 66866 123862 186948 187775 187786 187954 187960 188437 233292 311237 358792 368335 381842 382405 382971 382982 383508 385606 387856 389623 389729 390582 390734 391392 391669 392030 392054 392489 392671 393418 393502 396032 397000 397227 397861 397886 398553 405859 406067 407763 407819 411353 411986 428817 439721 444255 448708 451488 454886 457515 460757 460906 465347 466109 466173 466231 466244 466986 468097 469341 471411 471449 472905 474161 474861 476284 476348 477718 479047 479112 481955 484379 484435 484586 484594 484598 484608 484686 486345 486470 487338 487360 506028 511536 516562 519306 520867 523572 526745 532125 544489 546716 547605 548182 550220 552324 562596 566940 573918 585158 588084 591046 665406 702179 712827 728317 728446 748242 777167 782234 785438 790614 794705 795594 799971 801226 820309 827054 ] |
||||||||||||||||||||||||||||||
|
21.95 ms (10.97%) |
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 186948 187954 32999 391392 405859 411353 407819 486470 481955 454886 477718 520867 523572 566940 546716 548182 544489 573918 550220 585158 748242 728317 187960 390734 448708 457515 465347 387856 389623 397886 439721 460906 466109 476284 479047 460757 471449 466244 479112 428817 466173 468097 516562 484435 484594 511536 519306 526745 487338 484379 484586 484598 484608 484686 486345 382405 7365 406067 820309 702179 665406 588084 794705 777167 782234 392489 392030 392671 368335 233292 311237 358792 827054 411986 469341 474161 552324 801226 785438 391669 506028 532125 712827 790614 795594 382971 487360 474861 562596 187775 407763 476348 466986 471411 547605 591046 799971 728446 187786 389729 397861 398553 390582 451488 466231 392054 472905 188437 444255 385606 66866 383508 382982 123862 393502 393418 381842 396032 397227 397000 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.07%) |
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 7365 32999 66866 123862 186948 187775 187786 187954 187960 188437 233292 311237 358792 368335 381842 382405 382971 382982 383508 385606 387856 389623 389729 390582 390734 391392 391669 392030 392054 392489 392671 393418 393502 396032 397000 397227 397861 397886 398553 405859 406067 407763 407819 411353 411986 428817 439721 444255 448708 451488 454886 457515 460757 460906 465347 466109 466173 466231 466244 466986 468097 469341 471411 471449 472905 474161 474861 476284 476348 477718 479047 479112 481955 484379 484435 484586 484594 484598 484608 484686 486345 486470 487338 487360 506028 511536 516562 519306 520867 523572 526745 532125 544489 546716 547605 548182 550220 552324 562596 566940 573918 585158 588084 591046 665406 702179 712827 728317 728446 748242 777167 782234 785438 790614 794705 795594 799971 801226 820309 827054 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature boy"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mature парен"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mature парен"
]
|
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.