Query Metrics
7
Database Queries
7
Different statements
172.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.15 ms (84.12%) |
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 403725 417219 422166 422205 426616 426988 433323 439476 439710 443321 450119 450127 450140 450152 450161 450166 450198 453110 455988 458336 460575 463940 464410 464554 465318 465599 470462 470708 472403 473332 474317 474385 474451 475540 478265 478405 481315 483193 485388 487470 489323 492623 496902 497344 503481 506350 507674 510776 511126 513441 515320 517528 517839 519165 522638 526881 527894 528387 531423 531947 531994 533460 539788 547610 555124 555339 555749 557594 561483 561600 562964 564113 565493 579371 583146 589648 591014 599735 607359 608029 609814 614499 629826 641919 647610 654167 661913 662650 674675 694105 710497 726396 726419 728486 738313 760184 766341 769393 771791 789269 793547 794953 795216 795632 795737 796851 797360 799422 800974 802295 802733 807889 810317 819819 820369 821399 821761 823526 825214 826560 ] |
||||||||||||||||||||||||||||||
|
15.94 ms (9.24%) |
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 674675 647610 662650 561600 607359 795216 464554 472403 475540 503481 526881 519165 528387 510776 513441 726419 439476 473332 789269 422166 506350 496902 795737 807889 820369 826560 819819 821761 825214 823526 470462 464410 531994 522638 531947 539788 517839 565493 555749 654167 694105 661913 555339 589648 641919 599735 796851 799422 800974 802733 802295 810317 766341 797360 726396 728486 738313 760184 769393 771791 629826 710497 793547 794953 443321 417219 450119 450152 450166 450198 460575 463940 450140 453110 465318 492623 450127 455988 474317 485388 564113 583146 547610 614499 608029 465599 450161 474385 474451 470708 478405 478265 481315 511126 527894 483193 507674 515320 426988 422205 433323 555124 489323 517528 579371 557594 562964 609814 439710 497344 591014 487470 795632 426616 403725 458336 531423 821399 533460 561483 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.06%) |
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 403725 417219 422166 422205 426616 426988 433323 439476 439710 443321 450119 450127 450140 450152 450161 450166 450198 453110 455988 458336 460575 463940 464410 464554 465318 465599 470462 470708 472403 473332 474317 474385 474451 475540 478265 478405 481315 483193 485388 487470 489323 492623 496902 497344 503481 506350 507674 510776 511126 513441 515320 517528 517839 519165 522638 526881 527894 528387 531423 531947 531994 533460 539788 547610 555124 555339 555749 557594 561483 561600 562964 564113 565493 579371 583146 589648 591014 599735 607359 608029 609814 614499 629826 641919 647610 654167 661913 662650 674675 694105 710497 726396 726419 728486 738313 760184 766341 769393 771791 789269 793547 794953 795216 795632 795737 796851 797360 799422 800974 802295 802733 807889 810317 819819 820369 821399 821761 823526 825214 826560 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pov blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature пов минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature пов минет оральн секс"
]
|
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.