Query Metrics
7
Database Queries
7
Different statements
138.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.16 ms (83.37%) |
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 386483 396305 410124 415114 425588 438040 443459 453730 465153 465405 466825 479608 491350 493019 499964 499987 499995 506246 508730 512413 516226 516489 518004 522645 531935 535872 540387 543592 547636 559260 560455 560793 563789 603204 604704 605675 608439 613319 627362 630547 636147 636399 641687 660028 679895 696350 699291 714658 714980 716341 719936 720550 724596 724698 727739 728305 729863 731148 732176 742562 746561 757488 758166 759752 759947 760953 762020 765028 773271 777421 780469 785299 786550 788026 788565 791442 791560 791578 791589 791594 791860 793302 793500 794729 795680 795956 795971 796008 796156 796157 796202 796480 797238 799718 799894 800608 800721 801302 805256 805258 805259 809590 817175 817330 818760 819966 823952 824044 824268 824334 824716 825418 825711 826346 826637 827055 827207 827632 828555 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (10.28%) |
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 826346 696350 719936 512413 796202 805259 516489 547636 438040 499964 762020 627362 800608 826637 724596 731148 819966 535872 493019 531935 479608 791578 796008 727739 827055 453730 660028 605675 559260 824268 759947 825711 793500 788026 785299 805256 728305 827632 465153 763214 724698 396305 823952 699291 636147 636399 746561 794729 796157 797238 641687 791589 828555 824716 425588 729863 765028 415114 827207 608439 714980 817330 799894 791442 817175 720550 796480 795971 793302 732176 491350 757488 516226 543592 540387 777421 773271 800721 760953 443459 560793 465405 499995 508730 506246 518004 805258 824334 818760 825418 786550 791560 791594 799718 795680 796156 742562 791860 795956 466825 780469 759752 613319 386483 560455 758166 410124 630547 788565 522645 499987 603204 809590 801302 714658 604704 824044 563789 679895 716341 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.83%) |
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 386483 396305 410124 415114 425588 438040 443459 453730 465153 465405 466825 479608 491350 493019 499964 499987 499995 506246 508730 512413 516226 516489 518004 522645 531935 535872 540387 543592 547636 559260 560455 560793 563789 603204 604704 605675 608439 613319 627362 630547 636147 636399 641687 660028 679895 696350 699291 714658 714980 716341 719936 720550 724596 724698 727739 728305 729863 731148 732176 742562 746561 757488 758166 759752 759947 760953 762020 765028 773271 777421 780469 785299 786550 788026 788565 791442 791560 791578 791589 791594 791860 793302 793500 794729 795680 795956 795971 796008 796156 796157 796202 796480 797238 799718 799894 800608 800721 801302 805256 805258 805259 809590 817175 817330 818760 819966 823952 824044 824268 824334 824716 825418 825711 826346 826637 827055 827207 827632 828555 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum mother"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum мам женщин"
]
|
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.