Query Metrics
7
Database Queries
7
Different statements
381.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.01 ms (55.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс new"
]
|
||||||||||||||||||||||||||||||
|
150.55 ms (39.46%) |
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 382609 382853 390554 406281 412725 414254 441499 456096 472197 496332 505729 507861 512182 516699 521290 530687 534751 534919 536245 537243 539260 540087 545042 554340 558889 564322 568632 576889 577919 582670 582705 583346 585106 585263 587566 593693 595544 596584 600881 605976 606893 626235 628703 630017 649139 650663 655493 667339 677133 683802 684196 684683 687071 694052 698015 708055 710204 710479 713652 714650 714954 715391 716365 720798 723702 724820 727637 734799 735150 741316 742837 743831 752897 753753 756261 758012 758310 758403 758684 759755 765438 767868 767962 768255 769809 775783 778137 778973 780047 780798 780802 785070 785828 790761 791517 791852 791856 792065 793123 793976 797379 797399 797455 799650 801523 802293 802486 802879 804902 805704 807320 807366 809561 811951 814528 815291 815397 815768 815976 817019 ] |
||||||||||||||||||||||||||||||
|
11.39 ms (2.98%) |
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 382853 414254 815976 582670 382609 815768 684196 797379 797399 742837 406281 585106 815397 507861 677133 564322 582705 802486 807320 752897 758684 626235 630017 780802 785070 456096 521290 534919 534751 472197 687071 577919 605976 596584 593693 595544 600881 791517 791852 792065 765438 805704 809561 734799 802879 814528 516699 655493 710204 708055 715391 628703 780798 758310 802293 741316 724820 778973 390554 649139 775783 441499 815291 496332 540087 530687 545042 558889 583346 576889 554340 650663 684683 694052 716365 667339 698015 714954 568632 587566 606893 799650 807366 791856 801523 727637 793123 804902 743831 756261 723702 758403 758012 759755 735150 753753 710479 713652 714650 785828 793976 797455 811951 683802 412725 536245 585263 790761 767868 817019 505729 512182 720798 778137 780047 767962 768255 769809 537243 539260 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.73%) |
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 382609 382853 390554 406281 412725 414254 441499 456096 472197 496332 505729 507861 512182 516699 521290 530687 534751 534919 536245 537243 539260 540087 545042 554340 558889 564322 568632 576889 577919 582670 582705 583346 585106 585263 587566 593693 595544 596584 600881 605976 606893 626235 628703 630017 649139 650663 655493 667339 677133 683802 684196 684683 687071 694052 698015 708055 710204 710479 713652 714650 714954 715391 716365 720798 723702 724820 727637 734799 735150 741316 742837 743831 752897 753753 756261 758012 758310 758403 758684 759755 765438 767868 767962 768255 769809 775783 778137 778973 780047 780798 780802 785070 785828 790761 791517 791852 791856 792065 793123 793976 797379 797399 797455 799650 801523 802293 802486 802879 804902 805704 807320 807366 809561 811951 814528 815291 815397 815768 815976 817019 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex new"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс new"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.