Query Metrics
7
Database Queries
7
Different statements
146.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.80 ms (83.81%) |
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 7329 120497 130289 191400 233386 381854 382818 384027 385992 388097 388635 388770 390561 391450 391523 395621 395861 396103 396222 396717 397054 397062 397371 397373 402232 402682 404263 407260 411418 415184 415191 418531 423645 439823 445439 449660 452608 452644 454107 473537 484692 490244 490859 493480 494697 494999 497269 499457 501652 525112 533982 555103 563870 565243 582785 588090 594406 599889 603464 615596 620196 620252 620261 625289 629661 630553 634541 652872 657074 657493 664760 667268 671660 672345 683560 693210 695124 695908 696450 712557 712697 713098 716077 717916 718790 721153 722644 726933 728220 731449 733872 739997 740163 740698 752690 755188 761589 769793 773737 785321 787131 793663 801414 803465 810207 811488 814324 816016 816052 816140 817379 817765 818342 818409 818473 819035 820890 822205 822535 823170 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (9.22%) |
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 695124 452644 599889 454107 423645 388635 499457 785321 721153 672345 634541 728220 769793 717916 402682 726933 418531 533982 397373 390561 657493 555103 397371 395621 712557 384027 396222 739997 718790 7329 130289 501652 388097 402232 396103 603464 816052 713098 683560 811488 620261 439823 191400 396717 814324 657074 761589 397054 793663 752690 484692 395861 404263 391523 388770 385992 494999 411418 382818 407260 233386 652872 625289 415191 445439 397062 630553 816016 816140 818409 818473 819035 818342 817765 822535 817379 722644 629661 615596 801414 731449 696450 594406 620252 449660 494697 120497 822205 490859 716077 773737 755188 740698 803465 810207 565243 712697 733872 740163 490244 525112 582785 588090 787131 415184 473537 493480 497269 391450 695908 452608 823170 563870 381854 820890 693210 664760 667268 671660 620196 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.21%) |
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 7329 120497 130289 191400 233386 381854 382818 384027 385992 388097 388635 388770 390561 391450 391523 395621 395861 396103 396222 396717 397054 397062 397371 397373 402232 402682 404263 407260 411418 415184 415191 418531 423645 439823 445439 449660 452608 452644 454107 473537 484692 490244 490859 493480 494697 494999 497269 499457 501652 525112 533982 555103 563870 565243 582785 588090 594406 599889 603464 615596 620196 620252 620261 625289 629661 630553 634541 652872 657074 657493 664760 667268 671660 672345 683560 693210 695124 695908 696450 712557 712697 713098 716077 717916 718790 721153 722644 726933 728220 731449 733872 739997 740163 740698 752690 755188 761589 769793 773737 785321 787131 793663 801414 803465 810207 811488 814324 816016 816052 816140 817379 817765 818342 818409 818473 819035 820890 822205 822535 823170 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat anal"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глубокийминет минет оральн секс анал"
]
|
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.