Query Metrics
7
Database Queries
7
Different statements
143.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.50 ms (81.37%) |
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 434337 475925 508938 513209 514925 519364 538066 548985 550905 552378 554836 556079 557218 557607 557707 562161 562575 572636 576483 576597 577311 577561 580109 583492 584374 593208 599187 600718 609556 612131 613516 614759 617682 618242 618283 618547 620581 622046 624916 630732 632402 632940 634745 634750 639155 641604 644135 644785 647132 648704 651962 653126 663338 673214 677227 697464 698252 705769 706721 707408 707466 710408 712221 712800 715574 724985 729974 733030 736862 739903 740418 740648 742373 744153 745629 748266 748314 748693 749754 753170 759338 760511 769097 769528 777986 783905 784958 785975 788560 788931 789520 791336 791796 792715 793694 794165 794630 794991 796472 796738 796837 796911 797058 800953 801310 801529 801830 802870 803510 805341 809877 810372 814162 818502 823368 825376 826501 826827 827648 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (11.25%) |
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 548985 557607 572636 697464 700933 712221 647132 550905 622046 644135 600718 618242 788931 796738 801830 759338 769097 724985 791336 797058 803510 826501 826827 818502 538066 577561 583492 663338 673214 634745 789520 793694 805341 753170 740418 614759 618283 801529 576597 715574 794991 784958 760511 748266 744153 618547 796472 648704 707466 644785 729974 508938 557707 827648 519364 791796 792715 475925 823368 706721 710408 639155 777986 742373 707408 577311 584374 651962 712800 617682 630732 634750 800953 802870 739903 769528 736862 612131 434337 513209 613516 599187 814162 825376 514925 576483 580109 552378 556079 557218 562575 653126 705769 698252 554836 562161 620581 641604 609556 624916 593208 632940 783905 796837 788560 748314 785975 794165 794630 801310 733030 749754 740648 745629 748693 632402 796911 809877 810372 677227 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape my pussy"
]
|
||||||||||||||||||||||||||||||
|
2.32 ms (1.62%) |
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 434337 475925 508938 513209 514925 519364 538066 548985 550905 552378 554836 556079 557218 557607 557707 562161 562575 572636 576483 576597 577311 577561 580109 583492 584374 593208 599187 600718 609556 612131 613516 614759 617682 618242 618283 618547 620581 622046 624916 630732 632402 632940 634745 634750 639155 641604 644135 644785 647132 648704 651962 653126 663338 673214 677227 697464 698252 705769 706721 707408 707466 710408 712221 712800 715574 724985 729974 733030 736862 739903 740418 740648 742373 744153 745629 748266 748314 748693 749754 753170 759338 760511 769097 769528 777986 783905 784958 785975 788560 788931 789520 791336 791796 792715 793694 794165 794630 794991 796472 796738 796837 796911 797058 800953 801310 801529 801830 802870 803510 805341 809877 810372 814162 818502 823368 825376 826501 826827 827648 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.20%) |
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.