Query Metrics
7
Database Queries
7
Different statements
371.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.24 ms (57.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мам женщин"
]
|
||||||||||||||||||||||||||||||
|
126.50 ms (34.05%) |
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 6591 43271 72782 96393 187704 187733 188242 193874 203645 233187 233369 359420 382971 383224 384581 387359 389211 391517 392956 397863 397901 398956 400487 400489 400493 400550 400809 400817 400851 400861 401896 402383 404491 407169 409083 411349 411717 413182 420375 426940 428113 428881 439717 443672 443972 445939 453930 454132 457010 465344 468911 473954 474861 482314 492100 502718 515026 520691 523902 526478 527570 533734 540788 561589 563072 581878 584395 614723 622623 623493 629837 638557 643362 650388 650625 670109 673981 674386 687195 695598 696426 699370 710568 710594 714752 714901 714909 716277 721822 725579 728237 733296 733338 742704 742722 744187 745732 746586 748239 758614 772333 781648 782278 784301 785435 788611 788945 789551 789722 790011 802416 802768 803298 804620 807523 814909 815529 816793 817070 818167 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (4.00%) |
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 382971 411717 474861 389211 72782 383224 814909 817070 540788 815529 818167 445939 527570 695598 670109 673981 674386 687195 716277 650625 629837 643362 788945 790011 802416 807523 745732 758614 772333 785435 802768 804620 746586 725579 744187 699370 714901 788611 789551 803298 187704 398956 473954 233369 359420 402383 443972 443672 384581 816793 533734 561589 581878 714909 650388 721822 714752 728237 733338 742704 742722 614723 623493 710568 781648 789722 203645 193874 391517 515026 392956 782278 622623 784301 233187 6591 400861 404491 428113 428881 457010 482314 584395 563072 696426 710594 638557 733296 748239 96393 400550 400817 400851 409083 188242 397901 400487 401896 468911 187733 387359 400493 400809 407169 426940 453930 43271 400489 411349 413182 420375 454132 439717 465344 492100 520691 523902 526478 502718 397863 ] |
||||||||||||||||||||||||||||||
|
8.86 ms (2.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mother"
]
|
||||||||||||||||||||||||||||||
|
2.76 ms (0.74%) |
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 6591 43271 72782 96393 187704 187733 188242 193874 203645 233187 233369 359420 382971 383224 384581 387359 389211 391517 392956 397863 397901 398956 400487 400489 400493 400550 400809 400817 400851 400861 401896 402383 404491 407169 409083 411349 411717 413182 420375 426940 428113 428881 439717 443672 443972 445939 453930 454132 457010 465344 468911 473954 474861 482314 492100 502718 515026 520691 523902 526478 527570 533734 540788 561589 563072 581878 584395 614723 622623 623493 629837 638557 643362 650388 650625 670109 673981 674386 687195 695598 696426 699370 710568 710594 714752 714901 714909 716277 721822 725579 728237 733296 733338 742704 742722 744187 745732 746586 748239 758614 772333 781648 782278 784301 785435 788611 788945 789551 789722 790011 802416 802768 803298 804620 807523 814909 815529 816793 817070 818167 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.43%) |
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.