Query Metrics
7
Database Queries
7
Different statements
140.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.57 ms (84.44%) |
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 391983 393560 396911 401893 403163 405761 416969 426990 452212 491618 504334 520233 527864 544171 558694 577309 584985 585021 585035 591154 591452 592635 595671 596503 599091 599099 601726 609625 610001 611343 613493 619363 627218 627263 629340 629432 630084 630230 631281 632450 632920 633039 637512 637831 639153 640166 644617 649100 653728 657189 665939 669680 680746 682993 686494 687441 690035 691146 702860 707161 712755 714344 717447 720220 721688 723208 726272 726391 727384 728184 728492 728891 730668 735478 736280 736504 744956 749768 752462 753919 754238 754816 755110 755184 757925 757943 757992 758696 760386 763472 764759 764796 766390 768921 769123 773834 775089 779130 779939 780912 780947 781194 790354 792052 792198 799984 802242 804909 812255 813565 825154 825291 826735 826831 826982 827387 827418 828549 828676 ] |
||||||||||||||||||||||||||||||
|
11.91 ms (8.48%) |
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 727384 749768 755110 769123 802242 753919 773834 726272 726391 736280 736504 757992 758696 728492 728891 763472 764796 728184 764759 768921 627263 629432 631281 632450 633039 637831 639153 644617 702860 707161 680746 591452 585035 649100 657189 601726 632920 592635 599099 613493 595671 596503 630084 637512 591154 416969 426990 584985 520233 653728 781194 393560 826735 825291 826831 826982 827418 827387 825154 828676 828549 717447 721688 723208 780947 790354 792052 775089 779130 792198 804909 766390 744956 757943 760386 730668 735478 752462 754238 755184 766932 720220 780912 396911 401893 403163 799984 813565 558694 682993 687441 712755 669680 690035 691146 610001 619363 629340 779939 812255 757925 504334 527864 686494 665939 714344 627218 611343 640166 599091 609625 630230 405761 544171 577309 754816 391983 585021 452212 491618 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.90%) |
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 391983 393560 396911 401893 403163 405761 416969 426990 452212 491618 504334 520233 527864 544171 558694 577309 584985 585021 585035 591154 591452 592635 595671 596503 599091 599099 601726 609625 610001 611343 613493 619363 627218 627263 629340 629432 630084 630230 631281 632450 632920 633039 637512 637831 639153 640166 644617 649100 653728 657189 665939 669680 680746 682993 686494 687441 690035 691146 702860 707161 712755 714344 717447 720220 721688 723208 726272 726391 727384 728184 728492 728891 730668 735478 736280 736504 744956 749768 752462 753919 754238 754816 755110 755184 757925 757943 757992 758696 760386 763472 764759 764796 766390 768921 769123 773834 775089 779130 779939 780912 780947 781194 790354 792052 792198 799984 802242 804909 812255 813565 825154 825291 826735 826831 826982 827387 827418 828549 828676 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тату домашнее реально…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные домашн любительск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.14%) |
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.