Query Metrics
7
Database Queries
7
Different statements
131.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
111.35 ms (84.41%) |
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 493945 500821 507848 525299 534868 539317 545872 546367 547087 554882 558400 560895 567772 578166 582729 590652 591246 601639 603940 604892 605978 609194 612888 614001 617229 623745 626613 626678 629549 632892 638157 640252 641222 641322 648655 649633 652750 653894 655603 660455 660826 662076 663301 671239 674894 676659 678921 681941 682413 682854 685250 685398 685411 687452 687644 689994 691149 692164 694846 699156 699902 701207 707616 708081 708329 710554 713352 715407 716290 723279 725043 725538 728511 732264 733764 734097 738541 741064 741860 743892 745554 745873 745933 750132 750169 751967 752135 757887 761501 761990 766167 767973 768400 768570 769193 772763 773184 775543 775739 777335 778083 778217 778696 778710 782308 782782 786753 788352 789451 795335 796233 797123 801266 803985 804482 806680 809672 825381 ] |
||||||||||||||||||||||||||||||
|
10.83 ms (8.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 809672 734097 752135 733764 761501 778217 778696 590652 640252 507848 554882 660826 681941 687644 671239 674894 682413 685398 653894 663301 676659 678921 685411 708081 710554 546367 626613 605978 591246 601639 617229 641322 751967 612888 629549 632892 638157 699156 708329 713352 743892 500821 757887 767973 725024 803985 745873 707616 825381 578166 689994 692164 682854 648655 623745 558400 652750 694846 525299 493945 567772 649633 691149 715407 655603 662076 685250 687452 604892 614001 603940 626678 641222 741860 699902 777335 801266 539317 534868 716290 582729 796233 725043 773184 728511 745554 750169 732264 738541 750132 723279 775739 797123 609194 772763 701207 741064 560895 660455 782308 547087 545872 782782 788352 768400 745933 772129 778083 778710 804482 775543 786753 806680 769193 795335 761990 766167 725538 768570 789451 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateurs homemade"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (1.72%) |
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 493945 500821 507848 525299 534868 539317 545872 546367 547087 554882 558400 560895 567772 578166 582729 590652 591246 601639 603940 604892 605978 609194 612888 614001 617229 623745 626613 626678 629549 632892 638157 640252 641222 641322 648655 649633 652750 653894 655603 660455 660826 662076 663301 671239 674894 676659 678921 681941 682413 682854 685250 685398 685411 687452 687644 689994 691149 692164 694846 699156 699902 701207 707616 708081 708329 710554 713352 715407 716290 723279 725043 725538 728511 732264 733764 734097 738541 741064 741860 743892 745554 745873 745933 750132 750169 751967 752135 757887 761501 761990 766167 767973 768400 768570 769193 772763 773184 775543 775739 777335 778083 778217 778696 778710 782308 782782 786753 788352 789451 795335 796233 797123 801266 803985 804482 806680 809672 825381 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.