Query Metrics
7
Database Queries
7
Different statements
353.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.43 ms (59.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf fuck bbc"
]
|
||||||||||||||||||||||||||||||
|
119.33 ms (33.72%) |
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 33431 386804 395398 395402 395497 397621 399311 408196 412043 415506 416226 417797 417878 417893 419892 421556 428410 430762 435471 435515 447924 457672 457936 461637 465177 468062 468638 470126 472603 472614 474153 477262 478487 491465 496721 501480 501488 505094 510264 522396 530079 531611 532995 533064 533372 535532 536757 538031 539518 545791 545857 550194 564304 565507 573308 583953 585270 590794 595965 595969 596116 599862 599863 599867 599875 599955 599965 600019 600029 603546 603737 604457 604468 604495 604681 606503 607126 616402 629045 633428 634209 634552 634553 635490 636574 648854 649964 651613 655832 678970 681297 694632 700169 715089 718945 719427 719832 720116 723582 724266 727597 732559 733560 741304 744598 744665 776861 788304 789220 798309 800297 800513 802462 803473 807763 813448 814145 814634 823289 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (4.69%) |
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 776861 33431 814145 472614 545857 616402 798309 789220 733560 741304 477262 550194 678970 635490 395402 395398 417893 468062 457672 461637 522396 536757 539518 583953 681297 715089 651613 720116 719832 573308 607126 634209 634552 800297 813448 744665 719427 732559 395497 397621 408196 428410 478487 531611 564304 649964 655832 596116 604457 604495 595965 803473 633428 416226 417878 510264 412043 415506 474153 824404 435515 419892 457936 491465 472603 505094 535532 538031 700169 694632 718945 590794 604681 636574 634553 802462 788304 807763 724266 744598 604468 800513 430762 447924 470126 496721 599875 435471 603737 530079 533064 532995 545791 648854 629045 599965 501480 599862 417797 814634 585270 606503 595969 727597 603546 386804 465177 533372 599867 600029 599863 600019 501488 599955 468638 823289 421556 399311 723582 565507 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (0.70%) |
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 33431 386804 395398 395402 395497 397621 399311 408196 412043 415506 416226 417797 417878 417893 419892 421556 428410 430762 435471 435515 447924 457672 457936 461637 465177 468062 468638 470126 472603 472614 474153 477262 478487 491465 496721 501480 501488 505094 510264 522396 530079 531611 532995 533064 533372 535532 536757 538031 539518 545791 545857 550194 564304 565507 573308 583953 585270 590794 595965 595969 596116 599862 599863 599867 599875 599955 599965 600019 600029 603546 603737 604457 604468 604495 604681 606503 607126 616402 629045 633428 634209 634552 634553 635490 636574 648854 649964 651613 655832 678970 681297 694632 700169 715089 718945 719427 719832 720116 723582 724266 727597 732559 733560 741304 744598 744665 776861 788304 789220 798309 800297 800513 802462 803473 807763 813448 814145 814634 823289 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf секс bbc"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf секс bbc"
]
|
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.