Query Metrics
7
Database Queries
7
Different statements
150.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.68 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.82 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang gangbang"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.96 ms |
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 487109 828038 803353 309758 538962 802534 388379 652253 715521 621990 622042 734116 392589 824051 828387 545403 593843 776017 796430 805567 735430 767185 96342 400967 78412 130045 118284 817719 817718 818777 555038 583925 696568 703040 720290 622651 776016 775990 778040 726311 773994 703535 384158 130022 393027 430456 417879 494408 606557 606570 789981 796427 781992 740832 726209 756766 604536 775947 775980 775986 96960 129748 231299 304611 348409 381770 814646 817889 824050 453088 529201 561127 682404 649148 654274 632676 608931 634462 626752 775993 753042 794794 801959 620785 644275 703037 703095 470276 386062 130060 393855 399395 402967 823177 818191 823806 459158 474055 486790 516306 522160 545391 683583 690875 709259 672765 552913 583927 644300 617170 775918 748949 620711 775816 409408 129916 390472 386300 85792 96200 ] |
||||||||||||||||||||||||||||||
| 4 | 2.52 ms |
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 78412 85792 96200 96342 96960 118284 129748 129916 130022 130045 130060 231299 304611 309758 348409 381770 384158 386062 386300 388379 390472 392589 393027 393855 399395 400967 402967 409408 417879 430456 453088 459158 470276 474055 486790 487109 494408 516306 522160 529201 538962 545391 545403 552913 555038 561127 583925 583927 593843 604536 606557 606570 608931 617170 620711 620785 621990 622042 622651 626752 632676 634462 644275 644300 649148 652253 654274 672765 682404 683583 690875 696568 703037 703040 703095 703535 709259 715521 720290 726209 726311 734116 735430 740832 748949 753042 756766 767185 773994 775816 775918 775947 775980 775986 775990 775993 776016 776017 778040 781992 789981 794794 796427 796430 801959 802534 803353 805567 814646 817718 817719 817889 818191 818777 823177 823806 824050 824051 828038 828387 ] |
||||||||||||||||||||||||||||||
| 5 | 124.88 ms |
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 78412 85792 96200 96342 96960 118284 129748 129916 130022 130045 130060 231299 304611 309758 348409 381770 384158 386062 386300 388379 390472 392589 393027 393855 399395 400967 402967 409408 417879 430456 453088 459158 470276 474055 486790 487109 494408 516306 522160 529201 538962 545391 545403 552913 555038 561127 583925 583927 593843 604536 606557 606570 608931 617170 620711 620785 621990 622042 622651 626752 632676 634462 644275 644300 649148 652253 654274 672765 682404 683583 690875 696568 703037 703040 703095 703535 709259 715521 720290 726209 726311 734116 735430 740832 748949 753042 756766 767185 773994 775816 775918 775947 775980 775986 775990 775993 776016 776017 778040 781992 789981 794794 796427 796430 801959 802534 803353 805567 814646 817718 817719 817889 818191 818777 823177 823806 824050 824051 828038 828387 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang gangbang"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang 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.