Query Metrics
7
Database Queries
7
Different statements
198.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.14 ms (86.32%) |
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 7169 187919 188335 188600 232973 233135 236765 358264 390769 391237 391652 397214 397871 397937 398956 398959 400489 411326 413283 425321 427433 439651 439659 439702 439709 439725 439746 439768 439772 440399 440403 440601 440726 440744 440997 441000 442612 442987 443154 451499 454232 457450 463856 468167 469375 469581 471411 472675 484243 492292 513663 534636 535452 536422 536431 536441 537263 547605 551863 555066 555769 555779 561526 570972 583062 604302 616594 651114 666361 676680 682811 705449 707102 720621 720810 726934 726974 727738 729819 729891 731836 734390 737164 739178 743806 746682 747958 748213 756878 759878 759905 759929 759950 760827 761023 761027 761538 762381 763914 765644 766601 767180 776320 777420 780613 787614 789619 790009 791482 796116 796148 796957 802139 802157 807539 816793 817347 818167 825413 827147 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (8.85%) |
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 767180 759878 734390 747958 492292 425321 441000 439746 457450 454232 759929 802157 729819 472675 440997 816793 469581 570972 666361 551863 759950 739178 759905 534636 762381 188600 707102 791482 761538 720810 616594 188335 397871 398956 561526 583062 440601 439659 439768 439702 440744 439725 442612 535452 442987 676680 400489 536431 390769 682811 604302 727738 729891 731836 746682 765644 763914 187919 397937 817347 555769 555779 790009 7169 440726 439772 439651 413283 536441 469375 776320 807539 748213 737164 780613 358264 391237 233135 439709 443154 789619 818167 484243 513663 705449 787614 796148 726934 743806 766601 398959 468167 411326 827147 451499 651114 802139 756878 761023 825413 232973 427433 440399 555066 720621 777420 796957 726974 796116 760827 761027 463856 440403 397214 537263 536422 236765 391652 471411 547605 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.58%) |
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 7169 187919 188335 188600 232973 233135 236765 358264 390769 391237 391652 397214 397871 397937 398956 398959 400489 411326 413283 425321 427433 439651 439659 439702 439709 439725 439746 439768 439772 440399 440403 440601 440726 440744 440997 441000 442612 442987 443154 451499 454232 457450 463856 468167 469375 469581 471411 472675 484243 492292 513663 534636 535452 536422 536431 536441 537263 547605 551863 555066 555769 555779 561526 570972 583062 604302 616594 651114 666361 676680 682811 705449 707102 720621 720810 726934 726974 727738 729819 729891 731836 734390 737164 739178 743806 746682 747958 748213 756878 759878 759905 759929 759950 760827 761023 761027 761538 762381 763914 765644 766601 767180 776320 777420 780613 787614 789619 790009 791482 796116 796148 796957 802139 802157 807539 816793 817347 818167 825413 827147 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.73%) |
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.