Query Metrics
7
Database Queries
7
Different statements
203.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.90 ms (81.54%) |
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 404568 419989 422725 423786 453473 455088 481047 481664 485152 491276 492576 496074 496835 498045 498830 499889 514819 517725 517849 517853 520405 522785 523291 525348 527689 527988 528406 530015 530043 530489 532737 532790 533353 533364 536586 537763 537771 541316 542965 562110 570149 570162 570179 573938 576192 576616 576721 578451 579296 580405 582376 583905 583952 588249 589345 590149 590298 591618 591668 593544 595805 599934 600008 600251 600258 600293 600429 601585 601620 604094 604465 604550 604551 604554 605442 605539 606499 612439 617414 617429 620206 622990 625444 627750 629961 632333 634156 634793 634856 637540 639735 642315 642665 643122 644256 644961 645812 646841 648855 648863 648867 649188 651135 662023 666575 674984 677303 679742 765604 787020 788132 788260 792558 795514 809290 811506 814991 815697 815735 816086 ] |
||||||||||||||||||||||||||||||
|
26.26 ms (12.91%) |
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 562110 570179 576721 583905 541316 542965 570149 570162 573938 578451 583952 648863 648867 679742 645812 648855 651135 674984 649188 662023 666575 576192 576616 579296 580405 591618 599934 600293 601585 601620 604094 604465 606499 620206 625444 634156 600008 604550 604554 605442 612439 617429 622990 637540 639735 642315 590149 590298 591668 595805 600258 642665 643122 644256 588249 589345 593544 600251 600429 605539 634793 787020 788132 811506 788260 795514 765604 604551 617414 632333 792558 809290 404568 423786 481047 481664 419989 455088 422725 453473 517725 517849 527689 485152 496074 528406 492576 496835 523291 525348 491276 499889 520405 527988 530043 677303 646841 582376 627750 629961 634856 514819 644961 816086 814991 815697 815735 517853 522785 532790 537763 537771 530489 532737 533364 536586 498045 498830 530015 533353 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (1.80%) |
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 404568 419989 422725 423786 453473 455088 481047 481664 485152 491276 492576 496074 496835 498045 498830 499889 514819 517725 517849 517853 520405 522785 523291 525348 527689 527988 528406 530015 530043 530489 532737 532790 533353 533364 536586 537763 537771 541316 542965 562110 570149 570162 570179 573938 576192 576616 576721 578451 579296 580405 582376 583905 583952 588249 589345 590149 590298 591618 591668 593544 595805 599934 600008 600251 600258 600293 600429 601585 601620 604094 604465 604550 604551 604554 605442 605539 606499 612439 617414 617429 620206 622990 625444 627750 629961 632333 634156 634793 634856 637540 639735 642315 642665 643122 644256 644961 645812 646841 648855 648863 648867 649188 651135 662023 666575 674984 677303 679742 765604 787020 788132 788260 792558 795514 809290 811506 814991 815697 815735 816086 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom milf bbc"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom milf bbc"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom milf bbc"
]
|
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.