Query Metrics
7
Database Queries
7
Different statements
425.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.14 ms (48.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
191.79 ms (45.09%) |
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 424876 429181 429793 445737 446108 448542 452257 455088 473501 485175 493810 495126 496074 513664 522903 523418 527053 530012 530385 530643 531134 531160 531179 531211 531233 531248 531258 533466 533854 534961 534977 534996 536178 536283 536291 536292 536550 536606 536620 536640 536774 537673 537747 537890 537899 538416 538881 544854 545117 545399 550200 556911 579369 585096 585143 591668 597246 599851 600008 600012 600016 600280 600340 601514 601575 601623 604558 617429 628085 628089 628114 630266 631199 632021 632034 632687 632970 633773 634189 634793 637107 637139 637425 639048 639335 640732 640733 641702 644940 645812 646875 647942 648863 649583 650470 650764 651135 651180 666585 675002 675022 677671 678032 678109 679326 679773 679785 680180 680198 696214 696450 699627 704216 704528 716085 718979 720237 720291 742428 748365 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (3.97%) |
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 537899 530012 531160 531211 538881 527053 536283 536292 537747 579369 545399 556911 647942 648863 696450 720237 645812 651135 677671 704528 675002 601514 641702 597246 600012 617429 628114 637425 628089 634793 628085 632687 633773 640733 455088 493810 496074 513664 522903 675022 429181 585143 485175 495126 536178 531134 531248 534977 536291 536620 537673 538416 523418 531179 531233 534996 536550 537890 531258 533854 534961 536606 473501 544854 550200 650470 679785 680198 699627 649583 651180 666585 680180 704216 650764 696214 718979 545117 637107 639048 639335 600280 604558 637139 632034 632970 599851 600016 601575 631199 632021 748365 742428 630266 716085 720291 446108 429793 424876 533466 600340 445737 585096 644940 452257 448542 530385 536774 530643 536640 679773 678109 679326 646875 678032 640732 600008 634189 591668 601623 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (0.76%) |
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 424876 429181 429793 445737 446108 448542 452257 455088 473501 485175 493810 495126 496074 513664 522903 523418 527053 530012 530385 530643 531134 531160 531179 531211 531233 531248 531258 533466 533854 534961 534977 534996 536178 536283 536291 536292 536550 536606 536620 536640 536774 537673 537747 537890 537899 538416 538881 544854 545117 545399 550200 556911 579369 585096 585143 591668 597246 599851 600008 600012 600016 600280 600340 601514 601575 601623 604558 617429 628085 628089 628114 630266 631199 632021 632034 632687 632970 633773 634189 634793 637107 637139 637425 639048 639335 640732 640733 641702 644940 645812 646875 647942 648863 649583 650470 650764 651135 651180 666585 675002 675022 677671 678032 678109 679326 679773 679785 680180 680198 696214 696450 699627 704216 704528 716085 718979 720237 720291 742428 748365 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов анал кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial anal casting"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.34%) |
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.