Query Metrics
7
Database Queries
7
Different statements
196.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.23 ms (80.49%) |
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 129902 320078 346979 381883 390565 391247 391262 395143 396336 397232 397781 400185 402030 403641 404175 404582 405406 406307 410745 412083 413074 414358 417836 422342 426131 426394 427224 429570 429574 435695 443743 443764 443777 446024 446275 452384 454251 454261 456614 457791 459158 460732 462305 466056 466111 467793 469555 470019 470514 470864 474494 474495 474619 474634 474678 474689 474696 474703 475080 475104 475452 478575 482518 483588 484387 484629 484636 484651 484655 484659 484668 484687 484696 484715 484737 485621 485773 493128 505642 505687 506050 506051 510750 511780 512029 512057 515545 518585 518842 522898 524856 526277 534631 536289 541592 550232 558991 571056 574464 580177 600012 603110 603269 632712 637650 651135 663448 667017 675022 748230 748244 790019 799366 811837 813759 816576 817354 819151 823695 827829 ] |
||||||||||||||||||||||||||||||
|
27.60 ms (14.04%) |
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 823695 446275 452384 456614 541592 443764 462305 466111 474494 422342 443777 466056 474678 474696 484629 484636 484651 484737 484668 474689 484696 515545 558991 675022 603110 395143 400185 403641 406307 404175 404582 426131 435695 413074 412083 414358 813759 475080 485773 493128 446024 478575 457791 469555 485621 512029 526277 534631 536289 511780 512057 518585 524856 505642 505687 522898 470864 474619 475452 482518 571056 574464 580177 667017 651135 663448 550232 600012 603269 632712 637650 790019 811837 799366 748230 748244 443743 454261 460732 470019 474634 475104 390565 454251 391247 391262 429570 429574 467793 474495 474703 470514 506051 510750 518842 484687 506050 484655 484715 483588 484387 484659 129902 320078 346979 381883 396336 397232 397781 402030 405406 426394 417836 410745 427224 817354 816576 819151 827829 459158 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.57%) |
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 129902 320078 346979 381883 390565 391247 391262 395143 396336 397232 397781 400185 402030 403641 404175 404582 405406 406307 410745 412083 413074 414358 417836 422342 426131 426394 427224 429570 429574 435695 443743 443764 443777 446024 446275 452384 454251 454261 456614 457791 459158 460732 462305 466056 466111 467793 469555 470019 470514 470864 474494 474495 474619 474634 474678 474689 474696 474703 475080 475104 475452 478575 482518 483588 484387 484629 484636 484651 484655 484659 484668 484687 484696 484715 484737 485621 485773 493128 505642 505687 506050 506051 510750 511780 512029 512057 515545 518585 518842 522898 524856 526277 534631 536289 541592 550232 558991 571056 574464 580177 600012 603110 603269 632712 637650 651135 663448 667017 675022 748230 748244 790019 799366 811837 813759 816576 817354 819151 823695 827829 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group-mature"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group mature"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group mature"
]
|
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.