Query Metrics
7
Database Queries
7
Different statements
150.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.28 ms (82.58%) |
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 9637 282649 393848 398130 413093 427197 428188 432704 432738 441765 442057 451219 454181 455897 458816 459863 468112 474263 478421 481986 500266 505459 526849 526887 532369 537971 549003 549108 549627 552657 557269 572755 575889 577419 578506 580210 584508 589316 589608 592867 594430 598473 599425 600409 604337 604371 619900 629443 630697 631607 633634 634291 634992 639596 656282 657162 661660 675572 679660 680250 692817 702150 710659 719678 724691 735005 735353 757062 764874 764888 764918 765391 765717 766742 766820 766959 767011 767033 767073 769909 770528 773388 773405 773830 775712 776277 776973 777696 788099 790185 790437 790926 791353 791418 791572 792970 793991 794096 796196 796346 797525 798728 798887 800364 800793 804930 807038 807082 812314 813903 814081 814496 816640 816684 817342 818036 818570 818924 826153 827588 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.91%) |
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 552657 592867 600409 634291 619900 604337 393848 428188 598473 791572 790926 9637 432738 441765 816640 817342 818036 818924 526849 719678 798887 777696 766959 767033 788099 791353 764888 769909 773405 773830 757062 630697 580210 692817 549627 398130 459863 629443 481986 710659 500266 577419 578506 454181 455897 572755 589608 557269 656282 657162 661660 679660 549003 633634 599425 639596 549108 589316 526887 584508 702150 675572 604371 634992 767011 813903 816684 818570 814496 807038 798728 764874 800364 764918 724691 790185 735005 790437 796346 797525 776277 794096 594430 814081 575889 537971 413093 776973 282649 735353 631607 451219 468112 505459 532369 766820 442057 432704 427197 826153 827588 474263 478421 458816 680250 792970 796196 812314 775712 791418 800793 793991 804930 807082 766742 770528 773388 765391 765717 767073 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.95%) |
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 9637 282649 393848 398130 413093 427197 428188 432704 432738 441765 442057 451219 454181 455897 458816 459863 468112 474263 478421 481986 500266 505459 526849 526887 532369 537971 549003 549108 549627 552657 557269 572755 575889 577419 578506 580210 584508 589316 589608 592867 594430 598473 599425 600409 604337 604371 619900 629443 630697 631607 633634 634291 634992 639596 656282 657162 661660 675572 679660 680250 692817 702150 710659 719678 724691 735005 735353 757062 764874 764888 764918 765391 765717 766742 766820 766959 767011 767033 767073 769909 770528 773388 773405 773830 775712 776277 776973 777696 788099 790185 790437 790926 791353 791418 791572 792970 793991 794096 796196 796346 797525 798728 798887 800364 800793 804930 807038 807082 812314 813903 814081 814496 816640 816684 817342 818036 818570 818924 826153 827588 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.00%) |
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.