Query Metrics
7
Database Queries
7
Different statements
401.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.18 ms (52.40%) |
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 546705 547610 547780 550560 551020 553242 553285 554517 555928 556537 557519 557933 558106 560222 560984 563121 563462 564197 564611 569539 571728 571931 578719 579163 579170 581514 582553 582560 585799 586800 588365 589204 591375 591608 592221 592450 592852 592870 593014 594114 594778 594826 597081 597827 598438 599139 599981 601014 601133 601373 601503 601691 602568 603003 603359 603558 603795 604028 606095 606436 606605 606747 607597 609870 611265 611813 614105 615311 618845 624865 628328 630192 634736 635194 635203 644175 647140 647403 650213 652586 652773 653300 653330 655405 659270 659380 660613 663936 664612 664836 664854 665493 670383 670565 672324 672344 672367 672975 673082 674255 674587 674618 680892 681446 682098 682124 683047 684064 684066 684067 684688 686572 686593 688287 689862 689897 689932 690797 690841 709292 ] |
||||||||||||||||||||||||||||||
|
167.94 ms (41.87%) |
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 546705 547610 547780 550560 551020 553242 553285 554517 555928 556537 557519 557933 558106 560222 560984 563121 563462 564197 564611 569539 571728 571931 578719 579163 579170 581514 582553 582560 585799 586800 588365 589204 591375 591608 592221 592450 592852 592870 593014 594114 594778 594826 597081 597827 598438 599139 599981 601014 601133 601373 601503 601691 602568 603003 603359 603558 603795 604028 606095 606436 606605 606747 607597 609870 611265 611813 614105 615311 618845 624865 628328 630192 634736 635194 635203 644175 647140 647403 650213 652586 652773 653300 653330 655405 659270 659380 660613 663936 664612 664836 664854 665493 670383 670565 672324 672344 672367 672975 673082 674255 674587 674618 680892 681446 682098 682124 683047 684064 684066 684067 684688 686572 686593 688287 689862 689897 689932 690797 690841 709292 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (4.06%) |
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 681446 684064 684066 686593 690797 690841 647403 650213 652586 652773 653300 659380 663936 664854 665493 670383 672324 672344 672367 673082 680892 682098 682124 684067 686572 688287 647140 653330 655405 659270 660613 664612 664836 670565 672975 674255 674587 674618 683047 684688 689862 689897 689932 709292 546705 547610 547780 550560 551020 553242 553285 554517 555928 556537 557519 557933 558106 560222 560984 563121 563462 564197 564611 569539 571728 571931 578719 579163 579170 581514 582553 582560 586800 588365 589204 591608 592221 592450 592852 592870 594114 594826 597081 597827 599981 601014 601373 601691 603003 606095 606605 606747 607597 609870 611265 611813 614105 615311 618845 624865 628328 630192 634736 635194 635203 644175 585799 591375 593014 594778 598438 599139 601133 601503 602568 603359 603558 603795 604028 606436 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"шеи"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ше"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.36%) |
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.