Query Metrics
8
Database Queries
8
Different statements
349.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.42 ms (59.70%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ô3\x16ıØrðÜ▀Õfý´äm"
]
|
||||||||||||||||||||||||||||||
|
120.85 ms (34.62%) |
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 79479 79742 391496 397403 398435 398643 398790 418693 419354 429742 455207 455769 456640 461880 467987 470142 471148 474903 475920 481731 491000 507293 507404 509366 516387 516429 522497 526948 527551 531582 535219 541010 554018 563252 583357 583583 597498 599623 604379 608313 627280 636143 650896 658485 658553 672989 676205 683039 687418 691146 708156 712539 716597 716626 716645 716727 716743 719557 720081 724933 726178 727539 727951 729070 729660 729780 734294 738777 739564 739584 740282 740993 746409 754375 760696 763292 763293 765196 768181 768801 768807 774717 777977 778082 778929 778959 779228 779435 779436 779484 779488 779505 779722 781613 784697 785444 786421 786745 787982 788391 791133 791137 791173 792114 792582 793430 793456 793800 793978 799557 800559 805053 810592 810607 810612 811775 814207 816160 826660 ] |
||||||||||||||||||||||||||||||
|
10.28 ms (2.94%) |
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 604379 784697 785444 461880 467987 474903 491000 507293 516387 397403 398435 455769 475920 535219 527551 531582 583357 554018 563252 583583 650896 712539 719557 658485 683039 691146 658553 676205 687418 708156 599623 608313 779228 779435 779488 779505 779722 777977 788391 791137 781613 786745 787982 791133 793800 793978 810612 724933 727951 729660 740282 726178 729070 734294 739564 754375 765196 768801 738777 727539 739584 768181 627280 720081 774717 778959 779436 786421 791173 792582 805053 810607 79479 79742 398790 418693 429742 597498 778082 672989 481731 398643 470142 810592 419354 826660 816160 522497 541010 716743 716626 716645 792114 799557 811775 793456 800559 729780 793430 763293 740993 765727 746409 763292 716727 778929 391496 526948 509366 507404 636143 516429 471148 456640 455207 814207 716597 779484 760696 768807 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.79%) |
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 79479 79742 391496 397403 398435 398643 398790 418693 419354 429742 455207 455769 456640 461880 467987 470142 471148 474903 475920 481731 491000 507293 507404 509366 516387 516429 522497 526948 527551 531582 535219 541010 554018 563252 583357 583583 597498 599623 604379 608313 627280 636143 650896 658485 658553 672989 676205 683039 687418 691146 708156 712539 716597 716626 716645 716727 716743 719557 720081 724933 726178 727539 727951 729070 729660 729780 734294 738777 739564 739584 740282 740993 746409 754375 760696 763292 763293 765196 768181 768801 768807 774717 777977 778082 778929 778959 779228 779435 779436 779484 779488 779505 779722 781613 784697 785444 786421 786745 787982 788391 791133 791137 791173 792114 792582 793430 793456 793800 793978 799557 800559 805053 810592 810607 810612 811775 814207 816160 826660 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 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.