Query Metrics
7
Database Queries
7
Different statements
144.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.10 ms (83.16%) |
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 28568 107606 233135 386913 387104 388329 388766 398348 398909 401014 401621 404386 404664 411811 413112 413223 421372 421887 421917 423497 424096 428846 439709 448954 460188 469487 472299 473921 493899 513114 522614 564298 565142 567340 590302 591944 593605 596488 599572 606384 606752 634559 646290 646668 662140 670753 674770 678940 680284 687211 687583 692049 693356 693535 695186 698554 699061 699590 706250 707309 710368 711606 715807 717677 719022 719025 719994 721562 725362 726988 727653 733284 735027 736522 736784 740617 742588 744775 756223 758504 759927 759982 761103 765454 766600 766650 766670 782626 782636 784816 785847 786094 787155 788131 788610 789532 790846 793951 795140 797186 801338 802036 805360 805706 805735 808401 815053 815402 815512 815704 816985 817269 817330 817825 818051 818469 818609 821536 822121 828539 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (9.89%) |
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 793951 421372 788131 744775 591944 721562 787155 386913 493899 413112 797186 736522 670753 473921 233135 401014 439709 522614 513114 693535 28568 805360 815402 634559 758504 782636 472299 717677 710368 766600 413223 801338 802036 756223 765454 726988 107606 448954 695186 725362 788610 401621 469487 421917 388766 565142 398909 424096 387104 646668 423497 719022 606752 567340 784816 795140 766650 790846 817269 662140 428846 693356 766670 698554 687211 805706 759927 761103 404664 460188 742588 818469 818609 421887 719025 678940 789532 727653 735027 706250 715807 815053 699590 808401 785847 805735 759982 388329 411811 398348 815704 818051 817330 822121 828539 564298 404386 816985 680284 606384 821536 815512 817825 719994 699061 711606 687583 707309 646290 674770 692049 599572 733284 786094 736784 596488 782626 590302 593605 740617 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (2.31%) |
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 28568 107606 233135 386913 387104 388329 388766 398348 398909 401014 401621 404386 404664 411811 413112 413223 421372 421887 421917 423497 424096 428846 439709 448954 460188 469487 472299 473921 493899 513114 522614 564298 565142 567340 590302 591944 593605 596488 599572 606384 606752 634559 646290 646668 662140 670753 674770 678940 680284 687211 687583 692049 693356 693535 695186 698554 699061 699590 706250 707309 710368 711606 715807 717677 719022 719025 719994 721562 725362 726988 727653 733284 735027 736522 736784 740617 742588 744775 756223 758504 759927 759982 761103 765454 766600 766650 766670 782626 782636 784816 785847 786094 787155 788131 788610 789532 790846 793951 795140 797186 801338 802036 805360 805706 805735 808401 815053 815402 815512 815704 816985 817269 817330 817825 818051 818469 818609 821536 822121 828539 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал milf"
]
|
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.