Query Metrics
7
Database Queries
7
Different statements
390.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
366.20 ms (93.81%) |
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 12900 187717 187960 213579 388713 388766 390455 391025 391287 391588 398484 403924 405830 406899 407754 407802 408240 409114 411249 411332 422353 428103 439667 443690 444145 444255 450286 452008 452940 454166 454563 460175 460912 464138 464339 464420 469403 472688 473133 473249 474073 474093 474113 479051 479063 480290 480377 481953 481955 483649 484656 484665 484750 486542 491913 502029 503580 506835 512608 513201 522589 525528 527873 529398 534336 537737 547018 547605 548081 548182 554542 576594 576640 591046 591260 593542 603379 607258 619614 651114 665110 665319 668881 696308 702955 715107 717935 718576 720693 721472 724086 725352 725576 726786 726837 726861 727449 727810 728317 728340 733078 737169 740158 740185 744799 746619 746686 748236 748256 752949 759113 760738 761275 770120 770126 788543 789539 814602 818973 824832 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (3.86%) |
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 576594 715107 651114 702955 547018 548081 603379 759113 728340 746619 770126 744799 760738 213579 474073 818973 668881 593542 789539 725352 726786 727810 740185 724086 725576 737169 721472 411249 443690 388713 547605 720693 591046 388766 391287 444255 187717 390455 391025 403924 406899 408240 407754 464138 481953 481955 464339 473133 474093 486542 512608 522589 534336 506835 503580 460175 469403 479063 554542 548182 696308 665319 717935 718576 607258 591260 727449 746686 748256 726837 761275 728317 748236 788543 187960 391588 472688 12900 452940 479051 460912 474113 398484 405830 444145 450286 483649 513201 824832 525528 726861 770120 409114 814602 537737 576640 740158 733078 407802 480377 464420 452008 529398 527873 665110 619614 473249 454166 454563 502029 439667 422353 484665 484656 484750 480290 411332 491913 752949 428103 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.65%) |
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 12900 187717 187960 213579 388713 388766 390455 391025 391287 391588 398484 403924 405830 406899 407754 407802 408240 409114 411249 411332 422353 428103 439667 443690 444145 444255 450286 452008 452940 454166 454563 460175 460912 464138 464339 464420 469403 472688 473133 473249 474073 474093 474113 479051 479063 480290 480377 481953 481955 483649 484656 484665 484750 486542 491913 502029 503580 506835 512608 513201 522589 525528 527873 529398 534336 537737 547018 547605 548081 548182 554542 576594 576640 591046 591260 593542 603379 607258 619614 651114 665110 665319 668881 696308 702955 715107 717935 718576 720693 721472 724086 725352 725576 726786 726837 726861 727449 727810 728317 728340 733078 737169 740158 740185 744799 746619 746686 748236 748256 752949 759113 760738 761275 770120 770126 788543 789539 814602 818973 824832 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big but"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.