Query Metrics
7
Database Queries
7
Different statements
297.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
270.36 ms (90.75%) |
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 97377 129640 130468 388474 390538 391070 397273 398634 400941 400954 404732 407290 414339 414342 421200 426038 427966 429088 429775 432243 432799 443389 446337 451565 467592 468860 471317 474629 474714 476103 482514 482938 485133 491449 497901 522872 522880 524193 524196 526125 530015 530022 530633 531189 531198 532733 532916 533003 533466 535005 535620 536259 536584 536586 536785 537747 537771 541925 543576 543855 544819 545383 550200 562828 565253 580263 581726 583693 597254 600253 604431 630678 630679 631192 632333 632633 632658 632703 633766 634145 634154 636985 636991 637031 637650 639254 640801 644256 647949 648862 649214 651168 651620 656574 660422 662023 666548 666553 666877 674980 678138 679025 679775 680151 696331 704226 704256 706629 706652 714480 714552 717066 720257 721846 748950 758304 788249 794817 798948 801942 ] |
||||||||||||||||||||||||||||||
|
17.48 ms (5.87%) |
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 533003 532916 630679 639254 798948 801942 714552 397273 407290 97377 390538 704256 565253 634145 637031 758304 129640 400941 400954 426038 432799 414342 421200 491449 497901 530022 531189 522872 524196 526125 532733 535005 536259 531198 537747 471317 474714 482938 543576 580263 541925 544819 583693 651168 666877 674980 720257 656574 666548 666553 647949 649214 662023 678138 714480 600253 604431 632703 637650 644256 631192 640801 632333 632633 633766 388474 429775 474629 524193 130468 696331 794817 717066 721846 391070 536785 550200 680151 706629 706652 679025 648862 651620 660422 679775 704226 597254 630678 634154 632658 636991 788249 748950 451565 536584 636985 398634 404732 429088 443389 432243 414339 427966 476103 482514 468860 446337 537771 530633 536586 530015 533466 522880 535620 467592 485133 543855 545383 562828 581726 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (0.87%) |
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 97377 129640 130468 388474 390538 391070 397273 398634 400941 400954 404732 407290 414339 414342 421200 426038 427966 429088 429775 432243 432799 443389 446337 451565 467592 468860 471317 474629 474714 476103 482514 482938 485133 491449 497901 522872 522880 524193 524196 526125 530015 530022 530633 531189 531198 532733 532916 533003 533466 535005 535620 536259 536584 536586 536785 537747 537771 541925 543576 543855 544819 545383 550200 562828 565253 580263 581726 583693 597254 600253 604431 630678 630679 631192 632333 632633 632658 632703 633766 634145 634154 636985 636991 637031 637650 639254 640801 644256 647949 648862 649214 651168 651620 656574 660422 662023 666548 666553 666877 674980 678138 679025 679775 680151 696331 704226 704256 706629 706652 714480 714552 717066 720257 721846 748950 758304 788249 794817 798948 801942 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang double"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang double"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang double"
]
|
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.