Query Metrics
7
Database Queries
7
Different statements
165.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.45 ms (83.72%) |
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 493810 494690 496074 496835 499889 504423 508593 517725 517849 520405 523291 525348 527689 527988 528406 530043 533380 534268 534381 535024 537747 537917 541316 542965 545779 554927 556421 562110 570149 570162 570179 573938 575441 575721 576192 576616 576721 578451 579296 579369 580405 582373 583901 583905 583952 588249 589345 590149 590298 591618 591668 593544 595805 599934 600008 600251 600258 600293 600429 601514 601585 601620 604094 604465 604550 604551 604554 605442 605539 606499 612439 614742 617414 617429 620206 622990 625444 630915 632333 634156 634793 637540 639735 642315 642665 643122 644256 644961 645812 648855 648863 648867 649188 651135 662023 666575 674984 679742 765604 787020 788132 788260 792558 795514 806087 809290 811506 814991 816086 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (9.88%) |
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 534381 535024 537917 508593 533380 534268 537747 545779 575441 575721 579369 583901 556421 562110 570179 576721 583905 541316 542965 554927 570149 570162 573938 578451 583952 648863 648867 679742 645812 648855 651135 674984 649188 662023 666575 576192 576616 579296 580405 582373 591618 599934 600293 601514 601585 601620 604094 604465 606499 620206 625444 634156 600008 604550 604554 605442 612439 617429 622990 637540 639735 642315 590149 590298 591668 595805 600258 614742 642665 643122 644256 588249 589345 593544 600251 600429 605539 630915 634793 787020 788132 811506 788260 795514 765604 604551 617414 632333 792558 806087 809290 404568 423786 481047 481664 419989 455088 422725 453473 517725 517849 527689 485152 493810 496074 528406 492576 494690 496835 523291 525348 491276 499889 504423 520405 527988 530043 644961 816086 814991 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.69%) |
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 493810 494690 496074 496835 499889 504423 508593 517725 517849 520405 523291 525348 527689 527988 528406 530043 533380 534268 534381 535024 537747 537917 541316 542965 545779 554927 556421 562110 570149 570162 570179 573938 575441 575721 576192 576616 576721 578451 579296 579369 580405 582373 583901 583905 583952 588249 589345 590149 590298 591618 591668 593544 595805 599934 600008 600251 600258 600293 600429 601514 601585 601620 604094 604465 604550 604551 604554 605442 605539 606499 612439 614742 617414 617429 620206 622990 625444 630915 632333 634156 634793 637540 639735 642315 642665 643122 644256 644961 645812 648855 648863 648867 649188 651135 662023 666575 674984 679742 765604 787020 788132 788260 792558 795514 806087 809290 811506 814991 816086 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom with bbc"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom bbc"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom 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.