Query Metrics
7
Database Queries
7
Different statements
216.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.98 ms (88.72%) |
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 52454 83386 100685 278764 384865 388378 388542 391539 396980 402346 410699 413531 413534 413969 415508 419653 438029 438069 444343 451629 461233 462258 462490 465498 470680 470932 472532 477860 480707 480904 481356 482226 482681 484256 485967 486565 486736 487747 489772 490708 491388 492274 492711 497284 506351 506529 506533 510329 510675 510699 511543 513714 516175 521333 522439 526720 530185 531611 536483 546920 560373 561203 561615 566491 567843 571696 572537 574380 575401 580982 590860 599746 599770 599779 599796 601198 609220 613007 618302 622063 628717 633278 634975 638049 641106 641366 645316 651106 665076 689682 691600 715006 718227 718597 719880 720316 730331 732629 746092 749181 749633 767428 770696 777537 785081 798938 798946 798959 798973 799010 817425 817455 817488 817523 818777 822257 825847 828005 828366 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (6.24%) |
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 511543 580982 510675 506351 415508 83386 516175 575401 492274 490708 638049 438069 767428 396980 462258 526720 560373 485967 410699 599796 730331 770696 278764 513714 749181 599746 465498 622063 530185 651106 633278 798973 462490 413531 641106 572537 817425 486736 645316 480904 388542 480707 732629 798946 590860 52454 777537 461233 715006 482681 487747 444343 817523 746092 402346 506533 472532 546920 599779 470932 510699 497284 413534 419653 492711 482226 571696 613007 825847 665076 689682 451629 599770 618302 477860 817455 828005 561203 718597 798938 798959 828366 718227 799010 506529 567843 599767 634975 609220 384865 100685 817488 566491 720316 691600 785081 719880 388378 413969 574380 601198 628717 484256 486565 489772 749633 470680 522439 818777 641366 391539 822257 561615 510329 481356 531611 536483 438029 491388 521333 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf car sex"
]
|
||||||||||||||||||||||||||||||
|
2.99 ms (1.38%) |
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 52454 83386 100685 278764 384865 388378 388542 391539 396980 402346 410699 413531 413534 413969 415508 419653 438029 438069 444343 451629 461233 462258 462490 465498 470680 470932 472532 477860 480707 480904 481356 482226 482681 484256 485967 486565 486736 487747 489772 490708 491388 492274 492711 497284 506351 506529 506533 510329 510675 510699 511543 513714 516175 521333 522439 526720 530185 531611 536483 546920 560373 561203 561615 566491 567843 571696 572537 574380 575401 580982 590860 599746 599770 599779 599796 601198 609220 613007 618302 622063 628717 633278 634975 638049 641106 641366 645316 651106 665076 689682 691600 715006 718227 718597 719880 720316 730331 732629 746092 749181 749633 767428 770696 777537 785081 798938 798946 798959 798973 799010 817425 817455 817488 817523 818777 822257 825847 828005 828366 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf вмашин секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf вмашин секс"
]
|
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.