Query Metrics
7
Database Queries
7
Different statements
168.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.60 ms (85.24%) |
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 401115 411775 412071 417081 417085 418363 444739 455311 464410 465605 465649 466429 466683 467632 478107 486023 486292 499332 501499 517932 525226 528614 531613 531894 531906 532621 533007 535878 536309 540537 554525 558304 562376 562796 573309 574460 585155 585754 596899 600206 600296 600355 601040 601558 602128 602970 603246 604435 604493 604569 605461 613079 614993 616336 616337 617800 621413 630521 631194 632690 633042 633124 634492 634528 639261 641914 646025 646029 669171 669225 669226 670109 678053 678128 692333 697381 699824 704267 722187 723726 724283 728050 729644 743066 744374 746846 755698 769888 776506 788993 789654 789758 800296 802432 802533 805110 805304 805606 805607 806167 806170 808810 809241 813799 814218 814661 816060 816979 817090 817109 817131 817786 820357 821384 822189 822277 822460 822559 823563 825789 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (9.04%) |
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 646025 646029 678128 574460 601040 616336 600206 600355 633124 632690 465605 467632 501499 517932 817090 820357 822189 822277 822559 825789 817786 813799 814661 822460 816060 817109 823563 455311 464410 486292 536309 697381 722187 585754 602128 604493 616337 596899 633042 630521 602970 613079 641914 800296 802432 805606 769888 805304 744374 617800 634528 788993 789758 806167 806170 401115 466429 478107 486023 533007 573309 562796 678053 600296 605461 614993 631194 604569 418363 525226 540537 528614 532621 531613 531894 531906 558304 554525 669171 704267 669225 670109 692333 669226 699824 639261 601558 621413 585155 603246 634492 789654 776506 805607 808810 809241 723726 729644 743066 802533 805110 746846 755698 724283 728050 604435 411775 412071 499332 562376 465649 444739 417085 417081 817131 816979 821384 814218 466683 535878 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.78%) |
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 401115 411775 412071 417081 417085 418363 444739 455311 464410 465605 465649 466429 466683 467632 478107 486023 486292 499332 501499 517932 525226 528614 531613 531894 531906 532621 533007 535878 536309 540537 554525 558304 562376 562796 573309 574460 585155 585754 596899 600206 600296 600355 601040 601558 602128 602970 603246 604435 604493 604569 605461 613079 614993 616336 616337 617800 621413 630521 631194 632690 633042 633124 634492 634528 639261 641914 646025 646029 669171 669225 669226 670109 678053 678128 692333 697381 699824 704267 722187 723726 724283 728050 729644 743066 744374 746846 755698 769888 776506 788993 789654 789758 800296 802432 802533 805110 805304 805606 805607 806167 806170 808810 809241 813799 814218 814661 816060 816979 817090 817109 817131 817786 820357 821384 822189 822277 822460 822559 823563 825789 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom and bbc"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom bbc"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.86%) |
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.