Query Metrics
7
Database Queries
7
Different statements
156.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.69 ms (80.73%) |
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 351473 382168 388545 389202 390133 401184 401215 401684 414085 415556 418564 423907 427406 428847 429063 429957 434900 441892 442645 442650 443519 443627 443711 446008 447040 447762 447775 448885 450378 450799 452062 452427 452903 452920 452948 453853 454744 454755 457992 459195 462599 465392 468003 469231 470050 471110 471121 471969 475593 476437 479148 483512 484910 488238 488789 489596 492818 492834 494494 495188 495489 495490 495547 496812 501452 501681 502858 509834 509884 510906 511040 517795 530121 535916 536780 538716 541478 546841 546972 550032 553285 553600 554372 562766 568213 568239 568274 568276 578640 580220 580234 587451 592604 599829 601566 602184 602328 602993 609722 616515 619085 621073 633463 639018 662806 681766 692421 709006 715816 744774 756745 760087 781857 792722 803036 803047 814656 821230 823326 ] |
||||||||||||||||||||||||||||||
|
19.23 ms (12.25%) |
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 554372 562766 580220 803047 448885 517795 401215 443627 510906 495490 495489 541478 681766 692421 553285 619085 803036 715816 469231 434900 496812 494494 509884 382168 390133 429957 441892 821230 568213 587451 633463 621073 601566 609722 423907 468003 471110 511040 429063 415556 814656 568239 662806 709006 546841 568276 616515 760087 792722 447762 453853 443711 476437 509834 489596 492818 401684 442645 452920 452903 452948 535916 602993 639018 744774 443519 462599 401184 414085 447775 454744 389202 492834 495547 501452 602184 427406 484910 538716 602328 536780 459195 530121 501681 550032 568274 592604 781857 470050 454755 475593 526388 502858 553600 578640 599829 756745 428847 495188 447040 450799 580234 479148 450378 452427 471969 351473 388545 418564 442650 823326 446008 471121 452062 488789 457992 465392 488238 483512 546972 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.64%) |
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 351473 382168 388545 389202 390133 401184 401215 401684 414085 415556 418564 423907 427406 428847 429063 429957 434900 441892 442645 442650 443519 443627 443711 446008 447040 447762 447775 448885 450378 450799 452062 452427 452903 452920 452948 453853 454744 454755 457992 459195 462599 465392 468003 469231 470050 471110 471121 471969 475593 476437 479148 483512 484910 488238 488789 489596 492818 492834 494494 495188 495489 495490 495547 496812 501452 501681 502858 509834 509884 510906 511040 517795 530121 535916 536780 538716 541478 546841 546972 550032 553285 553600 554372 562766 568213 568239 568274 568276 578640 580220 580234 587451 592604 599829 601566 602184 602328 602993 609722 616515 619085 621073 633463 639018 662806 681766 692421 709006 715816 744774 756745 760087 781857 792722 803036 803047 814656 821230 823326 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cam tits"
]
|
||||||||||||||||||||||||||||||
|
2.24 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.