Query Metrics
7
Database Queries
7
Different statements
403.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.02 ms (56.73%) |
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 697296 713115 793612 788226 810383 741980 719143 145646 505369 824461 825775 790027 392527 335993 2926 407387 824953 483792 427264 152056 429479 431471 469575 405221 385653 504614 509846 527968 106347 58325 398461 411614 429583 814117 453124 453154 502061 567422 551979 563429 713424 587587 630260 795867 795915 810021 729886 730847 726831 781972 810101 480498 401509 449595 420218 396627 396605 426426 817632 821645 817044 817367 818468 826455 537164 567008 670765 719190 557815 600311 624157 789629 807200 724472 767928 733020 755635 623544 719176 726764 760173 761526 699401 560958 544523 732236 518286 491858 383354 411925 453108 476157 490637 492102 501527 513970 516436 578158 543989 649952 677360 795918 801764 804337 739985 739955 615964 793716 391134 429936 449335 185494 453105 73926 327085 53510 826594 825137 295700 396364 ] |
||||||||||||||||||||||||||||||
|
165.60 ms (41.02%) |
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 2926 53510 58325 73926 106347 145646 152056 185494 295700 327085 335993 383354 385653 391134 392527 396364 396605 396627 398461 401509 405221 407387 411614 411925 420218 426426 427264 429479 429583 429936 431471 449335 449595 453105 453108 453124 453154 469575 476157 480498 483792 490637 491858 492102 501527 502061 504614 505369 509846 513970 516436 518286 527968 537164 543989 544523 551979 557815 560958 563429 567008 567422 578158 587587 600311 615964 623544 624157 630260 649952 670765 677360 697296 699401 713115 713424 719143 719176 719190 724472 726764 726831 729886 730847 732236 733020 739955 739985 741980 755635 760173 761526 767928 781972 788226 789629 790027 793612 793716 795867 795915 795918 801764 804337 807200 810021 810101 810383 814117 817044 817367 817632 818468 821645 824461 824953 825137 825775 826455 826594 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.60%) |
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 2926 53510 58325 73926 106347 145646 152056 185494 295700 327085 335993 383354 385653 391134 392527 396364 396605 396627 398461 401509 405221 407387 411614 411925 420218 426426 427264 429479 429583 429936 431471 449335 449595 453105 453108 453124 453154 469575 476157 480498 483792 490637 491858 492102 501527 502061 504614 505369 509846 513970 516436 518286 527968 537164 543989 544523 551979 557815 560958 563429 567008 567422 578158 587587 600311 615964 623544 624157 630260 649952 670765 677360 697296 699401 713115 713424 719143 719176 719190 724472 726764 726831 729886 730847 732236 733020 739955 739985 741980 755635 760173 761526 767928 781972 788226 789629 790027 793612 793716 795867 795915 795918 801764 804337 807200 810021 810101 810383 814117 817044 817367 817632 818468 821645 824461 824953 825137 825775 826455 826594 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking hairy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.31%) |
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.