Query Metrics
7
Database Queries
7
Different statements
145.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.04 ms (83.39%) |
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 6696 6714 16974 188189 391744 394648 396186 397935 398100 400888 401768 402659 402718 402904 406896 409234 412830 414087 424281 426702 427192 428308 435412 435671 439365 439653 441077 441407 442915 445395 453518 453793 453822 461767 463960 471666 474584 480206 480428 493571 493688 497693 498585 500336 502286 511005 511014 511864 511933 512543 513967 514043 514868 519312 519722 521294 523761 525351 527224 528781 530956 540680 545713 547502 566914 568770 573270 576514 580585 580597 581050 596134 601367 601861 602955 603830 604815 609293 617007 618844 624174 628106 630080 640792 662046 667052 671205 672321 672706 679220 688980 689415 694660 698712 702631 707497 711934 715380 717954 720806 727575 740001 740088 740788 740861 742357 742735 757631 758203 761202 762965 767268 772991 775698 775705 784316 784328 794333 798255 800581 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (9.55%) |
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 617007 775698 742357 761202 762965 784328 794333 758203 727575 740001 740088 740788 740861 609293 707497 715380 400888 402659 441077 688980 493688 463960 511005 519722 530956 581050 568770 672321 679220 689415 671205 580585 624174 601367 742735 775705 445395 402904 435412 493571 498585 188189 16974 6696 397935 398100 441407 427192 618844 409234 426702 391744 604815 527224 545713 6714 603830 442915 566914 720806 672706 694660 698712 640792 596134 800581 772991 784316 798255 757631 767268 630080 702631 717954 414087 601861 439653 580597 521294 453793 540680 502286 511864 525351 514043 500336 512543 513967 514868 519312 471666 480206 573270 576514 662046 667052 602955 480428 453518 402718 523761 528781 394648 401768 406896 435671 424281 428308 453822 511933 511014 497693 547502 711934 628106 474584 396186 412830 461767 439365 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.13%) |
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 6696 6714 16974 188189 391744 394648 396186 397935 398100 400888 401768 402659 402718 402904 406896 409234 412830 414087 424281 426702 427192 428308 435412 435671 439365 439653 441077 441407 442915 445395 453518 453793 453822 461767 463960 471666 474584 480206 480428 493571 493688 497693 498585 500336 502286 511005 511014 511864 511933 512543 513967 514043 514868 519312 519722 521294 523761 525351 527224 528781 530956 540680 545713 547502 566914 568770 573270 576514 580585 580597 581050 596134 601367 601861 602955 603830 604815 609293 617007 618844 624174 628106 630080 640792 662046 667052 671205 672321 672706 679220 688980 689415 694660 698712 702631 707497 711934 715380 717954 720806 727575 740001 740088 740788 740861 742357 742735 757631 758203 761202 762965 767268 772991 775698 775705 784316 784328 794333 798255 800581 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal anus"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал анус"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.