Query Metrics
7
Database Queries
7
Different statements
186.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.35 ms (84.44%) |
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 6670 384807 385092 389024 391247 391588 391703 393741 396249 399414 400426 401105 401313 401344 401655 402266 404765 404950 410606 413296 416181 416185 417647 419855 422500 422631 422923 422925 423039 423245 428018 428113 445564 447242 465953 472179 474626 476808 482080 487315 491487 493206 495792 503802 517014 522466 526029 526030 529854 530632 541879 543720 556015 559214 560191 561826 561833 565160 566621 567605 574870 576650 577366 577369 590731 591312 597066 598444 598470 605339 611001 612363 622394 624231 627740 627804 627810 627813 628403 632969 634510 636555 637023 637520 638985 646245 648543 651136 655838 656575 665698 666968 668524 670250 707312 707322 709588 714473 715707 720374 720816 722823 724934 725112 725409 730728 732312 741584 748950 749911 751457 758871 766858 775962 804469 807557 810069 814119 814266 815740 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (9.40%) |
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 741584 732312 730728 624231 709588 722823 391703 401313 591312 612363 815740 720816 715707 384807 389024 404765 423039 491487 526030 391588 428018 399414 402266 401655 416181 422631 413296 814119 495792 530632 561833 565160 543720 655838 670250 646245 656575 665698 714473 574870 598444 622394 637520 807557 725409 724934 725112 748950 632969 6670 416185 474626 422923 428113 598470 627810 627740 804469 810069 636555 422925 401344 556015 566621 597066 476808 391247 396249 567605 707312 560191 541879 627804 627813 637023 576650 400426 423245 422500 472179 561826 590731 766858 385092 493206 526029 401105 419855 417647 522466 465953 559214 651136 707322 666968 577369 628403 410606 447242 404950 445564 503802 487315 517014 648543 720374 393741 668524 605339 749911 577366 758871 775962 751457 482080 814266 529854 634510 611001 638985 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.37%) |
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 6670 384807 385092 389024 391247 391588 391703 393741 396249 399414 400426 401105 401313 401344 401655 402266 404765 404950 410606 413296 416181 416185 417647 419855 422500 422631 422923 422925 423039 423245 428018 428113 445564 447242 465953 472179 474626 476808 482080 487315 491487 493206 495792 503802 517014 522466 526029 526030 529854 530632 541879 543720 556015 559214 560191 561826 561833 565160 566621 567605 574870 576650 577366 577369 590731 591312 597066 598444 598470 605339 611001 612363 622394 624231 627740 627804 627810 627813 628403 632969 634510 636555 637023 637520 638985 646245 648543 651136 655838 656575 665698 666968 668524 670250 707312 707322 709588 714473 715707 720374 720816 722823 724934 725112 725409 730728 732312 741584 748950 749911 751457 758871 766858 775962 804469 807557 810069 814119 814266 815740 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young tits"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young сиськ"
]
|
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.