Query Metrics
7
Database Queries
7
Different statements
195.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.78 ms (87.58%) |
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 424284 427233 434688 437809 442472 449854 457571 480314 481121 499169 503999 514627 518383 527052 539797 556716 558865 564652 566393 587747 590042 594632 595716 596450 601588 601970 602768 616236 624684 624961 627656 627754 627758 631116 634892 634950 635125 635129 639092 645391 671193 675160 675180 675618 675628 675828 680573 681952 682376 692651 693398 696231 699892 706754 718351 720010 723227 723264 723713 723817 728667 734445 735307 736252 739140 740220 741266 751322 753099 753998 754986 762739 763946 765197 766519 768983 769043 769258 772280 772404 772523 773463 779619 779688 779721 781188 781591 784356 786355 787312 787579 787611 787842 789120 790188 791263 791873 792730 793199 793237 793289 793700 795471 799446 800180 800953 801074 801182 803648 805235 808107 812860 813647 814090 816132 817263 818552 819372 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (7.89%) |
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 595716 602768 616236 635125 590042 793289 675628 556716 675618 753099 799446 723264 442472 427233 816132 817263 813647 539797 514627 558865 634892 723713 769258 772280 803648 812860 740220 723817 753998 735307 765197 635129 720010 779619 457571 763946 819372 566393 693398 718351 800180 781188 789120 791873 793199 795471 741266 787842 801074 681952 675180 675828 564652 587747 624961 631116 639092 594632 627754 627656 634950 766519 624684 706754 503999 596450 671193 801182 736252 434688 499169 627758 779721 786355 791263 779688 787611 792730 728667 772404 772523 787312 793700 734445 754986 768983 769043 773463 751322 728648 437809 741836 601588 424284 814090 818552 645391 699892 800953 793237 805235 808107 739140 784356 787579 481121 675160 696231 692651 790188 449854 518383 682376 680573 601970 781591 762739 723227 480314 527052 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.34%) |
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 424284 427233 434688 437809 442472 449854 457571 480314 481121 499169 503999 514627 518383 527052 539797 556716 558865 564652 566393 587747 590042 594632 595716 596450 601588 601970 602768 616236 624684 624961 627656 627754 627758 631116 634892 634950 635125 635129 639092 645391 671193 675160 675180 675618 675628 675828 680573 681952 682376 692651 693398 696231 699892 706754 718351 720010 723227 723264 723713 723817 728667 734445 735307 736252 739140 740220 741266 751322 753099 753998 754986 762739 763946 765197 766519 768983 769043 769258 772280 772404 772523 773463 779619 779688 779721 781188 781591 784356 786355 787312 787579 787611 787842 789120 790188 791263 791873 792730 793199 793237 793289 793700 795471 799446 800180 800953 801074 801182 803648 805235 808107 812860 813647 814090 816132 817263 818552 819372 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск passionate"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade passionate"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск passionate"
]
|
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.