Query Metrics
7
Database Queries
7
Different statements
154.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.00 ms (84.29%) |
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 384807 399058 399414 403289 404765 414498 415894 416303 417655 422572 422609 428018 429097 443215 447688 449019 463266 463937 466916 470246 476155 481719 484162 491849 491857 492601 492794 513290 517195 520312 527607 529854 530494 531090 539938 540175 552132 562626 565198 565249 568557 571215 571219 572197 576021 576352 576417 578483 579480 586034 595363 595869 597072 597141 597259 597963 604350 605325 605727 607215 609052 611252 612436 612844 622037 626733 630770 631952 641739 659280 669430 670103 671890 672588 672766 673299 679380 679385 683470 684342 695898 699626 705572 706899 708476 708763 709781 712021 714948 716528 719102 721699 722499 723481 725115 732004 735524 737628 741862 752685 755377 758193 758199 769786 774512 778955 786196 787931 788686 790246 790249 790370 792059 792789 793642 794702 804175 804337 805242 811624 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (9.80%) |
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 540175 527607 491849 491857 568557 578483 552132 571215 572197 671890 673299 684342 699626 705572 709781 712021 716528 719102 723481 669430 672588 672766 679380 659280 670103 679385 683470 695898 708476 714948 721699 722499 571219 605727 626733 586034 595869 597259 605325 631952 641739 597072 604350 611252 595363 609052 612436 786196 788686 790249 792059 804175 805242 774512 787931 790370 793642 811624 737628 769786 790246 792789 804337 725115 732004 741862 752685 755377 758193 735524 758199 607215 622037 630770 706899 708763 778955 417655 403289 470246 476155 416303 597963 794702 414498 415894 384807 399058 404765 429097 443215 422609 422572 449019 517195 576021 579480 576352 612844 597141 466916 481719 463266 428018 447688 399414 513290 492794 492601 484162 576417 463937 529854 520312 539938 530494 531090 565198 562626 565249 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.69%) |
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 384807 399058 399414 403289 404765 414498 415894 416303 417655 422572 422609 428018 429097 443215 447688 449019 463266 463937 466916 470246 476155 481719 484162 491849 491857 492601 492794 513290 517195 520312 527607 529854 530494 531090 539938 540175 552132 562626 565198 565249 568557 571215 571219 572197 576021 576352 576417 578483 579480 586034 595363 595869 597072 597141 597259 597963 604350 605325 605727 607215 609052 611252 612436 612844 622037 626733 630770 631952 641739 659280 669430 670103 671890 672588 672766 673299 679380 679385 683470 684342 695898 699626 705572 706899 708476 708763 709781 712021 714948 716528 719102 721699 722499 723481 725115 732004 735524 737628 741862 752685 755377 758193 758199 769786 774512 778955 786196 787931 788686 790246 790249 790370 792059 792789 793642 794702 804175 804337 805242 811624 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small young"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая young"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая young"
]
|
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.