Query Metrics
7
Database Queries
7
Different statements
169.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.21 ms (84.51%) |
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 330715 382057 389729 392054 393102 404644 411731 418905 421814 421829 421855 421918 421927 422141 425360 428807 429049 433356 439674 439770 440771 440916 442415 443182 446269 446276 446277 448459 449232 453716 457686 457858 457991 458012 458731 459251 459783 461017 464440 465316 469370 472652 490740 492304 493178 493179 493189 493247 500796 502809 502813 513115 513366 513784 523827 523846 525354 526323 526450 530083 531923 531995 532004 532133 549823 549848 549849 550330 557924 559048 563423 582197 602707 604681 605666 608415 622667 640941 665278 667660 695087 699564 701247 704174 709503 712201 712311 715536 719443 725440 725442 725456 726588 726871 728150 735909 741769 743479 746165 746188 748241 749773 753515 757114 758443 759898 761951 772322 782153 782503 788161 794611 794654 795983 801112 807454 808200 809790 813922 825428 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (9.37%) |
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 500796 502813 523827 665278 549848 457858 457991 608415 640941 725442 725456 725440 469370 490740 782153 759898 741769 807454 712311 421829 421855 382057 550330 442415 443182 418905 459251 464440 446277 449232 458012 513366 513784 532004 531923 513115 563423 604681 795983 726871 794654 735909 753515 757114 448459 421814 459783 782503 461017 493179 465316 458731 825428 532133 525354 667660 788161 809790 728150 772322 715536 433356 472652 748241 404644 429049 453716 493247 439770 523846 526450 549849 389729 440771 493189 502809 330715 726588 758443 439674 421927 622667 425360 712201 605666 808200 761951 746188 699564 794611 549823 457686 421918 422141 440916 393102 813922 530083 559048 411731 493178 446269 557924 428807 446276 492304 531995 582197 695087 719443 701247 704174 602707 801112 743479 746165 749773 709503 526323 392054 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.78%) |
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 330715 382057 389729 392054 393102 404644 411731 418905 421814 421829 421855 421918 421927 422141 425360 428807 429049 433356 439674 439770 440771 440916 442415 443182 446269 446276 446277 448459 449232 453716 457686 457858 457991 458012 458731 459251 459783 461017 464440 465316 469370 472652 490740 492304 493178 493179 493189 493247 500796 502809 502813 513115 513366 513784 523827 523846 525354 526323 526450 530083 531923 531995 532004 532133 549823 549848 549849 550330 557924 559048 563423 582197 602707 604681 605666 608415 622667 640941 665278 667660 695087 699564 701247 704174 709503 712201 712311 715536 719443 725440 725442 725456 726588 726871 728150 735909 741769 743479 746165 746188 748241 749773 753515 757114 758443 759898 761951 772322 782153 782503 788161 794611 794654 795983 801112 807454 808200 809790 813922 825428 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son жоп"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son ass"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son жоп"
]
|
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.