Query Metrics
7
Database Queries
7
Different statements
581.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
411.85 ms (70.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
144.42 ms (24.83%) |
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 28242 233333 270601 365992 387015 388687 390217 391677 396127 396563 401858 402201 402242 402736 410741 413690 416335 418774 424574 425875 425889 428044 432738 435943 439027 440649 441409 441420 441430 441472 441611 441614 443905 443919 444661 445285 445828 447321 447910 452922 452978 453485 454278 456558 457514 458755 463304 463382 470082 470228 470929 472323 474036 476006 479496 480075 483611 484053 484717 485919 486363 489888 490387 499388 499868 503688 508505 509099 509645 509725 513557 513690 521868 521889 524502 525028 543548 543823 545185 573607 588786 590461 590818 591933 592418 595400 597057 597059 598501 598544 598674 605829 685523 688939 696154 705106 707164 725169 734330 735401 741249 751308 752725 753495 766287 766479 766885 769052 774649 775208 778875 779005 782991 783707 787452 787484 791181 792455 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (2.91%) |
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 766479 769052 778875 441472 452978 503688 441420 425889 458755 499388 752725 401858 28242 696154 388687 413690 416335 425875 445828 447910 410741 463382 390217 457514 470082 486363 508505 688939 605829 792455 779005 782991 735401 753495 766885 741249 766287 774649 441614 445285 428044 484717 509725 590461 590818 402242 441409 453485 454278 456558 391677 470929 489888 513557 483611 521889 474036 440649 524502 396563 432738 443905 787452 769740 441430 441611 751308 233333 435943 463304 573607 597057 598674 591933 480075 452922 447321 521868 734330 705106 707164 783707 439027 490387 597059 444661 424574 443919 543548 592418 588786 595400 472323 418774 402736 525028 509645 484053 499868 543823 598501 725169 270601 402201 470228 387015 479496 509099 513690 485919 685523 598544 805512 476006 787484 396127 791181 365992 545185 775208 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.52%) |
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 28242 233333 270601 365992 387015 388687 390217 391677 396127 396563 401858 402201 402242 402736 410741 413690 416335 418774 424574 425875 425889 428044 432738 435943 439027 440649 441409 441420 441430 441472 441611 441614 443905 443919 444661 445285 445828 447321 447910 452922 452978 453485 454278 456558 457514 458755 463304 463382 470082 470228 470929 472323 474036 476006 479496 480075 483611 484053 484717 485919 486363 489888 490387 499388 499868 503688 508505 509099 509645 509725 513557 513690 521868 521889 524502 525028 543548 543823 545185 573607 588786 590461 590818 591933 592418 595400 597057 597059 598501 598544 598674 605829 685523 688939 696154 705106 707164 725169 734330 735401 741249 751308 752725 753495 766287 766479 766885 769052 774649 775208 778875 779005 782991 783707 787452 787484 791181 792455 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.24%) |
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.