Query Metrics
7
Database Queries
7
Different statements
375.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.94 ms (56.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth пов"
]
|
||||||||||||||||||||||||||||||
|
141.95 ms (37.78%) |
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 418357 438495 446817 447581 450166 451642 452664 455291 457008 460464 461728 461797 462616 466820 471311 473763 475957 479948 481356 481601 483816 488974 489180 496239 496243 500994 504460 506068 506144 514245 517130 522697 527819 528287 530213 530908 533669 542182 542412 546572 546742 546912 548815 551639 552368 553262 554501 557922 561281 562141 563104 563674 564008 567635 571106 571362 571375 573291 574659 578247 584450 585257 585758 588060 589011 591207 591229 592703 599000 599360 602665 609756 616995 618137 623948 629315 634229 635041 650134 666457 667909 673217 678901 680572 682259 682645 683490 693564 707616 718958 726067 729402 758448 760476 763046 764247 764627 764654 771068 773324 773664 777914 779247 779566 780932 781291 790079 790844 791270 791983 793699 794090 796008 797343 799498 800880 808908 817258 821312 826330 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (3.97%) |
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 438495 418357 826330 817258 821312 446817 450166 451642 452664 455291 457008 460464 479948 481356 483816 461728 461797 462616 466820 473763 447581 471311 481601 489180 506068 533669 500994 527819 530213 530908 496239 496243 504460 506144 514245 517130 522697 528287 475957 488974 542412 571362 574659 551639 552368 554501 563674 567635 571106 584450 542182 546742 546912 548815 557922 561281 563104 564008 571375 578247 667909 682259 682645 693564 650134 678901 680572 718958 666457 673217 683490 707616 546572 553262 562141 573291 585257 591207 609756 618137 629315 585758 599000 599360 602665 616995 623948 634229 635041 589011 588060 591229 592703 777914 779566 781291 790844 794090 796008 800880 779247 780932 791270 791983 793699 808908 729402 764247 773664 790079 797343 799498 760476 764627 773324 726067 763046 771068 758448 764654 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (0.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 418357 438495 446817 447581 450166 451642 452664 455291 457008 460464 461728 461797 462616 466820 471311 473763 475957 479948 481356 481601 483816 488974 489180 496239 496243 500994 504460 506068 506144 514245 517130 522697 527819 528287 530213 530908 533669 542182 542412 546572 546742 546912 548815 551639 552368 553262 554501 557922 561281 562141 563104 563674 564008 567635 571106 571362 571375 573291 574659 578247 584450 585257 585758 588060 589011 591207 591229 592703 599000 599360 602665 609756 616995 618137 623948 629315 634229 635041 650134 666457 667909 673217 678901 680572 682259 682645 683490 693564 707616 718958 726067 729402 758448 760476 763046 764247 764627 764654 771068 773324 773664 777914 779247 779566 780932 781291 790079 790844 791270 791983 793699 794090 796008 797343 799498 800880 808908 817258 821312 826330 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth pov"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth пов"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
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.