Query Metrics
7
Database Queries
7
Different statements
165.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.75 ms (82.56%) |
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 427983 447152 510397 517842 518470 519567 530493 530625 530630 531089 531163 531165 531215 531254 531272 531419 532737 532754 532779 532837 533374 533463 533697 534028 534995 535505 535584 535644 536249 536251 536285 536339 536588 536651 540405 541197 542583 542590 543627 544797 545441 550194 550196 562374 565253 582323 597232 597266 599902 599945 600194 600295 600332 600334 600354 601517 601576 601625 606578 610577 621656 628368 628392 631195 632618 632654 632673 632689 632975 633444 633521 633747 634131 634145 634199 636311 637016 637022 637416 639793 640763 640767 640771 644964 646242 647969 648499 649556 649579 649595 650175 650762 651188 666866 671676 674952 675021 676090 676091 676092 677781 678028 678067 678073 678121 678161 678493 678517 679016 679034 679816 680126 680185 683259 685714 687257 695126 703836 704526 704529 ] |
||||||||||||||||||||||||||||||
|
18.81 ms (11.36%) |
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 647969 666866 676091 683259 648499 649579 650762 678073 704526 671676 680126 703836 550196 600332 601576 631195 632673 632975 633747 634131 634145 634199 636311 597266 632654 637416 639793 600354 628368 628392 640771 600334 601517 640767 606578 633444 633521 704529 518470 533463 534028 531215 536251 562374 695126 610577 621656 427983 447152 532779 536285 536651 532737 536339 532837 535644 533697 542583 542590 543627 650175 678067 678161 678517 678028 678121 679034 679816 649595 651188 675021 676092 544797 565253 599945 601625 599902 600194 600295 640763 637022 517842 530493 519567 531163 531165 531419 510397 535584 649556 685714 632689 597232 632618 637016 644964 531272 532754 535505 533374 530625 530630 531089 531254 536249 536588 534995 540405 545441 582323 541197 550194 646242 674952 676090 677781 678493 679016 680185 687257 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.55%) |
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 427983 447152 510397 517842 518470 519567 530493 530625 530630 531089 531163 531165 531215 531254 531272 531419 532737 532754 532779 532837 533374 533463 533697 534028 534995 535505 535584 535644 536249 536251 536285 536339 536588 536651 540405 541197 542583 542590 543627 544797 545441 550194 550196 562374 565253 582323 597232 597266 599902 599945 600194 600295 600332 600334 600354 601517 601576 601625 606578 610577 621656 628368 628392 631195 632618 632654 632673 632689 632975 633444 633521 633747 634131 634145 634199 636311 637016 637022 637416 639793 640763 640767 640771 644964 646242 647969 648499 649556 649579 649595 650175 650762 651188 666866 671676 674952 675021 676090 676091 676092 677781 678028 678067 678073 678121 678161 678493 678517 679016 679034 679816 680126 680185 683259 685714 687257 695126 703836 704526 704529 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang casting anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang кастинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang кастинг анал"
]
|
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.