Query Metrics
7
Database Queries
7
Different statements
151.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.64 ms (82.26%) |
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 6610 17250 21576 187223 213604 233618 287436 326300 382604 382640 383950 384016 384349 385053 388757 389440 390875 391635 396425 396907 397948 398119 410811 411752 411756 413270 413888 417955 417989 418762 418837 420586 420588 420598 421584 422765 423904 423941 423961 428456 429175 433250 436477 438807 447950 448055 449332 452648 455448 457218 459061 461534 461816 462089 462663 464561 464735 465992 466144 470917 473007 476718 480106 484342 489405 490361 490804 491936 499266 508093 510648 511701 511752 511756 514599 516784 516803 521879 521885 521904 523686 526478 543407 545647 551274 552124 552166 554478 560479 560614 563219 565958 567223 572491 575753 576406 585117 589687 599514 601435 606031 607870 612680 623206 635142 654492 655107 656465 658278 684769 698484 734775 735360 736510 736772 739097 746939 777532 781347 781468 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (10.04%) |
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 213604 17250 429175 449332 480106 563219 560479 576406 552124 396425 465992 423904 461534 21576 499266 511701 490361 388757 418837 572491 452648 484342 464561 470917 545647 413270 422765 476718 521885 567223 543407 554478 575753 420598 417955 462089 466144 511756 489405 491936 508093 411752 457218 455448 490804 655107 606031 781347 735360 736510 382640 6610 781468 777532 623206 739097 187223 411756 428456 565958 511752 396907 389440 438807 287436 418762 421584 589687 398119 390875 423961 417989 447950 448055 656465 601435 516784 514599 599514 397948 698484 612680 384349 510648 552166 654492 658278 635142 734775 746939 233618 516803 433250 413888 607870 384016 736772 383950 385053 391635 326300 382604 410811 585117 459061 551274 684769 560614 420586 462663 423941 436477 461816 473007 420588 464735 521879 523686 521904 526478 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.03%) |
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 6610 17250 21576 187223 213604 233618 287436 326300 382604 382640 383950 384016 384349 385053 388757 389440 390875 391635 396425 396907 397948 398119 410811 411752 411756 413270 413888 417955 417989 418762 418837 420586 420588 420598 421584 422765 423904 423941 423961 428456 429175 433250 436477 438807 447950 448055 449332 452648 455448 457218 459061 461534 461816 462089 462663 464561 464735 465992 466144 470917 473007 476718 480106 484342 489405 490361 490804 491936 499266 508093 510648 511701 511752 511756 514599 516784 516803 521879 521885 521904 523686 526478 543407 545647 551274 552124 552166 554478 560479 560614 563219 565958 567223 572491 575753 576406 585117 589687 599514 601435 606031 607870 612680 623206 635142 654492 655107 656465 658278 684769 698484 734775 735360 736510 736772 739097 746939 777532 781347 781468 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен девушк"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy and girl"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
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.