Query Metrics
7
Database Queries
7
Different statements
157.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.53 ms (84.68%) |
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 384901 394853 402409 406616 407483 408969 410640 415594 417832 424407 424426 424841 429879 442991 442997 443105 443199 443664 443709 443787 443970 444000 446119 449078 449178 450812 451967 452115 452950 453157 454055 454179 454558 454563 454567 456602 457463 458924 460003 460181 460729 460735 460743 461322 463177 465068 465209 465952 466085 466269 466721 467121 469276 469341 469383 472611 472684 473249 474094 474112 475656 475669 475672 475688 477548 477556 477983 484392 484563 485363 486894 487360 489207 490446 491436 493734 493835 502102 504104 507616 508575 509218 509430 510819 511391 512536 519753 520859 522472 523031 525468 526077 527750 527873 534786 535345 541637 545328 549135 554459 555209 555263 555264 555363 555389 555396 555400 555413 557468 564388 568991 584053 587961 592958 592988 594491 658797 772573 815299 820327 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (9.61%) |
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 475688 424407 475656 429879 415594 465068 443709 490446 523031 485363 493734 452115 509218 424426 443787 460729 460735 460743 449178 452950 484563 486894 584053 477556 460003 477548 519753 535345 554459 557468 658797 592958 594491 587961 772573 453157 417832 406616 443105 509430 489207 525468 507616 491436 487360 458924 512536 527873 527750 493835 442997 473249 444000 466269 454567 477983 454179 454558 463177 454563 465952 466085 484392 592988 384901 394853 402409 407483 410640 408969 442991 443199 424841 443664 443970 820327 815299 446119 451967 457463 461322 465209 466721 472684 475672 449078 450812 460181 469341 475669 454055 456602 467121 469383 474112 510819 520859 522472 526077 534786 511391 502102 504104 508575 469276 472611 474094 555263 555264 555363 555389 555396 555413 564388 568991 541637 545328 549135 555209 555400 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.80%) |
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 384901 394853 402409 406616 407483 408969 410640 415594 417832 424407 424426 424841 429879 442991 442997 443105 443199 443664 443709 443787 443970 444000 446119 449078 449178 450812 451967 452115 452950 453157 454055 454179 454558 454563 454567 456602 457463 458924 460003 460181 460729 460735 460743 461322 463177 465068 465209 465952 466085 466269 466721 467121 469276 469341 469383 472611 472684 473249 474094 474112 475656 475669 475672 475688 477548 477556 477983 484392 484563 485363 486894 487360 489207 490446 491436 493734 493835 502102 504104 507616 508575 509218 509430 510819 511391 512536 519753 520859 522472 523031 525468 526077 527750 527873 534786 535345 541637 545328 549135 554459 555209 555263 555264 555363 555389 555396 555400 555413 557468 564388 568991 584053 587961 592958 592988 594491 658797 772573 815299 820327 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mature 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.