Query Metrics
7
Database Queries
7
Different statements
222.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.31 ms (88.49%) |
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 387550 395682 395686 396010 396249 396352 401278 402232 404950 415520 424877 426179 428029 428031 428993 432805 434743 435391 436316 445643 447434 447537 447949 448616 461454 462379 463917 473413 475144 476937 487206 488805 494072 503673 510674 510683 513718 522434 524037 528262 529034 529854 532799 532945 533012 534996 536636 536686 537187 537201 537673 539938 540333 544128 544796 544852 545267 556022 558186 565250 565251 567346 570130 575756 583132 585956 586423 590731 597233 597254 600219 602006 604243 604431 605323 614956 615258 627803 628089 628114 628403 630511 632608 632687 633804 634154 634158 634786 635225 637087 637089 637147 637445 642693 646875 646920 647313 650764 651180 655555 666536 666877 677125 678943 679653 680150 680151 680174 680177 680180 680193 680198 712797 780530 785727 788268 801965 811606 814554 820648 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (7.21%) |
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 537187 544128 567346 570130 647313 680193 600219 628403 396010 436316 404950 401278 447434 461454 463917 447537 820648 585956 615258 473413 536686 387550 426179 424877 428031 475144 494072 532799 532945 533012 537201 536636 540333 556022 646920 666877 655555 680174 558186 614956 605323 637445 642693 586423 628114 628089 602006 632608 632687 788268 396352 396249 447949 428029 445643 488805 513718 487206 528262 604243 785727 529854 677125 634158 510683 415520 814554 448616 537673 534996 510674 462379 544852 680151 680198 651180 678943 680177 680180 650764 666536 679653 680150 597254 634154 635225 637089 633804 637087 637147 780530 801965 811606 627803 634786 712797 434743 476937 529034 503673 522434 539938 583132 545267 565250 575756 544796 590731 428993 402232 395686 432805 524037 646875 565251 604431 597233 630511 395682 435391 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.02%) |
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 387550 395682 395686 396010 396249 396352 401278 402232 404950 415520 424877 426179 428029 428031 428993 432805 434743 435391 436316 445643 447434 447537 447949 448616 461454 462379 463917 473413 475144 476937 487206 488805 494072 503673 510674 510683 513718 522434 524037 528262 529034 529854 532799 532945 533012 534996 536636 536686 537187 537201 537673 539938 540333 544128 544796 544852 545267 556022 558186 565250 565251 567346 570130 575756 583132 585956 586423 590731 597233 597254 600219 602006 604243 604431 605323 614956 615258 627803 628089 628114 628403 630511 632608 632687 633804 634154 634158 634786 635225 637087 637089 637147 637445 642693 646875 646920 647313 650764 651180 655555 666536 666877 677125 678943 679653 680150 680151 680174 680177 680180 680193 680198 712797 780530 785727 788268 801965 811606 814554 820648 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens first anal"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens first анал"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens first анал"
]
|
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.