Query Metrics
7
Database Queries
7
Different statements
870.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
264.37 ms (30.38%) |
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 590461 471992 472344 786493 524648 479942 534540 716121 761143 770242 485903 778989 789052 403151 654187 777643 745142 150396 784298 728205 735712 704958 462273 423094 747098 501039 787013 739151 719308 800511 820856 538812 721890 614253 786757 736921 747500 181743 699590 614192 551183 398902 400428 660364 821482 769098 568475 401085 714056 451605 393039 478261 669357 606595 739445 445545 518308 440265 827996 428383 597169 820656 529574 715881 720419 636057 760902 455745 684393 531868 384419 401580 767218 697150 685531 820946 705753 665789 626295 614354 774021 747104 12203 514598 604424 440261 472337 819020 752987 724185 444281 523047 761490 732248 476122 483814 353401 660382 481140 817375 548113 649119 719249 768759 756878 512877 573202 694424 740982 409931 698994 761150 401089 767213 545473 550941 672938 531002 579681 720506 ] |
||||||||||||||||||||||||||||||
|
218.58 ms (25.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на real улиц анал"
]
|
||||||||||||||||||||||||||||||
|
212.25 ms (24.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public real anal"
]
|
||||||||||||||||||||||||||||||
|
167.68 ms (19.27%) |
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 12203 150396 181743 353401 384419 393039 398902 400428 401085 401089 401580 403151 409931 423094 428383 440261 440265 444281 445545 451605 455745 462273 471992 472337 472344 476122 478261 479942 481140 483814 485903 501039 512877 514598 518308 523047 524648 529574 531002 531868 534540 538812 545473 548113 550941 551183 568475 573202 579681 590461 597169 604424 606595 614192 614253 614354 626295 636057 649119 654187 660364 660382 665789 669357 672938 684393 685531 694424 697150 698994 699590 704958 705753 714056 715881 716121 719249 719308 720419 720506 721890 724185 728205 732248 735712 736921 739151 739445 740982 745142 747098 747104 747500 752987 756878 760902 761143 761150 761490 767213 767218 768759 769098 770242 774021 777643 778989 784298 786493 786757 787013 789052 800511 817375 819020 820656 820856 820946 821482 827996 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (0.45%) |
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 12203 150396 181743 353401 384419 393039 398902 400428 401085 401089 401580 403151 409931 423094 428383 440261 440265 444281 445545 451605 455745 462273 471992 472337 472344 476122 478261 479942 481140 483814 485903 501039 512877 514598 518308 523047 524648 529574 531002 531868 534540 538812 545473 548113 550941 551183 568475 573202 579681 590461 597169 604424 606595 614192 614253 614354 626295 636057 649119 654187 660364 660382 665789 669357 672938 684393 685531 694424 697150 698994 699590 704958 705753 714056 715881 716121 719249 719308 720419 720506 721890 724185 728205 732248 735712 736921 739151 739445 740982 745142 747098 747104 747500 752987 756878 760902 761143 761150 761490 767213 767218 768759 769098 770242 774021 777643 778989 784298 786493 786757 787013 789052 800511 817375 819020 820656 820856 820946 821482 827996 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на real улиц анал"
]
|
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.