Query Metrics
7
Database Queries
7
Different statements
147.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.03 ms (82.24%) |
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 387883 391134 396862 397456 398652 412910 418646 420253 424843 424985 438495 440683 445611 449274 449296 450955 451154 452294 456130 461802 463086 468398 469467 472372 474982 480165 496787 504339 512946 514945 520218 525449 531296 533388 533840 533867 534193 542752 544773 556658 558067 558372 563137 565976 568540 568739 578221 582479 583591 585758 585952 587749 589001 590898 591771 591992 593396 593883 595069 595404 598552 604475 604704 605966 614658 616602 616793 619375 621027 624839 641160 641972 645706 654334 687150 696984 715350 715497 718720 721447 724266 726621 727644 728233 728239 729265 732718 736489 737588 737759 745917 760064 765266 766628 766634 766786 769645 770102 771171 782400 782464 784085 785945 786537 792319 792799 793555 800189 803248 804748 807539 807701 807703 807725 809666 810991 811128 813061 813177 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (10.94%) |
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 387883 397456 420253 424985 438495 424843 621027 449296 452294 463086 469467 445611 450955 456130 461802 449274 451154 465188 468398 525449 531296 533388 533840 533867 504339 520218 512946 514945 496787 534193 480165 542752 544773 556658 558372 565976 578221 582479 583591 568540 645706 715497 654334 715350 687150 718720 721447 558067 563137 568739 590898 595404 604704 605966 616793 641972 585758 591992 593396 595069 589001 591771 593883 598552 614658 616602 624839 585952 587749 786537 803248 807703 807725 813061 804748 807539 813177 737759 766786 782400 782464 784085 785945 792799 807701 728233 729265 724266 726621 728239 736489 737588 760064 770102 732718 771171 727644 745917 765266 766628 766634 769645 604475 619375 641160 696984 792319 793555 800189 809666 810991 811128 398652 412910 418646 472372 474982 391134 440683 396862 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.81%) |
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 387883 391134 396862 397456 398652 412910 418646 420253 424843 424985 438495 440683 445611 449274 449296 450955 451154 452294 456130 461802 463086 468398 469467 472372 474982 480165 496787 504339 512946 514945 520218 525449 531296 533388 533840 533867 534193 542752 544773 556658 558067 558372 563137 565976 568540 568739 578221 582479 583591 585758 585952 587749 589001 590898 591771 591992 593396 593883 595069 595404 598552 604475 604704 605966 614658 616602 616793 619375 621027 624839 641160 641972 645706 654334 687150 696984 715350 715497 718720 721447 724266 726621 727644 728233 728239 729265 732718 736489 737588 737759 745917 760064 765266 766628 766634 766786 769645 770102 771171 782400 782464 784085 785945 786537 792319 792799 793555 800189 803248 804748 807539 807701 807703 807725 809666 810991 811128 813061 813177 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking creampie"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза creampie"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза creampie"
]
|
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.