Query Metrics
7
Database Queries
7
Different statements
195.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.42 ms (88.50%) |
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 16559 233676 314496 384050 388215 390178 391575 391764 391872 392554 393164 397776 398042 400957 403187 406657 417067 426694 428380 443889 444129 444232 447489 453692 454136 455242 457134 458650 467865 468093 470117 470161 471545 473995 481296 494835 498171 500998 533710 537981 543952 551938 552130 552523 557897 558857 567240 571460 571633 575515 578005 595423 596584 597577 597978 597982 598544 598709 600147 601532 608945 611298 623745 626019 626083 627746 628804 644014 651906 661277 661909 662780 663249 663836 668133 685422 687447 687833 688927 689212 691658 694159 712957 713300 717662 719162 721225 722220 722336 723210 730031 731862 735358 736058 736856 736869 742932 745076 745344 745352 747711 749954 752725 753357 760515 760523 764821 768359 774642 776109 779124 781489 782131 785952 789593 792199 794003 804808 819765 827962 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (7.03%) |
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 608945 467865 575515 397776 752725 774642 571633 627746 426694 473995 454136 233676 468093 391575 500998 552523 712957 723210 719162 668133 597978 597982 600147 596584 628804 597577 730031 736869 745344 745352 731862 742932 747711 768359 736058 749954 760523 781489 789593 314496 384050 16559 391872 403187 458650 481296 753357 470161 447489 393164 398042 417067 651906 717662 764821 471545 533710 552130 557897 571460 543952 551938 578005 691658 722220 713300 722336 685422 687833 721225 567240 644014 595423 623745 779124 776109 745076 735358 443889 392554 444129 455242 498171 819765 827962 661909 390178 391764 428380 388215 558857 661277 494835 537981 662780 694159 687447 688927 663249 760515 601532 782131 406657 400957 444232 457134 470117 453692 689212 663836 626019 626083 611298 598544 598709 792199 794003 785952 804808 736856 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.24%) |
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 16559 233676 314496 384050 388215 390178 391575 391764 391872 392554 393164 397776 398042 400957 403187 406657 417067 426694 428380 443889 444129 444232 447489 453692 454136 455242 457134 458650 467865 468093 470117 470161 471545 473995 481296 494835 498171 500998 533710 537981 543952 551938 552130 552523 557897 558857 567240 571460 571633 575515 578005 595423 596584 597577 597978 597982 598544 598709 600147 601532 608945 611298 623745 626019 626083 627746 628804 644014 651906 661277 661909 662780 663249 663836 668133 685422 687447 687833 688927 689212 691658 694159 712957 713300 717662 719162 721225 722220 722336 723210 730031 731862 735358 736058 736856 736869 742932 745076 745344 745352 747711 749954 752725 753357 760515 760523 764821 768359 774642 776109 779124 781489 782131 785952 789593 792199 794003 804808 819765 827962 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens russian sex"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens русск секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens русск секс"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.70%) |
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.