Query Metrics
7
Database Queries
7
Different statements
143.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.24 ms (82.60%) |
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 415964 420351 422290 424220 429440 436115 437988 443433 445329 445550 446977 448083 449499 449741 455207 457152 458243 458407 463384 468288 469540 470856 479018 479782 485133 487666 488477 490219 491781 492523 494285 496554 496977 498809 499178 500300 500732 502991 505279 506966 509201 509642 509660 511254 511492 514218 515568 517329 518745 520354 520737 522205 522985 523565 524114 524866 526199 528363 528567 528923 537966 546786 550092 552415 552567 556531 558071 559279 560667 560836 560839 562325 562921 565499 565501 566326 566667 568328 573156 573740 574559 574718 576008 582334 582631 584712 585984 590633 592645 597240 600471 602371 602439 604016 604051 604289 604364 608584 609604 616869 619165 621330 621767 625533 627338 631504 634230 647877 648575 651660 670745 695156 809902 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (11.29%) |
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 436115 449499 458243 445550 470856 415964 422290 528567 509201 492523 498809 445329 458407 479782 490219 528363 537966 518745 526199 576008 550092 558071 560839 566326 552567 560667 560836 562921 565499 695156 651660 573740 602371 602439 585984 600471 627338 429440 437988 479018 443433 488477 505279 517329 502991 468288 469540 449741 499178 511492 522205 524114 524866 485133 574559 574718 552415 562325 582334 619165 621767 590633 592645 616869 609604 448083 420351 500300 500732 509642 509660 491781 496977 522985 514218 625533 528923 446977 496554 511254 647877 670745 809902 424220 457152 506966 494285 487666 546786 566667 608584 463384 573156 556531 648575 584712 604016 604051 604289 631504 455207 597240 559279 582631 604364 568328 565501 634230 523565 520354 520737 515568 621330 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.65%) |
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 415964 420351 422290 424220 429440 436115 437988 443433 445329 445550 446977 448083 449499 449741 455207 457152 458243 458407 463384 468288 469540 470856 479018 479782 485133 487666 488477 490219 491781 492523 494285 496554 496977 498809 499178 500300 500732 502991 505279 506966 509201 509642 509660 511254 511492 514218 515568 517329 518745 520354 520737 522205 522985 523565 524114 524866 526199 528363 528567 528923 537966 546786 550092 552415 552567 556531 558071 559279 560667 560836 560839 562325 562921 565499 565501 566326 566667 568328 573156 573740 574559 574718 576008 582334 582631 584712 585984 590633 592645 597240 600471 602371 602439 604016 604051 604289 604364 608584 609604 616869 619165 621330 621767 625533 627338 631504 634230 647877 648575 651660 670745 695156 809902 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy rough"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак rough"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак rough"
]
|
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.