Query Metrics
7
Database Queries
7
Different statements
361.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.62 ms (59.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german mature milf"
]
|
||||||||||||||||||||||||||||||
|
116.89 ms (32.35%) |
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 191330 386798 387905 401064 401216 401933 412132 415567 416886 419503 419617 423379 425976 428514 428520 428522 428531 428533 443163 446085 447930 453635 453648 453650 455977 456002 456915 457984 459457 461141 464237 464965 466927 466943 467580 469352 471177 471786 472618 472955 473203 476227 477593 478463 480759 480772 482555 482686 483103 483802 484086 485098 485475 485481 491449 491565 494261 494264 495878 497703 502812 503569 504085 504116 505215 505910 506060 506467 506805 509103 509993 515825 518387 521159 522191 523122 525191 525485 526104 527676 529162 538816 538817 541336 541759 541872 551922 559121 559123 561005 564481 567410 568989 569176 569198 573914 581025 583387 584063 589192 589747 591253 593868 594406 599609 599659 602668 603002 603571 603610 606608 606624 621787 624084 674473 802723 805874 809644 ] |
||||||||||||||||||||||||||||||
|
20.24 ms (5.60%) |
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 509993 518387 505215 480759 559123 603610 464237 466943 503569 541872 583387 559121 602668 453650 464965 456915 386798 191330 401216 415567 425976 419617 453648 457984 459457 471786 472618 453635 523122 515825 497703 506060 538816 502812 505910 561005 674473 599609 603571 606608 621787 802723 809644 525191 495878 387905 455977 466927 473203 401933 401064 428520 522191 428514 423379 483103 491449 469352 477593 478463 484086 504116 506805 538817 525485 476227 551922 567410 569198 568989 581025 589192 594406 589747 591253 456002 472955 446085 491565 485475 494261 482555 599659 428533 485098 494264 606624 805874 506467 443163 412132 485481 509103 541336 564481 573914 428522 471177 419503 483802 416886 467580 480772 527676 569176 428531 447930 482686 584063 541759 593868 461141 603002 504085 624084 526104 529162 521159 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (1.13%) |
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 191330 386798 387905 401064 401216 401933 412132 415567 416886 419503 419617 423379 425976 428514 428520 428522 428531 428533 443163 446085 447930 453635 453648 453650 455977 456002 456915 457984 459457 461141 464237 464965 466927 466943 467580 469352 471177 471786 472618 472955 473203 476227 477593 478463 480759 480772 482555 482686 483103 483802 484086 485098 485475 485481 491449 491565 494261 494264 495878 497703 502812 503569 504085 504116 505215 505910 506060 506467 506805 509103 509993 515825 518387 521159 522191 523122 525191 525485 526104 527676 529162 538816 538817 541336 541759 541872 551922 559121 559123 561005 564481 567410 568989 569176 569198 573914 581025 583387 584063 589192 589747 591253 593868 594406 599609 599659 602668 603002 603571 603610 606608 606624 621787 624084 674473 802723 805874 809644 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"german mature milf"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.48%) |
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.