Query Metrics
7
Database Queries
7
Different statements
184.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.46 ms (85.30%) |
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 411893 415941 463863 465618 469619 474670 475032 480390 484404 492232 501534 503127 506801 508273 519440 526895 530750 530795 530934 531217 532743 533724 535467 536571 536632 537662 537882 537927 542207 544848 545197 550380 550409 551892 552514 562791 565525 568054 576637 580622 583449 589472 594008 594467 594635 598194 600083 606648 620661 624280 626144 626293 630487 632605 632696 634543 634849 636003 637115 643234 643263 644952 644960 646014 649560 651613 653559 655871 659404 662870 667392 668537 670198 670342 670619 673969 688068 693356 700851 701771 702619 704916 705180 712887 714256 716557 717720 720117 720621 721150 722224 722330 722619 724255 725151 725169 727687 733852 733896 736412 741306 743040 748661 748706 750550 753545 754147 756207 758194 758523 758989 758997 760453 766706 770429 782402 785324 790199 802375 827642 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (9.48%) |
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 503127 565525 670619 717720 722224 594635 624280 636003 637115 632605 827642 670198 722619 712887 580622 600083 606648 643234 727687 736412 743040 770429 756207 714256 720117 802375 506801 550409 465618 668537 643263 766706 469619 484404 501534 508273 463863 492232 474670 562791 670342 594467 598194 733896 701771 673969 785324 725151 741306 758194 748706 644960 532743 530934 544848 576637 583449 542207 649560 655871 662870 651613 688068 705180 716557 720621 589472 620661 626144 594008 626293 634849 725169 754147 724255 632696 704916 721150 782402 411893 653559 758989 760453 758523 480390 700851 526895 634543 753545 758997 748661 415941 693356 733852 667392 630487 790199 750550 644952 475032 531217 535467 536571 536632 537882 519440 530795 537662 530750 533724 537927 550380 568054 545197 551892 552514 702619 722330 646014 659404 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.60%) |
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 411893 415941 463863 465618 469619 474670 475032 480390 484404 492232 501534 503127 506801 508273 519440 526895 530750 530795 530934 531217 532743 533724 535467 536571 536632 537662 537882 537927 542207 544848 545197 550380 550409 551892 552514 562791 565525 568054 576637 580622 583449 589472 594008 594467 594635 598194 600083 606648 620661 624280 626144 626293 630487 632605 632696 634543 634849 636003 637115 643234 643263 644952 644960 646014 649560 651613 653559 655871 659404 662870 667392 668537 670198 670342 670619 673969 688068 693356 700851 701771 702619 704916 705180 712887 714256 716557 717720 720117 720621 721150 722224 722330 722619 724255 725151 725169 727687 733852 733896 736412 741306 743040 748661 748706 750550 753545 754147 756207 758194 758523 758989 758997 760453 766706 770429 782402 785324 790199 802375 827642 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ass casting"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал жоп кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.