Query Metrics
7
Database Queries
7
Different statements
146.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.27 ms (82.65%) |
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 427084 439695 459734 461461 461820 462331 462537 476520 483126 484227 495565 502657 504524 512148 522991 523598 527537 527610 527989 533435 535399 548825 555726 559581 561243 562821 564098 566260 567164 567251 575853 576560 577654 578435 578547 578587 579881 580326 585227 586248 601419 605002 613785 615443 616637 616858 618926 619384 638903 641521 650369 655485 671350 696374 703648 708923 723040 732016 732786 735511 738268 744682 748359 753927 756072 756518 758065 763748 764790 765001 765195 766887 766959 769359 769702 776310 777143 777498 777589 777691 778008 779084 781029 781348 781626 782089 782486 782659 784434 787964 788100 789307 789478 790819 791017 791317 791556 791574 791689 791942 792355 793026 793931 793979 796179 797678 800466 803211 804301 806263 807661 808695 817879 819764 821669 823670 825865 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (9.78%) |
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 461820 462331 427084 461461 462537 439695 522991 523598 735511 777498 821669 819764 823670 825865 527610 533435 527537 535399 562821 548825 555726 564098 567164 671350 696374 703648 650369 723040 655485 577654 641521 613785 585227 601419 616637 616858 780457 788100 790819 791556 792355 793931 793979 797678 803211 777589 777691 778008 779084 781348 791017 804301 753927 766959 769359 784434 789478 791317 791574 800466 806263 807661 732016 748359 764790 765001 765195 766887 738268 756518 769702 744682 758065 763748 768119 620715 638903 777143 781029 781626 782486 787964 789307 791689 791942 793026 796179 808695 619384 566260 618926 459734 476520 527989 575853 559581 580326 578587 579881 615443 502657 483126 484227 495565 512148 504524 578435 561243 708923 567251 576560 578547 586248 605002 782089 776310 732786 756072 782659 817879 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.16%) |
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 427084 439695 459734 461461 461820 462331 462537 476520 483126 484227 495565 502657 504524 512148 522991 523598 527537 527610 527989 533435 535399 548825 555726 559581 561243 562821 564098 566260 567164 567251 575853 576560 577654 578435 578547 578587 579881 580326 585227 586248 601419 605002 613785 615443 616637 616858 618926 619384 638903 641521 650369 655485 671350 696374 703648 708923 723040 732016 732786 735511 738268 744682 748359 753927 756072 756518 758065 763748 764790 765001 765195 766887 766959 769359 769702 776310 777143 777498 777589 777691 778008 779084 781029 781348 781626 782089 782486 782659 784434 787964 788100 789307 789478 790819 791017 791317 791556 791574 791689 791942 792355 793026 793931 793979 796179 797678 800466 803211 804301 806263 807661 808695 817879 819764 821669 823670 825865 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pigtails pov"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"косичк пов"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.07%) |
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.