Query Metrics
7
Database Queries
7
Different statements
374.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
348.90 ms (93.16%) |
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 152973 385781 388309 392611 415784 415833 427057 437948 448401 454416 456250 459178 465432 469230 469231 469234 469239 469248 469254 478554 481557 483757 486842 497125 501475 504132 523072 530094 530312 530405 530441 532361 534339 534353 535391 537828 541669 541762 543593 543757 544956 545210 545267 549992 556093 556761 557255 558106 558145 562953 568180 569618 576480 577493 579123 580944 599402 606792 613629 619094 634369 634452 634463 639116 647219 650027 652299 652357 661004 661378 676194 679415 680945 680950 683766 688999 692108 692713 698819 699859 702143 710206 714004 714048 717224 721950 721965 721972 732923 734069 735410 736480 749424 752148 757310 761157 768983 771498 778523 778765 782745 785526 787013 789045 789265 789335 791311 791491 792434 793050 795308 803684 805138 809537 809736 812241 813271 813296 813960 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (4.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 545210 652357 661004 650027 652299 679415 680950 683766 699859 556761 634369 639116 599402 619094 634452 613629 702143 714048 415833 437948 469230 469248 569618 558106 752148 469231 469254 501475 486842 415784 530312 545267 549992 481557 469239 530094 535391 568180 580944 557255 717224 721950 721972 721965 785526 778765 782745 789265 735410 736480 787013 789335 803684 734069 771498 732923 769831 749424 757310 761157 789045 791491 809537 579123 388309 456250 483757 454416 465432 809736 469234 478554 385781 448401 504132 676194 710206 152973 392611 813960 805138 812241 813296 791311 792434 793050 795308 813271 497125 534339 523072 534353 541762 543593 558145 661378 698819 680945 688999 692108 692713 606792 768983 634463 778523 459178 562953 427057 530405 537828 530441 532361 541669 576480 577493 543757 544956 556093 647219 714004 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (0.78%) |
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 152973 385781 388309 392611 415784 415833 427057 437948 448401 454416 456250 459178 465432 469230 469231 469234 469239 469248 469254 478554 481557 483757 486842 497125 501475 504132 523072 530094 530312 530405 530441 532361 534339 534353 535391 537828 541669 541762 543593 543757 544956 545210 545267 549992 556093 556761 557255 558106 558145 562953 568180 569618 576480 577493 579123 580944 599402 606792 613629 619094 634369 634452 634463 639116 647219 650027 652299 652357 661004 661378 676194 679415 680945 680950 683766 688999 692108 692713 698819 699859 702143 710206 714004 714048 717224 721950 721965 721972 732923 734069 735410 736480 749424 752148 757310 761157 768983 771498 778523 778765 782745 785526 787013 789045 789265 789335 791311 791491 792434 793050 795308 803684 805138 809537 809736 812241 813271 813296 813960 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur beach"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.43%) |
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.