Query Metrics
7
Database Queries
7
Different statements
178.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.60 ms (86.46%) |
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 385734 407809 417046 417319 417827 419240 420504 423106 424924 425496 427766 430535 434763 439475 440650 440937 440946 444991 445310 445605 450982 452367 454502 457002 457014 458645 460854 463248 466702 467684 467762 467948 468106 468815 471754 472062 477065 482602 487553 488313 489812 491302 495901 496013 498254 501706 502190 502552 504148 504679 504863 505423 506264 508512 508521 508524 511825 511840 515610 515619 517374 517448 518110 524080 525843 526629 526637 527101 527139 527732 534023 545725 545729 557043 559617 559722 561303 568541 572211 577468 579940 580982 584159 585838 588374 592613 593279 593876 594031 594992 595676 598980 599617 599883 602104 602199 604319 604732 610120 610587 612614 612933 614428 616091 624886 631478 643489 650863 653726 721129 721133 755652 763522 774799 785594 786525 803524 805224 809271 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (8.55%) |
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 425496 534023 585838 385734 482602 588374 599883 610587 592613 595676 598980 599617 612614 594031 602104 584159 616091 594992 631478 612933 472062 427766 504148 457014 467948 495901 488313 417827 423106 424924 505423 439475 440650 407809 417046 417319 440937 434763 450982 457002 491302 525843 502552 477065 557043 572211 545725 545729 568541 650863 721129 577468 579940 593876 604319 610120 624886 786525 803524 755652 763522 614428 809271 419240 468815 444991 460854 467762 517448 504679 526629 496013 487553 502190 524080 527732 420504 430535 440946 452367 466702 458645 508524 511840 498254 501706 527139 508512 559722 580982 559617 561303 653726 721133 557804 602199 593279 643489 604732 774799 785594 805224 463248 468106 454502 471754 445310 467684 445605 515610 515619 489812 504863 518110 506264 508521 517374 511825 526637 527101 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.37%) |
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 385734 407809 417046 417319 417827 419240 420504 423106 424924 425496 427766 430535 434763 439475 440650 440937 440946 444991 445310 445605 450982 452367 454502 457002 457014 458645 460854 463248 466702 467684 467762 467948 468106 468815 471754 472062 477065 482602 487553 488313 489812 491302 495901 496013 498254 501706 502190 502552 504148 504679 504863 505423 506264 508512 508521 508524 511825 511840 515610 515619 517374 517448 518110 524080 525843 526629 526637 527101 527139 527732 534023 545725 545729 557043 559617 559722 561303 568541 572211 577468 579940 580982 584159 585838 588374 592613 593279 593876 594031 594992 595676 598980 599617 599883 602104 602199 604319 604732 610120 610587 612614 612933 614428 616091 624886 631478 643489 650863 653726 721129 721133 755652 763522 774799 785594 786525 803524 805224 809271 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur facial"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск facial"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск facial"
]
|
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.