Query Metrics
7
Database Queries
7
Different statements
174.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.80 ms (87.24%) |
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 6892 38343 64314 79677 134404 146341 183517 191661 201885 207918 224641 295200 350980 357977 382799 386442 387346 389676 390521 396885 397970 398009 398197 399886 399899 399902 401547 402167 402381 403478 411072 414682 423602 441811 441955 444715 448499 448911 449187 456950 458579 459291 460133 462831 465458 466349 468324 468785 470693 474159 474243 477443 493727 504657 513184 522144 525745 529920 532615 532616 534141 542726 545150 546155 548838 550519 551009 554348 557537 562304 563628 573813 576791 588390 589589 616846 624469 626800 629643 637286 650235 653099 679579 703022 705051 714410 714740 719113 719422 720267 722237 722328 722932 724441 734671 739920 740017 742066 742293 747002 748010 748990 751230 755548 760273 760904 772357 777971 779528 790182 790618 795902 796382 798920 802575 803419 803943 806821 807418 812551 ] |
||||||||||||||||||||||||||||||
|
11.78 ms (6.77%) |
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 224641 79677 6892 396885 398197 402167 401547 441811 423602 441955 444715 449187 448499 474243 493727 448911 474159 522144 529920 532616 504657 513184 532615 534141 462831 465458 468324 477443 573813 576791 542726 545150 546155 554348 563628 550519 551009 679579 703022 714740 720267 722932 653099 714410 719113 722237 650235 719422 548838 562304 588390 589589 616846 624469 629643 626800 637286 777971 779528 790182 790618 806821 796382 742066 742293 748990 751230 795902 803943 807418 812551 724441 739920 747002 748010 760273 755548 734671 740017 760904 772357 705051 722328 798920 802575 803419 64314 382799 399886 468785 146341 350980 399899 399902 191661 403478 459291 38343 183517 357977 386442 389676 398009 402381 456950 458579 466349 470693 414682 460133 557537 525745 134404 201885 207918 295200 387346 390521 397970 411072 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.24%) |
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 6892 38343 64314 79677 134404 146341 183517 191661 201885 207918 224641 295200 350980 357977 382799 386442 387346 389676 390521 396885 397970 398009 398197 399886 399899 399902 401547 402167 402381 403478 411072 414682 423602 441811 441955 444715 448499 448911 449187 456950 458579 459291 460133 462831 465458 466349 468324 468785 470693 474159 474243 477443 493727 504657 513184 522144 525745 529920 532615 532616 534141 542726 545150 546155 548838 550519 551009 554348 557537 562304 563628 573813 576791 588390 589589 616846 624469 626800 629643 637286 650235 653099 679579 703022 705051 714410 714740 719113 719422 720267 722237 722328 722932 724441 734671 739920 740017 742066 742293 747002 748010 748990 751230 755548 760273 760904 772357 777971 779528 790182 790618 795902 796382 798920 802575 803419 803943 806821 807418 812551 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"губки"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"губ"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"губ"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.76%) |
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.