Query Metrics
7
Database Queries
7
Different statements
156.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.58 ms (84.06%) |
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 123070 142579 274100 391873 392990 398628 398773 419052 431516 453481 454496 462161 463157 464039 464374 470572 471771 473326 475907 477393 491021 497524 504281 504302 504622 508470 509228 509862 517635 520751 533736 533801 534143 534147 535724 536886 543365 543416 544768 545414 547074 548676 563662 566432 589154 592350 593873 595817 596288 603163 605525 606584 607155 610066 613333 613375 618001 622158 644729 649644 653440 663546 670051 670721 675236 675921 675951 676309 676397 676895 676896 684096 692453 694894 699844 707464 709784 712466 712675 714193 714844 714851 715395 715518 716373 716804 724304 724449 729264 731195 737893 741114 759634 759672 766306 767281 773553 773948 773974 773982 775895 775934 776307 779148 787667 787686 790679 792007 793712 796450 797940 798411 801147 801978 806377 809493 811866 812798 814692 819320 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (9.10%) |
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 622158 618001 566432 670721 707464 712675 563662 644729 724304 610066 504302 814692 534143 545414 649644 653440 775895 787686 766306 606584 398628 391873 142579 398773 431516 464374 535724 536886 543365 547074 676397 692453 712466 676309 714851 675236 676895 694894 699844 716804 592350 596288 595817 605525 613333 809493 775934 792007 729264 767281 773553 787667 759634 759672 773948 773982 731195 741114 773974 715518 776307 790679 812798 477393 462161 504281 464039 684096 811866 475907 463157 544768 663546 603163 491021 470572 454496 533801 471771 548676 670051 796450 419052 819320 517635 520751 504622 509228 533736 534147 543416 709784 715395 675951 714193 714844 716373 675921 676896 589154 593873 607155 613375 793712 801147 801978 798411 797940 724449 737893 779148 806377 453481 473326 509862 508470 497524 123070 392990 274100 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.89%) |
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 123070 142579 274100 391873 392990 398628 398773 419052 431516 453481 454496 462161 463157 464039 464374 470572 471771 473326 475907 477393 491021 497524 504281 504302 504622 508470 509228 509862 517635 520751 533736 533801 534143 534147 535724 536886 543365 543416 544768 545414 547074 548676 563662 566432 589154 592350 593873 595817 596288 603163 605525 606584 607155 610066 613333 613375 618001 622158 644729 649644 653440 663546 670051 670721 675236 675921 675951 676309 676397 676895 676896 684096 692453 694894 699844 707464 709784 712466 712675 714193 714844 714851 715395 715518 716373 716804 724304 724449 729264 731195 737893 741114 759634 759672 766306 767281 773553 773948 773974 773982 775895 775934 776307 779148 787667 787686 790679 792007 793712 796450 797940 798411 801147 801978 806377 809493 811866 812798 814692 819320 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск группов"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашняя групповую"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск группов"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
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.