Query Metrics
7
Database Queries
7
Different statements
403.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.60 ms (51.90%) |
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 6669 17190 27757 188699 226028 249788 291356 365933 391133 396657 397425 401189 401281 410264 417080 419447 425474 428860 435078 442631 443986 444234 446626 455745 457585 457701 457736 458925 459666 468705 469236 472972 474270 474487 480402 483814 485501 488719 490859 500098 503117 508177 512880 512948 519243 531929 535053 537943 541532 541568 542223 554192 555428 555601 558903 561306 566687 569225 579746 591861 602251 604327 605218 618923 637471 649105 649838 651876 655601 659408 660051 661287 671429 671743 674001 674452 685513 693353 693532 704915 705710 705731 706250 710890 711631 711905 714473 715102 717900 719142 719314 720386 720732 722019 724023 726922 727780 728713 738630 743165 749109 756002 756081 756091 756192 758028 766668 769091 785418 789672 798737 800304 805640 806243 815991 821134 821892 822155 823351 825536 ] |
||||||||||||||||||||||||||||||
|
173.84 ms (43.05%) |
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 6669 17190 27757 188699 226028 249788 291356 365933 391133 396657 397425 401189 401281 410264 417080 419447 425474 428860 435078 442631 443986 444234 446626 455745 457585 457701 457736 458925 459666 468705 469236 472972 474270 474487 480402 483814 485501 488719 490859 500098 503117 508177 512880 512948 519243 531929 535053 537943 541532 541568 542223 554192 555428 555601 558903 561306 566687 569225 579746 591861 602251 604327 605218 618923 637471 649105 649838 651876 655601 659408 660051 661287 671429 671743 674001 674452 685513 693353 693532 704915 705710 705731 706250 710890 711631 711905 714473 715102 717900 719142 719314 720386 720732 722019 724023 726922 727780 728713 738630 743165 749109 756002 756081 756091 756192 758028 766668 769091 785418 789672 798737 800304 805640 806243 815991 821134 821892 822155 823351 825536 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (3.34%) |
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 428860 419447 474270 512948 508177 541568 457585 226028 555601 6669 401281 815991 822155 823351 821892 825536 821134 531929 555428 660051 693353 711631 705731 291356 488719 566687 685513 705710 365933 457701 435078 443986 468705 396657 569225 659408 671743 800304 758028 720732 472972 480402 561306 458925 500098 554192 602251 474487 425474 541532 661287 693532 591861 397425 410264 503117 537943 483814 512880 459666 714473 756192 649838 446626 401189 535053 651876 798737 756091 455745 711905 806243 769091 738630 749109 618923 579746 188699 391133 715102 249788 785418 444234 457736 485501 27757 728713 17190 490859 519243 649105 674452 704915 655601 719142 720386 674001 710890 717900 604327 637471 805640 743165 756002 766668 724023 726922 727780 756081 706250 719314 722019 789672 442631 469236 558903 542223 671429 605218 417080 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public solo anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц соло анал"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.