Query Metrics
7
Database Queries
7
Different statements
157.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.41 ms (80.80%) |
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 399824 400958 400965 401500 401880 406171 408460 410682 415618 426009 427101 428257 428328 429088 429761 429764 431540 432883 433279 433312 439010 439858 440041 442216 443103 443433 445739 446167 448562 451266 451620 452483 453162 454364 456244 457007 457293 458063 465971 468680 473392 478044 483553 485899 486082 487087 487197 489120 490507 500268 500335 501313 507646 513664 514443 515690 515793 515892 517329 519392 520714 523856 524072 525462 530633 530805 531177 532349 532785 537674 552401 554805 557249 559942 561073 564541 571327 572544 575806 578258 585999 586033 588071 592332 594406 596437 604295 606801 610607 616315 619692 620783 627725 632561 633798 634163 634185 637125 641702 641986 643415 647877 648499 650016 675021 676624 677293 678067 678089 678141 678495 683259 696518 699610 700294 704528 720927 731921 732069 799985 ] |
||||||||||||||||||||||||||||||
|
19.43 ms (12.32%) |
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 704528 696518 552401 586033 594406 616315 634163 641702 637125 620783 643415 731921 799985 732069 610607 700294 445739 448562 400958 428328 465971 432883 439010 451266 433279 439858 440041 443433 457293 473392 456244 500335 486082 513664 514443 524072 487087 517329 400965 408460 429088 442216 410682 428257 429764 431540 451620 487197 452483 478044 537674 530633 532349 532785 515690 515892 520714 531177 578258 564541 575806 559942 650016 678067 683259 648499 675021 676624 677293 720927 572544 588071 596437 634185 641986 585999 633798 592332 632561 604295 606801 619692 427101 399824 457007 458063 401500 401880 426009 468680 523856 489120 525462 483553 490507 500268 507646 433312 557249 627725 515793 406171 415618 443103 429761 454364 446167 485899 453162 519392 501313 530805 561073 554805 571327 647877 678089 678141 699610 678495 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.80%) |
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 399824 400958 400965 401500 401880 406171 408460 410682 415618 426009 427101 428257 428328 429088 429761 429764 431540 432883 433279 433312 439010 439858 440041 442216 443103 443433 445739 446167 448562 451266 451620 452483 453162 454364 456244 457007 457293 458063 465971 468680 473392 478044 483553 485899 486082 487087 487197 489120 490507 500268 500335 501313 507646 513664 514443 515690 515793 515892 517329 519392 520714 523856 524072 525462 530633 530805 531177 532349 532785 537674 552401 554805 557249 559942 561073 564541 571327 572544 575806 578258 585999 586033 588071 592332 594406 596437 604295 606801 610607 616315 619692 620783 627725 632561 633798 634163 634185 637125 641702 641986 643415 647877 648499 650016 675021 676624 677293 678067 678089 678141 678495 683259 696518 699610 700294 704528 720927 731921 732069 799985 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"slut teen"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"slut teen"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slut teen"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
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.