Query Metrics
7
Database Queries
7
Different statements
231.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.10 ms (89.82%) |
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 106970 156014 187567 366040 382958 386667 389442 390231 390294 390610 391002 400139 400150 401821 407561 407754 408471 411360 411596 411730 413475 415594 416848 416926 419520 448069 450286 451797 454220 460633 460980 465209 466081 466157 467921 468682 469403 471340 471713 474394 476252 479024 479144 485129 486340 486542 490684 490896 490904 493539 500184 513341 520979 522627 523169 526016 526339 528317 530537 534261 534317 538957 540530 543985 544501 552582 561755 563217 590130 607618 630711 700752 716236 717681 720604 725165 725359 725399 726144 726325 726700 726831 727769 728191 728291 728506 728882 735550 737178 741780 744828 746686 748242 748256 758280 759502 759740 761294 770125 774172 776745 788959 789521 794651 797255 801057 803918 813226 814399 815745 815804 817398 817690 824184 825258 826489 826880 826938 827298 828835 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (5.91%) |
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 826489 828835 540530 803918 391002 552582 813226 726831 728291 725165 726700 717681 474394 386667 106970 389442 390294 460980 528317 744828 759502 761294 407561 415594 493539 500184 400150 413475 411730 817398 454220 467921 530537 538957 544501 716236 700752 720604 788959 725359 725399 741780 758280 774172 726144 770125 728191 735550 737178 789521 187567 366040 419520 411360 390231 520979 817690 824184 826880 827298 630711 726325 728506 156014 407754 486542 469403 746686 748256 794651 748242 727769 479024 450286 466081 466157 523169 590130 416926 416848 814399 448069 526339 543985 468682 471340 490684 513341 522627 382958 825258 826938 815804 561755 776745 797255 801057 759740 728882 476252 563217 607618 479144 486340 490904 490896 390610 400139 401821 411596 408471 815745 465209 485129 451797 460633 534261 526016 534317 471713 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.22%) |
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 106970 156014 187567 366040 382958 386667 389442 390231 390294 390610 391002 400139 400150 401821 407561 407754 408471 411360 411596 411730 413475 415594 416848 416926 419520 448069 450286 451797 454220 460633 460980 465209 466081 466157 467921 468682 469403 471340 471713 474394 476252 479024 479144 485129 486340 486542 490684 490896 490904 493539 500184 513341 520979 522627 523169 526016 526339 528317 530537 534261 534317 538957 540530 543985 544501 552582 561755 563217 590130 607618 630711 700752 716236 717681 720604 725165 725359 725399 726144 726325 726700 726831 727769 728191 728291 728506 728882 735550 737178 741780 744828 746686 748242 748256 758280 759502 759740 761294 770125 774172 776745 788959 789521 794651 797255 801057 803918 813226 814399 815745 815804 817398 817690 824184 825258 826489 826880 826938 827298 828835 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting mature"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг mature"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.63%) |
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.