Query Metrics
7
Database Queries
7
Different statements
187.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.42 ms (86.48%) |
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 84510 211045 298519 327523 335919 383137 383267 383487 383509 396958 397633 397963 398787 399965 401948 403392 410129 410748 414173 416866 417932 418563 419612 422267 427907 433740 440917 442421 442469 445864 452195 452240 454397 465727 467005 468368 473502 484296 492963 503486 513145 514015 520701 523599 525829 526494 530042 530122 530858 531373 531548 531568 536346 539660 543152 553301 554930 554986 575297 616229 616675 617782 627147 629975 639558 642241 662876 671219 695379 709623 715573 717379 721922 734822 735882 735889 736188 740239 742104 744358 744466 749561 755065 756391 757287 769467 769481 769494 769539 770073 789215 794861 795966 796898 797241 801500 801554 804411 804413 804586 808544 808656 809234 809555 810731 814100 817980 818802 823739 824690 825164 825947 826283 826284 826480 826712 828037 828039 828254 828712 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (7.68%) |
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 410748 467005 84510 416866 814100 818802 817980 531568 804411 809234 742104 795966 801554 734822 735889 808544 769467 399965 442421 418563 627147 797241 396958 484296 671219 445864 398787 383267 397633 823739 826283 825164 826284 825947 826712 828037 828254 828039 828712 530122 530858 539660 530042 543152 575297 695379 717379 721922 617782 616675 642241 804586 808656 810731 809555 736188 749561 756391 740239 770073 744358 755065 735882 769481 769539 616229 629975 796898 801500 335919 452195 503486 662876 468368 383137 757287 794861 298519 419612 492963 454397 520701 526494 410129 433740 383487 327523 397963 401948 414173 824690 452240 525829 536346 513145 639558 744466 211045 514015 383509 554986 826480 473502 531373 531548 553301 709623 715573 789215 769494 804413 554930 403392 417932 422267 440917 427907 442469 465727 523599 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.71%) |
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 84510 211045 298519 327523 335919 383137 383267 383487 383509 396958 397633 397963 398787 399965 401948 403392 410129 410748 414173 416866 417932 418563 419612 422267 427907 433740 440917 442421 442469 445864 452195 452240 454397 465727 467005 468368 473502 484296 492963 503486 513145 514015 520701 523599 525829 526494 530042 530122 530858 531373 531548 531568 536346 539660 543152 553301 554930 554986 575297 616229 616675 617782 627147 629975 639558 642241 662876 671219 695379 709623 715573 717379 721922 734822 735882 735889 736188 740239 742104 744358 744466 749561 755065 756391 757287 769467 769481 769494 769539 770073 789215 794861 795966 796898 797241 801500 801554 804411 804413 804586 808544 808656 809234 809555 810731 814100 817980 818802 823739 824690 825164 825947 826283 826284 826480 826712 828037 828039 828254 828712 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby panties"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
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.