Query Metrics
7
Database Queries
7
Different statements
177.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.20 ms (85.80%) |
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 391528 391836 391885 392033 412519 416455 423531 423796 423978 426688 427204 438010 443840 448369 449643 453692 455770 456352 458658 459222 460507 463839 470664 470932 472075 475371 476634 479094 479498 480626 480869 480902 485736 486957 486988 487155 489792 492468 492477 494436 498078 498922 501988 504991 505773 506209 506425 519442 521884 522659 524462 525471 525984 526759 527312 527328 537021 541852 543634 544562 546476 546885 548634 549624 552818 553247 553632 554238 554955 555569 555982 559258 559622 563653 565430 567890 571406 576182 578877 584661 588862 590577 601991 623355 623709 627082 628813 640877 657788 699871 720671 721249 734382 735246 736048 740800 741591 743555 743764 745685 748134 760303 761211 764914 766297 766473 768360 772471 776083 777903 779386 788298 793019 793956 793981 804821 816752 825641 825846 828128 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (8.14%) |
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 768360 772471 735246 736048 788298 416455 588862 553632 546476 563653 423796 455770 412519 480626 498078 527328 480902 485736 423978 494436 825846 427204 391885 793956 506425 537021 476634 392033 748134 743764 766297 525984 453692 555569 486957 525471 527312 543634 443840 576182 764914 760303 741591 745685 438010 460507 463839 449643 456352 470664 472075 504991 565430 459222 448369 391836 524462 541852 546885 552818 699871 590577 505773 501988 553247 816752 793019 623709 554238 559258 479094 479498 492477 489792 522659 779386 828128 734382 743555 423531 549624 519442 544562 776083 804821 777903 740800 761211 766473 487155 486988 793981 521884 492468 720671 526759 555982 567890 721249 578877 628813 627082 498922 506209 391528 559622 640877 554955 601991 825641 426688 470932 475371 458658 584661 657788 548634 571406 623355 480869 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.33%) |
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 391528 391836 391885 392033 412519 416455 423531 423796 423978 426688 427204 438010 443840 448369 449643 453692 455770 456352 458658 459222 460507 463839 470664 470932 472075 475371 476634 479094 479498 480626 480869 480902 485736 486957 486988 487155 489792 492468 492477 494436 498078 498922 501988 504991 505773 506209 506425 519442 521884 522659 524462 525471 525984 526759 527312 527328 537021 541852 543634 544562 546476 546885 548634 549624 552818 553247 553632 554238 554955 555569 555982 559258 559622 563653 565430 567890 571406 576182 578877 584661 588862 590577 601991 623355 623709 627082 628813 640877 657788 699871 720671 721249 734382 735246 736048 740800 741591 743555 743764 745685 748134 760303 761211 764914 766297 766473 768360 772471 776083 777903 779386 788298 793019 793956 793981 804821 816752 825641 825846 828128 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск любительск вмашин"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск любительск вмашин"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian amateur car"
]
|
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.