Query Metrics
7
Database Queries
7
Different statements
180.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.65 ms (86.02%) |
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 99632 249622 309095 397639 409214 415928 423094 423128 443949 472814 478103 479885 494682 506544 512350 526404 527535 530412 530651 532402 533700 533712 534864 535371 535396 535407 535408 536082 537764 540550 541166 542475 543559 544534 546456 547445 552497 552587 559434 560164 560493 562529 567891 572734 589561 593661 595086 599705 605290 606114 606220 607312 608047 617242 619646 621168 628669 635569 647447 668421 695417 695419 696049 696424 701216 712570 714040 714581 716516 717595 718033 719889 724303 725467 728276 731399 732865 739718 743872 746461 751359 762099 768591 770995 775815 778140 780201 786588 791804 793050 794553 795732 798922 800448 800663 804368 809742 812231 817872 818145 818788 819099 819820 823794 823815 826320 826434 828023 828075 828201 828254 828266 828279 828295 828304 828408 828533 828643 828703 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (7.33%) |
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 800663 534864 535396 562529 621168 793050 769831 775815 526404 506544 423128 818145 823815 818788 819820 826320 828023 828408 668421 701216 533712 536082 530651 533700 535371 535407 532402 547445 559434 593661 599705 778140 795732 800448 809742 812231 731399 743872 714581 718033 99632 544534 647447 716516 717595 695417 794553 746461 712570 415928 725467 804368 479885 512350 817872 826434 828254 530412 546456 751359 791804 472814 780201 543559 249622 309095 478103 732865 798922 527535 443949 409214 628669 535408 542475 552587 560493 567891 572734 696049 714040 719889 606114 635569 606220 608047 619646 786588 739718 768591 728276 617242 423094 589561 397639 605290 595086 724303 494682 823794 819099 828279 828304 828295 828201 828075 828266 828533 828643 828703 537764 540550 541166 695419 696424 607312 762099 770995 552497 560164 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.25%) |
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 99632 249622 309095 397639 409214 415928 423094 423128 443949 472814 478103 479885 494682 506544 512350 526404 527535 530412 530651 532402 533700 533712 534864 535371 535396 535407 535408 536082 537764 540550 541166 542475 543559 544534 546456 547445 552497 552587 559434 560164 560493 562529 567891 572734 589561 593661 595086 599705 605290 606114 606220 607312 608047 617242 619646 621168 628669 635569 647447 668421 695417 695419 696049 696424 701216 712570 714040 714581 716516 717595 718033 719889 724303 725467 728276 731399 732865 739718 743872 746461 751359 762099 768591 770995 775815 778140 780201 786588 791804 793050 794553 795732 798922 800448 800663 804368 809742 812231 817872 818145 818788 819099 819820 823794 823815 826320 826434 828023 828075 828201 828254 828266 828279 828295 828304 828408 828533 828643 828703 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf public oral"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf на oral улиц"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf на oral улиц"
]
|
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.