Query Metrics
7
Database Queries
7
Different statements
178.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.88 ms (83.79%) |
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 7065 7295 150820 187789 187800 187851 187960 187996 188335 188462 188560 382295 382444 384124 385999 386189 387510 387856 391237 392208 393135 395465 398545 401268 403322 403324 403911 405830 406018 408188 408240 409932 413460 413467 439634 439806 439856 440996 442814 460912 465892 466015 466244 466801 470424 483656 486542 497701 499359 518763 526745 536213 557572 573918 591333 591877 593842 601930 605008 630096 663461 681290 698496 706888 709528 710529 715372 718576 720121 725197 726731 727503 727578 727732 727754 727787 728083 728228 730360 731836 733454 736196 739927 742433 742749 744989 744994 746692 759946 761275 765391 768330 770113 774171 777250 780679 788543 788554 795867 796252 799971 800432 800597 800633 802152 802195 806084 807600 808052 808456 810774 811475 814933 817347 818630 819480 823806 824168 825420 826655 ] |
||||||||||||||||||||||||||||||
|
16.37 ms (9.15%) |
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 817347 726731 802152 605008 807600 401268 398545 408240 403324 393135 819480 744989 774171 765391 770113 698496 808052 406018 518763 718576 810774 384124 409932 593842 413460 439634 7295 150820 715372 709528 706888 796252 739927 731836 736196 742749 802195 591333 536213 187789 823806 728228 742433 800633 188335 466015 601930 733454 413467 720121 188560 395465 727732 727787 391237 795867 814933 788543 439856 442814 440996 439806 818630 808456 382444 386189 630096 392208 825420 826655 777250 727754 387510 465892 187851 663461 799971 408188 497701 800597 728083 768330 780679 385999 499359 187996 7065 681290 710529 800432 727503 746692 730360 727578 788554 725197 188462 403911 824168 382295 466801 486542 557572 573918 806084 811475 761275 759946 187960 387856 460912 405830 466244 483656 526745 591877 744994 403322 187800 470424 ] |
||||||||||||||||||||||||||||||
|
4.75 ms (2.66%) |
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 7065 7295 150820 187789 187800 187851 187960 187996 188335 188462 188560 382295 382444 384124 385999 386189 387510 387856 391237 392208 393135 395465 398545 401268 403322 403324 403911 405830 406018 408188 408240 409932 413460 413467 439634 439806 439856 440996 442814 460912 465892 466015 466244 466801 470424 483656 486542 497701 499359 518763 526745 536213 557572 573918 591333 591877 593842 601930 605008 630096 663461 681290 698496 706888 709528 710529 715372 718576 720121 725197 726731 727503 727578 727732 727754 727787 728083 728228 730360 731836 733454 736196 739927 742433 742749 744989 744994 746692 759946 761275 765391 768330 770113 774171 777250 780679 788543 788554 795867 796252 799971 800432 800597 800633 802152 802195 806084 807600 808052 808456 810774 811475 814933 817347 818630 819480 823806 824168 825420 826655 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal sex"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.