Query Metrics
7
Database Queries
7
Different statements
166.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.85 ms (85.93%) |
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 209335 220912 382702 382793 383159 387391 390865 398022 398236 399415 402172 407374 411416 415862 416298 430700 454293 457764 457765 461568 461918 462364 462736 474012 474024 474551 482172 484469 487005 488883 497917 501238 506053 511023 515220 522409 533867 534215 539051 540187 540195 543413 543416 549302 550727 552935 554889 557392 559372 567396 575752 603242 607155 613333 620557 622111 622228 623517 626733 631913 633508 641928 641999 645233 645891 650603 670376 670689 670773 671734 677552 679396 679447 679462 680195 693137 701501 709784 711891 712649 712712 714193 715096 715559 716236 716373 716746 717731 718955 721835 723982 726719 728038 743380 743771 748243 748695 770256 773554 775140 775803 776022 776307 776971 778364 786255 789521 799362 800947 804459 808511 810770 815331 815479 818377 820768 820980 821316 822642 827206 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (8.41%) |
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 728038 623517 712649 804459 390865 411416 534215 398022 482172 383159 430700 718955 775803 716746 680195 743380 474551 671734 800947 622228 506053 550727 670689 715559 677552 620557 810770 726719 770256 773554 776022 776307 549302 474024 511023 641999 220912 533867 540187 679462 670376 622111 631913 633508 641928 789521 474012 701501 399415 539051 540195 567396 679447 716236 716373 679396 603242 778364 776971 398236 501238 462736 402172 454293 484469 415862 645891 613333 382793 382702 407374 818377 820768 488883 457765 457764 461918 559372 575752 557392 670773 715096 721835 645233 711891 714193 717731 693137 626733 607155 786255 808511 775140 723982 748243 743771 748695 799362 209335 461568 462364 387391 416298 487005 522409 497917 815331 820980 827206 821316 815479 822642 515220 543413 543416 552935 554889 650603 709784 712712 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.61%) |
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 209335 220912 382702 382793 383159 387391 390865 398022 398236 399415 402172 407374 411416 415862 416298 430700 454293 457764 457765 461568 461918 462364 462736 474012 474024 474551 482172 484469 487005 488883 497917 501238 506053 511023 515220 522409 533867 534215 539051 540187 540195 543413 543416 549302 550727 552935 554889 557392 559372 567396 575752 603242 607155 613333 620557 622111 622228 623517 626733 631913 633508 641928 641999 645233 645891 650603 670376 670689 670773 671734 677552 679396 679447 679462 680195 693137 701501 709784 711891 712649 712712 714193 715096 715559 716236 716373 716746 717731 718955 721835 723982 726719 728038 743380 743771 748243 748695 770256 773554 775140 775803 776022 776307 776971 778364 786255 789521 799362 800947 804459 808511 810770 815331 815479 818377 820768 820980 821316 822642 827206 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно куни групповуха…"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн куннилингус оральн секс группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн куннилингус оральн секс группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.92%) |
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.