Query Metrics
7
Database Queries
7
Different statements
163.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.13 ms (84.45%) |
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 403434 412687 414390 417283 424520 424830 434810 434936 435538 437161 437242 444934 445682 447581 451506 455291 455861 459603 460457 460464 461728 461782 461797 463741 466820 469969 475996 476499 479953 481601 488974 489180 496239 496243 497232 500994 504460 504631 505359 505869 506068 510088 515320 517130 517316 521621 522714 527300 528287 530213 530908 546572 546742 548815 551639 552332 552352 552368 554501 558325 561281 561912 563104 563555 563674 564008 565654 567635 571106 571375 573291 584450 588060 591207 592263 592703 595751 596865 599360 609756 613443 616995 618137 623948 627281 634229 635041 650134 678901 680572 682259 683490 693564 696753 707616 709763 718958 726067 742011 760476 761436 764247 764627 764654 766903 771068 777172 777914 778671 780932 788828 790079 790610 790844 794090 797340 798351 798503 802682 802762 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (9.17%) |
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 455291 460464 461728 461797 466820 447581 481601 489180 506068 500994 530213 530908 496239 496243 504460 517130 528287 488974 551639 552368 554501 563674 567635 571106 584450 546742 548815 561281 563104 564008 571375 682259 693564 650134 678901 680572 718958 683490 707616 546572 573291 591207 609756 618137 599360 616995 623948 634229 635041 588060 592703 777914 790844 794090 780932 764247 790079 760476 764627 726067 771068 764654 766903 613443 696753 777172 788828 797340 798351 802762 434810 444934 451506 460457 475996 424520 435538 437242 461782 417283 434936 445682 459603 469969 504631 527300 505359 505869 515320 517316 522714 798503 790610 742011 403434 424830 552332 558325 561912 563555 565654 552352 778671 412687 414390 476499 463741 479953 437161 521621 497232 510088 455861 592263 595751 596865 709763 802682 761436 627281 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.66%) |
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 403434 412687 414390 417283 424520 424830 434810 434936 435538 437161 437242 444934 445682 447581 451506 455291 455861 459603 460457 460464 461728 461782 461797 463741 466820 469969 475996 476499 479953 481601 488974 489180 496239 496243 497232 500994 504460 504631 505359 505869 506068 510088 515320 517130 517316 521621 522714 527300 528287 530213 530908 546572 546742 548815 551639 552332 552352 552368 554501 558325 561281 561912 563104 563555 563674 564008 565654 567635 571106 571375 573291 584450 588060 591207 592263 592703 595751 596865 599360 609756 613443 616995 618137 623948 627281 634229 635041 650134 678901 680572 682259 683490 693564 696753 707616 709763 718958 726067 742011 760476 761436 764247 764627 764654 766903 771068 777172 777914 778671 780932 788828 790079 790610 790844 794090 797340 798351 798503 802682 802762 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum mouth pov"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum mouth пов"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum mouth пов"
]
|
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.