Query Metrics
7
Database Queries
7
Different statements
165.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.21 ms (85.39%) |
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 28242 233333 388687 390217 391677 396563 397431 401858 402226 402242 404121 404263 410663 410741 413690 416335 416889 423620 425875 425889 428044 432304 432738 435943 440649 441409 441420 441430 441472 441480 441530 441611 441614 443905 445285 445828 447321 447335 447734 447910 451540 451609 452791 452922 452978 453485 454278 454581 456558 457514 458755 461998 463382 463950 464584 464782 465803 470082 470484 470929 470946 474036 480075 483611 484717 486363 489888 499388 500065 503016 503688 506526 508505 509725 509856 513557 521868 521889 523893 524502 559021 573607 590461 591933 597057 598674 605730 605829 626880 654409 688939 696154 705106 707164 734330 735401 736739 737012 741249 742279 747164 751308 752725 753495 755739 766287 766479 766796 766885 769052 770319 774649 778875 779005 782991 786493 787452 792455 800458 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (9.11%) |
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 397431 465803 404263 626880 404121 432304 441480 464782 402226 451540 416889 410663 523893 447734 559021 470484 509856 461998 464584 451609 503016 500065 786493 441530 447335 506526 470946 463950 452791 454581 742279 423620 654409 605730 800458 755739 736739 766796 747164 770319 737012 766479 769052 778875 441472 452978 503688 441420 425889 458755 499388 752725 401858 28242 696154 388687 413690 416335 425875 445828 447910 410741 463382 390217 457514 470082 486363 508505 688939 605829 792455 779005 782991 735401 753495 766885 741249 766287 774649 441614 445285 428044 484717 509725 590461 402242 441409 453485 454278 456558 391677 470929 489888 513557 483611 521889 474036 440649 524502 396563 432738 443905 787452 769740 441430 441611 751308 233333 435943 573607 597057 598674 591933 480075 452922 447321 521868 734330 705106 707164 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.56%) |
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 28242 233333 388687 390217 391677 396563 397431 401858 402226 402242 404121 404263 410663 410741 413690 416335 416889 423620 425875 425889 428044 432304 432738 435943 440649 441409 441420 441430 441472 441480 441530 441611 441614 443905 445285 445828 447321 447335 447734 447910 451540 451609 452791 452922 452978 453485 454278 454581 456558 457514 458755 461998 463382 463950 464584 464782 465803 470082 470484 470929 470946 474036 480075 483611 484717 486363 489888 499388 500065 503016 503688 506526 508505 509725 509856 513557 521868 521889 523893 524502 559021 573607 590461 591933 597057 598674 605730 605829 626880 654409 688939 696154 705106 707164 734330 735401 736739 737012 741249 742279 747164 751308 752725 753495 755739 766287 766479 766796 766885 769052 770319 774649 778875 779005 782991 786493 787452 792455 800458 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal russian girls"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.