Query Metrics
7
Database Queries
7
Different statements
178.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.88 ms (84.14%) |
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 7295 66907 188064 188437 386734 387711 388792 390568 391251 391959 392952 396040 397879 401108 407867 407871 411468 424472 439662 439722 439729 439778 439856 440932 440937 440996 442814 443777 444255 452308 454369 463851 463991 464159 465217 466021 466196 466218 466247 466679 466840 466897 468088 468359 469311 469351 470197 470397 470402 470965 471696 472891 473446 473450 476176 477128 478002 480758 489317 490782 491899 503992 504025 518332 518454 518762 522364 522609 524779 526089 530451 531840 531866 532365 534559 539741 540548 547420 547429 547464 550902 552285 552593 555082 555220 555337 558898 561002 566770 576503 580356 593365 604673 612989 616387 617152 618468 624837 627362 660701 680250 715879 720713 742729 756683 761018 763547 766647 775024 782477 782657 790974 792533 800573 801338 802337 803537 812314 813226 813947 ] |
||||||||||||||||||||||||||||||
|
17.21 ms (9.66%) |
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 386734 188064 392952 66907 397879 401108 440932 469311 473450 518454 539741 540548 526089 466679 468359 576503 552285 555337 561002 566770 624837 604673 627362 763547 803537 766647 391959 407871 478002 470965 477128 466196 524779 522609 466897 466021 470197 443777 188437 444255 391251 471696 463991 470397 473446 518762 531866 534559 504025 532365 468088 547420 547464 555082 547429 552593 555220 612989 618468 782657 790974 800573 742729 813226 756683 761018 720713 387711 424472 439729 490782 558898 439662 439856 466218 7295 439722 411468 439778 442814 440996 466247 472891 491899 440937 469351 489317 465217 480758 454369 518332 522364 593365 617152 802337 792533 407867 476176 390568 466840 470402 388792 452308 463851 464159 503992 396040 813947 530451 531840 550902 580356 680250 660701 715879 616387 775024 782477 812314 801338 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (2.07%) |
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 7295 66907 188064 188437 386734 387711 388792 390568 391251 391959 392952 396040 397879 401108 407867 407871 411468 424472 439662 439722 439729 439778 439856 440932 440937 440996 442814 443777 444255 452308 454369 463851 463991 464159 465217 466021 466196 466218 466247 466679 466840 466897 468088 468359 469311 469351 470197 470397 470402 470965 471696 472891 473446 473450 476176 477128 478002 480758 489317 490782 491899 503992 504025 518332 518454 518762 522364 522609 524779 526089 530451 531840 531866 532365 534559 539741 540548 547420 547429 547464 550902 552285 552593 555082 555220 555337 558898 561002 566770 576503 580356 593365 604673 612989 616387 617152 618468 624837 627362 660701 680250 715879 720713 742729 756683 761018 763547 766647 775024 782477 782657 790974 792533 800573 801338 802337 803537 812314 813226 813947 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал milf"
]
|
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.