Query Metrics
7
Database Queries
7
Different statements
157.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.62 ms (85.49%) |
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 405181 414621 416992 445740 449356 465198 475630 480432 483756 489373 492535 495734 495895 498045 498830 503051 510109 517853 518493 519093 519567 520068 521469 522785 523816 526920 528580 528839 529243 529375 530015 530489 532653 532737 532790 533353 533364 533697 536586 537200 537763 537771 543234 554394 559946 561119 561995 562846 568185 570164 570174 571266 576727 579425 583982 583996 587418 599932 599971 600252 600295 600972 603586 604483 605455 618601 624803 629918 630247 630546 632681 632694 634203 636053 637103 637148 639334 640022 642039 643050 643376 644718 644961 650175 650846 676110 683529 699756 702678 714522 716760 716882 720258 720260 721617 723512 726675 728440 732357 744597 744618 744624 750466 759464 772804 788262 788264 793662 797657 814741 814798 814816 814956 814991 815370 815410 815697 815735 815851 818439 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (8.74%) |
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 599971 600972 603586 605455 632681 636053 587418 618601 624803 772804 793662 726675 744597 744618 744624 759464 728440 732357 750466 630247 699756 716760 797657 583982 600252 630546 639334 642039 637148 644961 814991 815697 815735 517853 522785 532790 537763 537771 530489 532737 533364 536586 498045 498830 530015 533353 520068 529375 532653 533697 537200 561995 559946 576727 543234 650175 720260 721617 676110 716882 650846 599932 604483 634203 640022 644718 637103 600295 643050 643376 788264 629918 632694 702678 788262 414621 416992 465198 405181 445740 449356 480432 503051 521469 495734 526920 528580 483756 489373 492535 495895 510109 518493 519093 523816 529243 519567 475630 815370 815410 723512 814741 814798 814816 818439 814956 815851 528839 554394 568185 571266 562846 570164 579425 561119 570174 583996 683529 714522 720258 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.57%) |
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 405181 414621 416992 445740 449356 465198 475630 480432 483756 489373 492535 495734 495895 498045 498830 503051 510109 517853 518493 519093 519567 520068 521469 522785 523816 526920 528580 528839 529243 529375 530015 530489 532653 532737 532790 533353 533364 533697 536586 537200 537763 537771 543234 554394 559946 561119 561995 562846 568185 570164 570174 571266 576727 579425 583982 583996 587418 599932 599971 600252 600295 600972 603586 604483 605455 618601 624803 629918 630247 630546 632681 632694 634203 636053 637103 637148 639334 640022 642039 643050 643376 644718 644961 650175 650846 676110 683529 699756 702678 714522 716760 716882 720258 720260 721617 723512 726675 728440 732357 744597 744618 744624 750466 759464 772804 788262 788264 793662 797657 814741 814798 814816 814956 814991 815370 815410 815697 815735 815851 818439 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom beauty bbc"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom beauty bbc"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom beauty 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.