Query Metrics
7
Database Queries
7
Different statements
154.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.52 ms (80.43%) |
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 32549 91146 131517 168687 185494 382006 382864 384348 385313 385494 385682 385947 386699 387241 387263 388514 390445 390810 395252 406907 408578 408701 409882 411096 411630 411729 411769 411770 414782 418719 420333 423455 429936 433685 433766 446786 453108 453154 454026 454877 459329 462232 465861 468501 469360 476162 482418 483906 489119 489340 492102 496462 496842 500472 502061 502544 513970 516436 529372 533165 536107 536986 541030 548418 556790 561725 561736 577419 581345 583403 588415 605387 620880 627060 630129 647839 663353 664799 665372 666132 666473 667851 670952 677360 680250 681179 691358 692972 696108 705349 715420 722149 729759 729886 730847 733307 736094 739955 739985 742067 744985 760170 778058 781972 794428 794676 794684 795918 796307 796494 799636 803363 804028 807837 810112 813202 819409 820119 825243 ] |
||||||||||||||||||||||||||||||
|
19.60 ms (12.66%) |
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 742067 500472 385682 385313 131517 489340 516436 677360 664799 795918 739985 429936 185494 387241 388514 411630 820119 819409 825243 91146 390810 411729 454877 454026 647839 670952 739955 733307 384348 408578 411769 418719 446786 468501 390445 414782 482418 502544 583403 680250 692972 696108 705349 616512 794676 794428 803363 760170 778058 804028 168687 382864 489119 408701 433766 433685 411770 453154 496842 502061 476162 577419 665372 729759 729886 730847 796307 744985 781972 423455 406907 385494 382006 387263 411096 420333 459329 462232 496462 529372 536107 561725 541030 667851 663353 666473 715420 722149 666132 681179 691358 548418 556790 588415 620880 605387 810112 794684 799636 807837 736094 627060 630129 796494 813202 395252 561736 581345 386699 385947 32549 409882 465861 469360 453108 483906 492102 513970 536986 533165 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.63%) |
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 32549 91146 131517 168687 185494 382006 382864 384348 385313 385494 385682 385947 386699 387241 387263 388514 390445 390810 395252 406907 408578 408701 409882 411096 411630 411729 411769 411770 414782 418719 420333 423455 429936 433685 433766 446786 453108 453154 454026 454877 459329 462232 465861 468501 469360 476162 482418 483906 489119 489340 492102 496462 496842 500472 502061 502544 513970 516436 529372 533165 536107 536986 541030 548418 556790 561725 561736 577419 581345 583403 588415 605387 620880 627060 630129 647839 663353 664799 665372 666132 666473 667851 670952 677360 680250 681179 691358 692972 696108 705349 715420 722149 729759 729886 730847 733307 736094 739955 739985 742067 744985 760170 778058 781972 794428 794676 794684 795918 796307 796494 799636 803363 804028 807837 810112 813202 819409 820119 825243 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая секс"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.90%) |
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.