Query Metrics
7
Database Queries
7
Different statements
158.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.42 ms (85.85%) |
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 397113 424048 440047 443468 448907 453922 459730 466031 468343 476657 488119 489321 500088 517419 525182 528397 529903 530290 533401 534365 536434 538152 540556 540753 547088 550519 558623 558726 565224 568133 569266 574100 575897 579706 583178 585166 585514 587241 587787 588885 602363 611391 612700 615604 622836 627042 637318 650572 651029 660806 664175 664252 664671 671231 680237 692703 698235 702864 703480 704100 705211 710881 712070 712685 713031 719065 720826 722442 725434 726097 736045 744176 744772 750601 761195 777819 778572 779729 780254 782165 784024 786396 790049 790574 791411 792132 793816 794112 794778 795094 795528 795821 796580 796752 797038 798019 798753 800041 800676 800788 802595 804257 805309 809086 810484 810544 810797 810948 812728 818709 819153 819160 819692 823713 824077 825077 825202 826508 826649 827952 ] |
||||||||||||||||||||||||||||||
|
12.36 ms (7.78%) |
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 750601 602363 698235 424048 443468 476657 453922 536434 500088 528397 533401 722442 713031 574100 627042 790049 805309 397113 440047 824077 825202 826508 826649 819153 819160 819692 825077 818709 823713 827952 466031 488119 448907 459730 468343 489321 525182 540556 538152 540753 517419 529903 530290 534365 575897 583178 547088 565224 569266 550519 558726 568133 579706 664252 671231 703480 712070 712685 650572 660806 692703 702864 704100 710881 651029 664175 664671 680237 705211 719065 720826 558623 587241 622836 585166 585514 588885 615604 587787 637318 611391 612700 777819 778572 784024 786396 790574 792132 794112 795821 796580 798753 800676 809086 810484 810544 810948 779729 780254 782165 793816 795094 795528 796752 797038 798019 800041 800788 804257 812728 725434 736045 744176 744772 761195 791411 794778 802595 810797 726097 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.82%) |
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 397113 424048 440047 443468 448907 453922 459730 466031 468343 476657 488119 489321 500088 517419 525182 528397 529903 530290 533401 534365 536434 538152 540556 540753 547088 550519 558623 558726 565224 568133 569266 574100 575897 579706 583178 585166 585514 587241 587787 588885 602363 611391 612700 615604 622836 627042 637318 650572 651029 660806 664175 664252 664671 671231 680237 692703 698235 702864 703480 704100 705211 710881 712070 712685 713031 719065 720826 722442 725434 726097 736045 744176 744772 750601 761195 777819 778572 779729 780254 782165 784024 786396 790049 790574 791411 792132 793816 794112 794778 795094 795528 795821 796580 796752 797038 798019 798753 800041 800676 800788 802595 804257 805309 809086 810484 810544 810797 810948 812728 818709 819153 819160 819692 823713 824077 825077 825202 826508 826649 827952 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot жен milf"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot wife milf"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot жен milf"
]
|
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.