Query Metrics
7
Database Queries
7
Different statements
204.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.22 ms (89.20%) |
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 480083 484363 484790 498845 505539 507460 509410 510620 511950 514938 517400 523485 525338 526855 528249 528511 530620 531650 532040 532197 535515 535868 536399 539589 540589 540760 541054 541810 542992 543571 544142 544359 544550 545897 546661 546695 547042 547047 548015 549347 550195 550303 551727 555490 556625 558392 559347 561157 562819 565225 565762 566742 569580 569646 571323 571475 572485 577311 577446 578404 578883 579977 581146 581359 583305 584057 584155 586309 588242 588406 588662 589814 592193 593132 593587 593848 594631 594999 597426 597637 598295 598747 600690 602448 602682 602852 603046 603278 604452 605667 605916 613041 620406 621958 622309 622562 626599 627320 631823 634045 634489 634848 635391 636230 642121 646656 648057 649357 653120 653853 662807 666966 668015 670315 671456 672285 672678 678691 690265 691225 ] |
||||||||||||||||||||||||||||||
|
13.17 ms (6.45%) |
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 540760 510620 514938 517400 531650 532040 535515 511950 523485 525338 526855 528249 528511 530620 532197 535868 539589 480083 550195 559347 565762 569646 571323 577311 583305 543571 547047 555490 558392 571475 572485 578404 541054 541810 544142 544550 545897 546695 547042 551727 562819 566742 569580 577446 579977 584155 646656 662807 670315 653120 653853 671456 672678 691225 648057 649357 666966 668015 672285 678691 690265 549347 561157 578883 584057 593587 594631 603046 620406 622562 634045 642121 588406 598295 600690 602682 621958 586309 588662 592193 593132 594999 597637 603278 604452 605667 631823 634848 588242 589814 593848 597426 602852 605916 626599 634489 636230 627320 635391 622309 536399 550303 484790 556625 546661 498845 484363 542992 544359 581359 548015 602448 598747 613041 565225 507460 540589 505539 509410 581146 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.21%) |
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 480083 484363 484790 498845 505539 507460 509410 510620 511950 514938 517400 523485 525338 526855 528249 528511 530620 531650 532040 532197 535515 535868 536399 539589 540589 540760 541054 541810 542992 543571 544142 544359 544550 545897 546661 546695 547042 547047 548015 549347 550195 550303 551727 555490 556625 558392 559347 561157 562819 565225 565762 566742 569580 569646 571323 571475 572485 577311 577446 578404 578883 579977 581146 581359 583305 584057 584155 586309 588242 588406 588662 589814 592193 593132 593587 593848 594631 594999 597426 597637 598295 598747 600690 602448 602682 602852 603046 603278 604452 605667 605916 613041 620406 621958 622309 622562 626599 627320 631823 634045 634489 634848 635391 636230 642121 646656 648057 649357 653120 653853 662807 666966 668015 670315 671456 672285 672678 678691 690265 691225 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in bed"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс постел"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.73%) |
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.