Query Metrics
7
Database Queries
7
Different statements
389.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.77 ms (53.55%) |
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 382410 401810 413404 414087 420116 437708 439417 452830 456699 457815 471929 475415 475417 477503 479722 479838 481226 483522 494302 495208 499922 515423 522148 522173 526902 542163 549538 566544 570911 585783 600205 603391 606493 631301 631325 631331 633455 634109 651863 660578 662856 663158 669589 681804 692688 697834 697839 700682 700693 716001 734832 738460 738490 738515 739139 739155 740929 741157 742421 750623 752603 752711 755328 758861 760471 762561 766294 766939 770258 772235 774842 774874 776994 776997 777005 777921 777924 779718 779749 780019 780025 780038 780039 780067 782419 782855 782891 782894 782896 783212 783214 783319 783733 785267 786023 787095 787505 789803 790506 791797 796687 796993 800532 800792 803751 804939 805643 806144 806393 806413 806466 806584 806687 806834 807142 807581 807604 808968 808994 813219 ] |
||||||||||||||||||||||||||||||
|
156.78 ms (40.22%) |
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 382410 401810 413404 414087 420116 437708 439417 452830 456699 457815 471929 475415 475417 477503 479722 479838 481226 483522 494302 495208 499922 515423 522148 522173 526902 542163 549538 566544 570911 585783 600205 603391 606493 631301 631325 631331 633455 634109 651863 660578 662856 663158 669589 681804 692688 697834 697839 700682 700693 716001 734832 738460 738490 738515 739139 739155 740929 741157 742421 750623 752603 752711 755328 758861 760471 762561 766294 766939 770258 772235 774842 774874 776994 776997 777005 777921 777924 779718 779749 780019 780025 780038 780039 780067 782419 782855 782891 782894 782896 783212 783214 783319 783733 785267 786023 787095 787505 789803 790506 791797 796687 796993 800532 800792 803751 804939 805643 806144 806393 806413 806466 806584 806687 806834 807142 807581 807604 808968 808994 813219 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (4.17%) |
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 808968 758861 787505 789803 791797 796687 800532 804939 806687 807604 808994 770258 738515 755328 776994 779749 780025 783733 796993 803751 807581 813219 382410 401810 413404 456699 457815 479722 515423 522148 495208 542163 651863 662856 716001 697834 585783 603391 631331 774842 779718 782855 787095 806466 780019 780038 783214 785267 752603 762561 782419 782894 783212 783319 790506 766939 738490 760471 740929 741157 742421 750623 766294 631301 800792 805643 477503 414087 475417 439417 479838 452830 483522 522173 499922 526902 475415 566544 570911 549538 663158 697839 660578 692688 700693 669589 681804 700682 606493 633455 634109 600205 777924 780039 782896 806144 806393 806584 807142 738460 772235 782891 786023 806413 752711 739139 734832 739155 631325 774874 776997 777005 777921 780067 806834 420116 437708 471929 481226 494302 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex machine teens"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сексмашин teens"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин teens"
]
|
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.