Query Metrics
7
Database Queries
7
Different statements
159.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.85 ms (81.80%) |
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 187567 282481 389667 394409 395706 395860 396670 399585 400150 422686 428523 458926 474766 482801 515165 515193 545602 545755 546200 550602 564407 571212 575162 576043 576416 581665 591312 592194 592310 598319 598699 598745 599670 603436 609682 611346 617408 619409 620768 620987 623203 624223 632025 636273 636274 637751 640773 647343 649110 657128 663437 663441 663512 664794 665107 665238 666875 671351 671667 672175 673595 675381 685718 686047 687262 687551 694028 698289 698302 699697 699804 699808 702453 703089 704235 704560 704726 705584 706269 706280 706984 714109 714500 718525 719104 720708 721109 721226 721717 721795 722689 722875 723580 724181 724934 729911 729920 741109 741275 742143 742422 747004 747140 748349 749266 761073 775784 775788 784304 788315 790754 800331 800773 803796 807927 811930 811938 815748 816755 816917 ] |
||||||||||||||||||||||||||||||
|
18.86 ms (11.79%) |
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 761073 741275 603436 620768 721109 723580 672175 704560 706269 694028 685718 699804 704726 775784 811938 724934 748349 611346 699808 702453 703089 788315 395860 663437 698302 673595 686047 592310 775788 811930 800331 749266 724181 803796 458926 400150 598745 187567 719104 665238 698289 705584 598319 747004 706280 545602 623203 671667 546200 599670 647343 704235 428523 666875 282481 663512 575162 591312 671351 720708 800773 790754 395706 581665 747140 576043 657128 394409 399585 389667 729920 663441 815748 722875 721226 637751 609682 807927 729911 718525 816917 816755 545755 564407 649110 687262 598699 632025 620987 624223 636274 640773 636273 784304 741109 742143 714500 422686 482801 515165 474766 576416 571212 714109 699697 665107 687551 721717 592194 396670 721795 550602 706984 722689 664794 617408 619409 742422 515193 675381 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.81%) |
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 187567 282481 389667 394409 395706 395860 396670 399585 400150 422686 428523 458926 474766 482801 515165 515193 545602 545755 546200 550602 564407 571212 575162 576043 576416 581665 591312 592194 592310 598319 598699 598745 599670 603436 609682 611346 617408 619409 620768 620987 623203 624223 632025 636273 636274 637751 640773 647343 649110 657128 663437 663441 663512 664794 665107 665238 666875 671351 671667 672175 673595 675381 685718 686047 687262 687551 694028 698289 698302 699697 699804 699808 702453 703089 704235 704560 704726 705584 706269 706280 706984 714109 714500 718525 719104 720708 721109 721226 721717 721795 722689 722875 723580 724181 724934 729911 729920 741109 741275 742143 742422 747004 747140 748349 749266 761073 775784 775788 784304 788315 790754 800331 800773 803796 807927 811930 811938 815748 816755 816917 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen threesome"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen секс втро"
]
|
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.