Query Metrics
7
Database Queries
7
Different statements
172.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.22 ms (83.12%) |
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 47854 123436 130089 274678 383159 387391 393684 396341 396910 398236 400956 415858 416298 416863 428979 454289 461568 462364 462895 464720 470760 475020 477230 487005 490008 491371 501238 515723 522409 523935 530383 557210 562367 565541 576373 583995 584717 595717 595817 603151 603242 606582 606700 606821 607155 610847 613333 622111 626733 631913 633508 641928 641999 644296 646448 671740 672766 675236 675921 675951 676342 679396 679441 682198 688351 693137 699844 701501 704547 706836 711891 714193 715507 716236 716746 716804 717731 718521 723982 726744 728191 728233 741302 743771 748138 748154 748240 748243 748249 748695 750465 754174 759890 767281 770256 773554 775140 775803 775916 775934 775971 775994 776022 776307 776971 778364 781112 784161 786255 787667 788174 789521 791355 792356 798411 799362 802594 808511 810757 811486 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (10.28%) |
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 672766 675951 676342 682198 701501 706836 711891 714193 716236 717731 718521 671740 675236 675921 679396 679441 688351 693137 699844 704547 715507 716804 557210 576373 583995 584717 603242 610847 622111 626733 631913 595717 606582 606700 595817 603151 606821 607155 613333 633508 641928 775971 778364 786255 788174 791355 808511 810757 775140 775803 775916 775934 781112 798411 723982 748249 767281 787667 811486 728233 741302 748138 748154 748243 759890 728191 726744 743771 754174 770256 748240 748695 750465 773554 641999 644296 716746 775994 776022 776307 776971 784161 789521 792356 799362 802594 396341 428979 462895 464720 470760 47854 123436 398236 274678 400956 416863 461568 462364 130089 383159 387391 393684 396910 416298 454289 475020 415858 501238 523935 490008 487005 491371 522409 565541 562367 646448 477230 515723 530383 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.19%) |
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 47854 123436 130089 274678 383159 387391 393684 396341 396910 398236 400956 415858 416298 416863 428979 454289 461568 462364 462895 464720 470760 475020 477230 487005 490008 491371 501238 515723 522409 523935 530383 557210 562367 565541 576373 583995 584717 595717 595817 603151 603242 606582 606700 606821 607155 610847 613333 622111 626733 631913 633508 641928 641999 644296 646448 671740 672766 675236 675921 675951 676342 679396 679441 682198 688351 693137 699844 701501 704547 706836 711891 714193 715507 716236 716746 716804 717731 718521 723982 726744 728191 728233 741302 743771 748138 748154 748240 748243 748249 748695 750465 754174 759890 767281 770256 773554 775140 775803 775916 775934 775971 775994 776022 776307 776971 778364 781112 784161 786255 787667 788174 789521 791355 792356 798411 799362 802594 808511 810757 811486 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group pussy"
]
|
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.