Query Metrics
7
Database Queries
7
Different statements
372.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.05 ms (55.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск спящ"
]
|
||||||||||||||||||||||||||||||
|
138.06 ms (37.04%) |
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 379600 389639 391027 392054 397901 421914 422078 422360 424461 424646 432731 432990 437204 437613 439804 443184 444288 455408 458061 465829 466159 466953 470154 473924 477053 480323 484193 485179 489283 490897 493175 496057 497818 499341 501785 502719 502976 504669 505026 510762 513260 513538 514118 514789 517572 519540 519854 522122 524509 525377 526016 528235 543351 545917 546128 546687 546737 546942 547834 547928 548593 548782 549153 549953 551162 551800 554252 555608 555933 556840 558006 560584 561639 562285 563141 564423 565287 565599 567712 574503 574807 575103 575482 576387 578856 579196 579221 580239 580823 586728 597067 597113 597284 598086 598532 598731 598909 599297 599371 601355 615495 616481 617203 619344 621443 631302 659398 679355 679365 690718 697892 721395 721795 725197 726882 728359 770928 787944 809688 826267 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (4.62%) |
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 455408 470154 480323 391027 392054 422078 422360 465829 379600 424461 432990 443184 444288 466159 437204 501785 513260 513538 485179 514118 522122 525377 528235 484193 489283 497818 502976 505026 517572 519540 490897 493175 496057 524509 549953 826267 499341 502719 504669 514789 526016 510762 519854 543351 545917 548593 551162 555608 555933 565287 565599 575482 576387 546737 546942 547928 548782 549153 551800 554252 556840 562285 567712 574503 558006 560584 564423 574807 578856 580239 659398 697892 679355 679365 690718 546128 546687 547834 561639 563141 575103 579196 579221 580823 616481 619344 631302 598086 598909 599297 599371 601355 615495 586728 597067 597113 597284 598731 598532 617203 621443 725197 809688 728359 770928 726882 721395 721795 787944 424646 432731 437613 439804 458061 466953 473924 477053 389639 397901 421914 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (0.88%) |
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 379600 389639 391027 392054 397901 421914 422078 422360 424461 424646 432731 432990 437204 437613 439804 443184 444288 455408 458061 465829 466159 466953 470154 473924 477053 480323 484193 485179 489283 490897 493175 496057 497818 499341 501785 502719 502976 504669 505026 510762 513260 513538 514118 514789 517572 519540 519854 522122 524509 525377 526016 528235 543351 545917 546128 546687 546737 546942 547834 547928 548593 548782 549153 549953 551162 551800 554252 555608 555933 556840 558006 560584 561639 562285 563141 564423 565287 565599 567712 574503 574807 575103 575482 576387 578856 579196 579221 580239 580823 586728 597067 597113 597284 598086 598532 598731 598909 599297 599371 601355 615495 616481 617203 619344 621443 631302 659398 679355 679365 690718 697892 721395 721795 725197 726882 728359 770928 787944 809688 826267 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sleep"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.52%) |
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.