Query Metrics
7
Database Queries
7
Different statements
187.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.78 ms (81.12%) |
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 147173 381735 388542 396421 422170 423963 424535 427174 430303 434028 437960 438069 444209 445641 453094 460878 461194 465498 466419 472588 475677 482191 483858 484246 485577 485872 486575 488891 488937 491021 491886 492278 492598 496059 509325 513920 522914 523075 525626 528067 531608 532357 532850 534943 541833 543596 543612 547265 549296 553109 553637 555991 556323 557071 558912 559882 568506 568663 569119 570717 571364 571765 573217 574408 585808 590478 596084 602614 605182 609240 609591 613536 613951 615909 617444 623830 632020 641116 660115 665051 672901 679465 694203 702315 716532 721958 723828 724103 724415 727397 731317 731421 733789 733957 746077 758391 758658 760595 769010 773284 774949 783998 784024 785204 794007 795363 795571 798219 802239 808856 813197 820648 821322 821899 822593 823089 823489 823815 828127 828362 ] |
||||||||||||||||||||||||||||||
|
24.74 ms (13.22%) |
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 615909 491021 492598 609591 532357 556323 632020 541833 605182 472588 543596 558912 573217 427174 602614 727397 758391 808856 381735 623830 484246 424535 492278 388542 438069 147173 731421 434028 483858 733789 760595 396421 485872 488891 571364 731317 795363 423963 758658 724103 773284 488937 821322 822593 496059 513920 557071 568663 571765 422170 733957 828362 465498 798219 724415 820648 702315 823089 716532 617444 609240 784024 486575 574408 482191 460878 823815 802239 823489 532850 547265 559882 585808 672901 723828 746077 828127 821899 590478 813197 795571 794007 769010 569119 694203 660115 721958 641116 523075 549296 553109 665051 613536 783998 774949 444209 543612 437960 491886 553637 528067 485577 570717 445641 509325 522914 679465 453094 466419 534943 461194 785204 475677 613951 596084 430303 568506 531608 525626 555991 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.57%) |
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 147173 381735 388542 396421 422170 423963 424535 427174 430303 434028 437960 438069 444209 445641 453094 460878 461194 465498 466419 472588 475677 482191 483858 484246 485577 485872 486575 488891 488937 491021 491886 492278 492598 496059 509325 513920 522914 523075 525626 528067 531608 532357 532850 534943 541833 543596 543612 547265 549296 553109 553637 555991 556323 557071 558912 559882 568506 568663 569119 570717 571364 571765 573217 574408 585808 590478 596084 602614 605182 609240 609591 613536 613951 615909 617444 623830 632020 641116 660115 665051 672901 679465 694203 702315 716532 721958 723828 724103 724415 727397 731317 731421 733789 733957 746077 758391 758658 760595 769010 773284 774949 783998 784024 785204 794007 795363 795571 798219 802239 808856 813197 820648 821322 821899 822593 823089 823489 823815 828127 828362 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car compilation"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин подборк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
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.