Query Metrics
7
Database Queries
7
Different statements
404.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.82 ms (52.58%) |
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 6768 14360 28591 29661 68084 142949 192814 210880 281801 321858 336584 382256 383625 384315 386324 387817 388402 392455 395710 395985 396618 397110 397154 398724 400967 415392 420023 420736 458275 459230 466484 469964 472225 474215 477561 477606 477613 477698 478614 483640 487039 489546 491178 492313 497783 501245 516727 518823 522401 531355 531946 532191 533301 533345 533447 534192 534504 534717 534739 535693 537520 537806 538128 539104 540892 544287 545403 548499 554970 731490 731622 736873 743413 752485 755919 756240 759172 763939 815424 815612 815660 815872 815894 816296 816459 816913 816967 817141 817501 818704 818901 819188 820543 820638 820806 820983 821025 821095 821815 821991 821994 822254 822430 822631 822653 822662 822854 822956 823045 823084 823307 823343 823375 823507 824840 827645 828099 828589 ] |
||||||||||||||||||||||||||||||
|
165.67 ms (40.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 6768 14360 28591 29661 68084 142949 192814 210880 281801 321858 336584 382256 383625 384315 386324 387817 388402 392455 395710 395985 396618 397110 397154 398724 400967 415392 420023 420736 458275 459230 466484 469964 472225 474215 477561 477606 477613 477698 478614 483640 487039 489546 491178 492313 497783 501245 516727 518823 522401 531355 531946 532191 533301 533345 533447 534192 534504 534717 534739 535693 537520 537806 538128 539104 540892 544287 545403 548499 554970 731490 731622 736873 743413 752485 755919 756240 759172 763939 815424 815612 815660 815872 815894 816296 816459 816913 816967 817141 817501 818704 818901 819188 820543 820638 820806 820983 821025 821095 821815 821991 821994 822254 822430 822631 822653 822662 822854 822956 823045 823084 823307 823343 823375 823507 824840 827645 828099 828589 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (3.13%) |
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 763939 743413 752485 731490 731622 736873 29661 395710 388402 192814 501245 400967 398724 28591 516727 383625 387817 539104 531355 534717 535693 537806 491178 544287 756240 825709 827645 522401 533301 386324 68084 142949 395985 321858 382256 420023 822653 818901 821991 824840 815872 819188 459230 469964 518823 532191 533345 534739 537520 533447 534504 472225 548499 545403 554970 755919 759172 392455 415392 281801 384315 210880 336584 6768 14360 396618 397110 397154 420736 815424 815612 815660 822956 823291 823507 540892 815894 817141 818704 820543 820983 821994 822254 823084 816459 816913 816967 817501 820806 821025 821095 821815 822430 823045 823343 816296 820638 822631 822662 822854 823307 823375 828099 828589 474215 477613 483640 489546 458275 477561 477698 478614 492313 466484 477606 487039 497783 531946 534192 538128 ] |
||||||||||||||||||||||||||||||
|
7.49 ms (1.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс white"
]
|
||||||||||||||||||||||||||||||
|
2.45 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс white"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex white"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.41%) |
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.