Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.23 ms (81.94%) |
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 14700 61726 120432 150507 150820 187960 358453 387856 388718 388739 391652 393056 393486 396975 397855 397889 397942 398969 400845 401109 406899 409048 409310 411012 411731 411809 412015 415790 416258 439722 439821 440868 442987 447796 448727 450117 451480 464198 464420 466020 466190 466196 466801 466877 466907 467912 467955 468354 468373 469321 469575 470190 470468 475842 479082 479102 486340 486346 490783 497506 503431 503845 509192 516469 518454 518545 524778 529701 532876 533734 535436 536451 540548 541889 545209 547409 549221 552593 555064 555082 571144 578427 583062 591333 591877 593842 604302 604514 604605 619096 632087 682811 706888 710531 714909 715372 720713 721693 726838 729891 731836 733338 735028 736196 742433 746682 758152 759939 761012 761030 761275 764144 766647 767127 777417 788981 802195 816052 817536 823444 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (11.41%) |
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 758152 466190 591333 150507 411731 529701 714909 742433 467955 466020 464198 388739 391652 497506 578427 397889 409310 726838 524778 411012 816052 555064 735028 401109 412015 416258 411809 518454 540548 766647 409048 466196 535436 817536 721693 788981 545209 400845 479082 486346 761030 397855 518545 466801 466907 761275 187960 387856 503845 503431 541889 442987 619096 571144 591877 593842 440868 393486 397942 759939 767127 761012 710531 448727 823444 393056 469321 464420 536451 516469 470190 466877 451480 486340 447796 450117 533734 555082 552593 604514 733338 764144 720713 415790 396975 583062 490783 439722 439821 150820 358453 682811 715372 706888 604302 729891 731836 736196 746682 802195 14700 470468 468373 467912 547409 604605 388718 468354 509192 632087 120432 61726 777417 406899 475842 532876 469575 549221 479102 398969 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.93%) |
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 14700 61726 120432 150507 150820 187960 358453 387856 388718 388739 391652 393056 393486 396975 397855 397889 397942 398969 400845 401109 406899 409048 409310 411012 411731 411809 412015 415790 416258 439722 439821 440868 442987 447796 448727 450117 451480 464198 464420 466020 466190 466196 466801 466877 466907 467912 467955 468354 468373 469321 469575 470190 470468 475842 479082 479102 486340 486346 490783 497506 503431 503845 509192 516469 518454 518545 524778 529701 532876 533734 535436 536451 540548 541889 545209 547409 549221 552593 555064 555082 571144 578427 583062 591333 591877 593842 604302 604514 604605 619096 632087 682811 706888 710531 714909 715372 720713 721693 726838 729891 731836 733338 735028 736196 742433 746682 758152 759939 761012 761030 761275 764144 766647 767127 777417 788981 802195 816052 817536 823444 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature dick"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature член"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mature член"
]
|
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.