Query Metrics
7
Database Queries
7
Different statements
150.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.98 ms (80.57%) |
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 390865 400964 405804 443494 456955 458614 465031 465119 472774 478524 482984 484806 484807 490566 494269 496283 496330 505797 517652 518184 519892 521845 521852 522629 524869 526445 530304 530317 531533 532814 533939 535072 535395 535885 537618 540243 542661 560914 564403 569424 570405 572247 576770 584385 584504 585263 585733 586153 587181 587441 589654 593240 593560 594077 595004 600406 600871 601733 602496 604158 605058 605407 608007 611547 614409 637459 644207 647743 649381 650895 652052 660687 662874 665770 666820 667758 671374 675389 692023 695337 695343 714089 732346 735033 736199 736249 737632 737653 737720 738674 739761 741024 742149 750871 754774 760249 775190 775508 787608 788245 789104 789614 792627 792819 793214 795443 802181 806362 807299 807660 807741 807809 808262 808270 809280 809696 809707 814672 823707 826607 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (10.57%) |
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 750871 400964 496330 570405 490566 600871 737720 405804 532814 826607 814672 482984 530304 530317 533939 531533 535395 540243 478524 650895 662874 665770 666820 647743 660687 667758 564403 569424 572247 614409 587181 593240 602496 637459 644207 595004 608007 789104 802181 806362 809707 775508 793214 736199 807299 807660 807741 808270 760249 735033 737632 741024 809280 517652 526445 754774 458614 605058 494269 807809 788245 484807 671374 692023 585263 737653 518184 601733 456955 465119 496283 519892 521845 522629 524869 535072 535885 537618 542661 584385 649381 652052 714089 675389 695337 695343 560914 576770 584504 600406 593560 594077 605407 585733 587441 589654 775190 792819 787608 808262 736249 739761 742149 732346 738674 789614 809696 465031 390865 484806 586153 472774 505797 792627 604158 611547 795443 521852 443494 823707 ] |
||||||||||||||||||||||||||||||
|
5.56 ms (3.70%) |
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 390865 400964 405804 443494 456955 458614 465031 465119 472774 478524 482984 484806 484807 490566 494269 496283 496330 505797 517652 518184 519892 521845 521852 522629 524869 526445 530304 530317 531533 532814 533939 535072 535395 535885 537618 540243 542661 560914 564403 569424 570405 572247 576770 584385 584504 585263 585733 586153 587181 587441 589654 593240 593560 594077 595004 600406 600871 601733 602496 604158 605058 605407 608007 611547 614409 637459 644207 647743 649381 650895 652052 660687 662874 665770 666820 667758 671374 675389 692023 695337 695343 714089 732346 735033 736199 736249 737632 737653 737720 738674 739761 741024 742149 750871 754774 760249 775190 775508 787608 788245 789104 789614 792627 792819 793214 795443 802181 806362 807299 807660 807741 807809 808262 808270 809280 809696 809707 814672 823707 826607 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife ebony"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.16%) |
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.