Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.47 ms (84.88%) |
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 146855 383482 390255 405367 408465 411313 411914 418894 419013 419739 420159 430988 434861 451107 451703 454785 454983 460130 461519 461552 462597 465118 470943 476316 478353 479837 479865 480214 482467 486837 494698 504441 506492 509618 512816 516168 516196 522236 526299 527230 532980 537927 543369 544708 545052 552136 552303 552796 555647 558959 560248 560464 566403 567411 569539 570603 573780 574476 574589 575467 580275 582634 583821 584872 586397 588323 590406 590553 591383 593915 594570 603969 612512 615315 616602 619955 622665 628901 634826 641096 648762 649571 654026 660404 667054 687937 688423 697004 698030 699482 702299 705780 715553 717131 717631 718962 729731 729821 738058 739479 746318 756918 762930 772017 778471 779194 785109 785564 785876 788373 790795 807636 807855 808242 810887 811729 814887 815440 818198 818815 ] |
||||||||||||||||||||||||||||||
|
12.32 ms (8.54%) |
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 544708 667054 702299 697004 705780 648762 688423 566403 590553 594570 628901 591383 810887 811729 808242 772017 729731 738058 739479 715553 785109 785564 807855 430988 478353 480214 509618 383482 815440 818815 545052 654026 583821 588323 778471 746318 729821 756918 390255 818198 479837 460130 527230 532980 494698 537927 560248 582634 584872 552136 552303 699482 718962 660404 717631 555647 567411 573780 615315 603969 622665 590406 779194 790795 785876 807636 698030 420159 462597 419739 465118 408465 516168 506492 516196 405367 411914 482467 451107 476316 512816 504441 526299 574476 543369 558959 574589 552796 560464 570603 649571 687937 569539 575467 580275 593915 612512 586397 616602 619955 634826 762930 641096 717131 788373 419013 451703 461519 461552 470943 479865 454785 454983 411313 486837 522236 146855 418894 434861 814887 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.63%) |
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 146855 383482 390255 405367 408465 411313 411914 418894 419013 419739 420159 430988 434861 451107 451703 454785 454983 460130 461519 461552 462597 465118 470943 476316 478353 479837 479865 480214 482467 486837 494698 504441 506492 509618 512816 516168 516196 522236 526299 527230 532980 537927 543369 544708 545052 552136 552303 552796 555647 558959 560248 560464 566403 567411 569539 570603 573780 574476 574589 575467 580275 582634 583821 584872 586397 588323 590406 590553 591383 593915 594570 603969 612512 615315 616602 619955 622665 628901 634826 641096 648762 649571 654026 660404 667054 687937 688423 697004 698030 699482 702299 705780 715553 717131 717631 718962 729731 729821 738058 739479 746318 756918 762930 772017 778471 779194 785109 785564 785876 788373 790795 807636 807855 808242 810887 811729 814887 815440 818198 818815 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex new"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс new"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс new"
]
|
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.