Query Metrics
7
Database Queries
7
Different statements
164.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.91 ms (83.87%) |
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 11870 387050 397089 403229 409822 413142 417298 419330 420266 421539 433123 433202 433477 437635 443987 444109 445182 447242 447423 447434 447514 459166 461462 463927 467895 475059 476808 482086 487189 489522 513773 514638 550438 560637 565251 570046 574511 584066 595440 595485 595540 597818 598803 604321 606670 615005 616807 622875 626520 639950 643984 660727 673456 676778 677366 681533 684360 684501 698101 702621 706321 714449 715710 718655 719180 719214 720375 721390 722563 722597 722603 722617 722712 727827 727854 735951 741860 742144 743180 744225 746157 746803 746979 747147 748011 748434 749121 749343 750319 753269 753277 753279 753316 753333 753348 753360 753368 753369 753388 753395 753397 753418 753422 753854 753908 754182 754196 758214 760931 766810 767186 770431 777036 786294 789273 791725 797494 811634 817699 824184 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (8.95%) |
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 753279 753388 413142 824184 676778 626520 777036 749121 744225 387050 719180 721390 722603 677366 722712 560637 595440 743180 753277 753316 753269 753368 753422 766810 770431 727854 748434 746803 753348 753369 753397 786294 419330 684360 433123 433202 433477 447423 459166 513773 574511 702621 565251 570046 597818 714449 447242 421539 445182 463927 476808 482086 437635 447514 461462 443987 447434 487189 489522 817699 584066 550438 660727 681533 706321 684501 722617 595485 606670 622875 639950 595540 604321 797494 767186 791725 741860 758214 748011 754196 750319 11870 673456 715710 722563 722597 719214 720375 698101 746157 753908 811634 727827 742144 746979 753854 754182 760931 735951 747147 753333 753395 753418 749343 753360 615005 789273 397089 444109 718655 598803 616807 643984 467895 403229 409822 420266 417298 514638 475059 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (2.38%) |
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 11870 387050 397089 403229 409822 413142 417298 419330 420266 421539 433123 433202 433477 437635 443987 444109 445182 447242 447423 447434 447514 459166 461462 463927 467895 475059 476808 482086 487189 489522 513773 514638 550438 560637 565251 570046 574511 584066 595440 595485 595540 597818 598803 604321 606670 615005 616807 622875 626520 639950 643984 660727 673456 676778 677366 681533 684360 684501 698101 702621 706321 714449 715710 718655 719180 719214 720375 721390 722563 722597 722603 722617 722712 727827 727854 735951 741860 742144 743180 744225 746157 746803 746979 747147 748011 748434 749121 749343 750319 753269 753277 753279 753316 753333 753348 753360 753368 753369 753388 753395 753397 753418 753422 753854 753908 754182 754196 758214 760931 766810 767186 770431 777036 786294 789273 791725 797494 811634 817699 824184 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick teen"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза teen"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза teen"
]
|
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.