Query Metrics
7
Database Queries
7
Different statements
400.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.84 ms (52.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls cute"
]
|
||||||||||||||||||||||||||||||
|
169.17 ms (42.26%) |
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 309286 382945 390782 401193 462905 524555 530647 531618 537525 542448 545236 550936 556194 568028 571756 576450 585927 594321 595056 595229 598308 598446 607755 607765 607805 608794 616009 616018 621117 634303 636520 636836 644358 645021 648728 655066 655663 655691 658360 661397 670255 671076 673813 684843 689207 706508 707727 710027 710123 712829 717322 718895 721434 722368 729118 729971 730672 731878 733809 736003 739053 739326 739711 739879 740408 740741 741010 742504 742540 745247 745411 748970 751792 754258 754528 754921 756090 757077 757184 758882 760187 760195 761265 762359 764861 766758 768091 768187 772105 773126 774083 774146 776685 778547 780079 780393 781070 781407 782109 783275 788834 790134 790138 791260 792027 792838 795899 796323 796410 800051 802546 805591 807427 811509 812039 817309 820915 821110 821602 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (3.13%) |
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 730672 739711 754258 742540 722368 776685 790138 462905 524555 820915 821110 542448 710027 648728 706508 658360 661397 718895 616009 607765 634303 644358 791260 792027 780079 796323 729118 729971 736003 740741 772105 745411 731878 739326 740408 745247 748970 762359 739879 757077 768187 781070 788834 800051 821602 655691 671076 721434 556194 585927 812039 760187 760195 782109 754921 768091 309286 537525 645021 673813 608794 598446 636836 741010 758882 766758 790134 802546 811509 773126 774083 707727 781407 783275 382945 401193 390782 817309 530647 531618 545236 550936 568028 576450 655663 712829 655066 670255 684843 689207 710123 717322 571756 607805 616018 636520 595056 595229 595655 607755 621117 598308 594321 780393 795899 778547 792838 807427 751792 754528 761265 796410 805591 757184 764861 742504 739053 774146 733809 756090 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.68%) |
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 309286 382945 390782 401193 462905 524555 530647 531618 537525 542448 545236 550936 556194 568028 571756 576450 585927 594321 595056 595229 598308 598446 607755 607765 607805 608794 616009 616018 621117 634303 636520 636836 644358 645021 648728 655066 655663 655691 658360 661397 670255 671076 673813 684843 689207 706508 707727 710027 710123 712829 717322 718895 721434 722368 729118 729971 730672 731878 733809 736003 739053 739326 739711 739879 740408 740741 741010 742504 742540 745247 745411 748970 751792 754258 754528 754921 756090 757077 757184 758882 760187 760195 761265 762359 764861 766758 768091 768187 772105 773126 774083 774146 776685 778547 780079 780393 781070 781407 782109 783275 788834 790134 790138 791260 792027 792838 795899 796323 796410 800051 802546 805591 807427 811509 812039 817309 820915 821110 821602 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк cute"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк cute"
]
|
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.