Query Metrics
7
Database Queries
7
Different statements
160.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.42 ms (86.42%) |
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 356376 382918 388344 400143 420224 425405 429504 438848 445425 453273 454759 466437 467078 480232 483259 485892 489244 490812 509185 511030 513199 515550 515886 524482 524484 524929 531046 533406 533863 536786 539129 541156 541416 549356 550498 550643 552731 568233 572625 574466 576120 578698 578719 578814 586038 586079 587170 591335 591594 593267 594243 601757 603365 607601 609111 618660 629324 632929 638956 641010 684064 684067 687419 710922 713058 714364 715072 722321 726113 731761 733394 735436 738276 740569 741354 747999 750021 751200 751516 751534 751553 751593 751614 753123 753573 755140 755354 755495 756057 758215 769410 770122 770131 770137 770234 770252 774748 776473 776774 781952 781960 786977 788121 788319 790699 806470 808682 808711 808862 809049 811242 813777 813959 819245 823552 824563 825774 825841 826720 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (8.32%) |
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 770122 770131 751614 753573 755354 755495 758215 769410 770137 770234 770252 735436 738276 740569 747999 751534 751593 756057 726113 731761 733394 741354 750021 751200 751516 751553 753123 755140 763722 601757 618660 629324 632929 638956 641010 710922 713058 714364 715072 722321 774748 776473 776774 781952 781960 786977 788121 788319 790699 806470 808682 808711 808862 809049 811242 425405 445425 420224 515886 489244 400143 382918 485892 480232 533863 536786 539129 515550 524482 578698 550498 568233 574466 576120 541156 541416 549356 550643 552731 572625 684064 684067 687419 578719 578814 586079 587170 603365 591335 586038 593267 591594 594243 609111 607601 466437 467078 524484 483259 524929 513199 511030 356376 388344 429504 438848 823552 825774 826720 825841 813777 813959 819245 824563 490812 454759 453273 509185 531046 533406 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.47%) |
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 356376 382918 388344 400143 420224 425405 429504 438848 445425 453273 454759 466437 467078 480232 483259 485892 489244 490812 509185 511030 513199 515550 515886 524482 524484 524929 531046 533406 533863 536786 539129 541156 541416 549356 550498 550643 552731 568233 572625 574466 576120 578698 578719 578814 586038 586079 587170 591335 591594 593267 594243 601757 603365 607601 609111 618660 629324 632929 638956 641010 684064 684067 687419 710922 713058 714364 715072 722321 726113 731761 733394 735436 738276 740569 741354 747999 750021 751200 751516 751534 751553 751593 751614 753123 753573 755140 755354 755495 756057 758215 769410 770122 770131 770137 770234 770252 774748 776473 776774 781952 781960 786977 788121 788319 790699 806470 808682 808711 808862 809049 811242 813777 813959 819245 823552 824563 825774 825841 826720 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom erotic"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom эротик"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom эротик"
]
|
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.