Query Metrics
7
Database Queries
7
Different statements
190.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.60 ms (86.83%) |
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 47707 100616 365995 383563 387377 389093 392986 395842 396051 396190 396287 396592 400513 400851 400858 402777 403314 404644 410677 414172 418853 421836 421838 421855 421859 422209 422499 423033 423042 428108 434201 439807 440469 443199 446695 447038 448800 452234 454508 456628 458013 458538 459651 459666 466907 468691 468693 468694 468695 469537 470076 472159 472431 473511 474034 474895 477631 478505 483574 483738 484763 486393 490419 491230 498305 498963 500686 508204 509823 511391 511819 513696 516485 520211 521220 527914 529122 530371 532968 534839 535057 538773 541409 560107 561023 565119 568357 571399 575601 576291 582443 592512 596684 597059 601772 604341 605382 620891 622583 639816 643011 644923 689521 691209 693941 698550 717929 721369 727751 733868 741187 770141 775172 789225 801917 803122 804765 811993 821532 826248 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (7.92%) |
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 770141 698550 721369 775172 789225 803122 389093 100616 396190 392986 402777 468695 47707 396287 396592 410677 428108 443199 418853 423042 826248 821532 447038 458538 474895 484763 468691 478505 448800 483738 498305 509823 511819 511391 532968 538773 520211 529122 468693 565119 689521 693941 717929 691209 582443 596684 605382 620891 597059 643011 601772 622583 592512 604341 804765 801917 733868 727751 741187 811993 400851 404644 423033 400858 421836 422499 365995 387377 421838 421855 454508 470076 400513 403314 516485 527914 483574 491230 521220 383563 440469 535057 530371 561023 639816 414172 421859 459651 422209 439807 500686 395842 396051 434201 644923 452234 468694 469537 473511 486393 446695 456628 458013 459666 466907 474034 477631 490419 498963 508204 513696 534839 472159 472431 541409 571399 576291 560107 568357 575601 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.39%) |
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 47707 100616 365995 383563 387377 389093 392986 395842 396051 396190 396287 396592 400513 400851 400858 402777 403314 404644 410677 414172 418853 421836 421838 421855 421859 422209 422499 423033 423042 428108 434201 439807 440469 443199 446695 447038 448800 452234 454508 456628 458013 458538 459651 459666 466907 468691 468693 468694 468695 469537 470076 472159 472431 473511 474034 474895 477631 478505 483574 483738 484763 486393 490419 491230 498305 498963 500686 508204 509823 511391 511819 513696 516485 520211 521220 527914 529122 530371 532968 534839 535057 538773 541409 560107 561023 565119 568357 571399 575601 576291 582443 592512 596684 597059 601772 604341 605382 620891 622583 639816 643011 644923 689521 691209 693941 698550 717929 721369 727751 733868 741187 770141 775172 789225 801917 803122 804765 811993 821532 826248 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red anal"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red анал"
]
|
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.