Query Metrics
7
Database Queries
7
Different statements
178.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.37 ms (86.35%) |
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 182754 233335 398287 417396 418122 429125 435605 450357 461955 462118 465456 469153 471999 477260 491242 512975 519626 528296 534791 536573 539318 555991 558631 562187 568265 585498 587787 588346 588392 589366 589991 590770 591226 593380 598153 598543 603508 605045 609784 618115 618237 618393 618932 624939 626885 629334 629828 631637 633300 639642 647697 649484 652235 661674 664175 669346 698619 704641 705221 707895 710224 710700 712386 713001 713706 714394 717553 719389 724987 739150 740569 740578 742330 744775 746575 752336 756702 758328 758339 769366 770252 772243 772261 772262 776034 776037 776774 777763 777767 778684 780526 782106 782665 783006 790500 790574 791057 791345 791892 792712 792978 796673 796988 796994 797002 799111 800676 800680 800682 802739 806764 807111 807122 807160 809018 809086 811109 813963 814035 814302 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (8.58%) |
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 562187 710700 649484 661674 705221 713001 664175 669346 710224 712386 719389 558631 588392 618932 633300 588346 618237 618393 629334 585498 587787 598153 629828 639642 589366 593380 778684 782665 790574 800676 800680 802739 807160 809086 776037 780526 783006 792978 797002 809018 811109 758328 772261 772262 796988 724987 739150 744775 770252 740569 740578 742330 746575 752336 756702 758339 769366 772243 698619 714394 776774 777767 782106 790500 796994 799111 800682 806764 807111 233335 429125 461955 491242 471999 792712 539318 450357 512975 534791 555991 609784 626885 417396 418122 477260 182754 398287 435605 813963 814035 814302 465456 469153 528296 536573 519626 462118 568265 707895 713706 717553 704641 647697 652235 589991 631637 591226 603508 590770 598543 618115 624939 605045 776034 791057 791345 807122 777763 791892 796673 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.20%) |
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 182754 233335 398287 417396 418122 429125 435605 450357 461955 462118 465456 469153 471999 477260 491242 512975 519626 528296 534791 536573 539318 555991 558631 562187 568265 585498 587787 588346 588392 589366 589991 590770 591226 593380 598153 598543 603508 605045 609784 618115 618237 618393 618932 624939 626885 629334 629828 631637 633300 639642 647697 649484 652235 661674 664175 669346 698619 704641 705221 707895 710224 710700 712386 713001 713706 714394 717553 719389 724987 739150 740569 740578 742330 744775 746575 752336 756702 758328 758339 769366 770252 772243 772261 772262 776034 776037 776774 777763 777767 778684 780526 782106 782665 783006 790500 790574 791057 791345 791892 792712 792978 796673 796988 796994 797002 799111 800676 800680 800682 802739 806764 807111 807122 807160 809018 809086 811109 813963 814035 814302 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo tights"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло колготк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
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.