Query Metrics
7
Database Queries
7
Different statements
179.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.72 ms (82.52%) |
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 388366 390173 396970 398613 399889 406081 414026 415450 416795 445332 458614 464355 467978 468515 478839 482172 484542 490589 494269 496280 496284 496294 496296 496305 496311 513805 517652 521826 524868 526560 528051 531791 532372 534257 534287 542519 549400 554759 556585 562350 565335 580500 580758 584693 586672 586677 589146 589234 589654 591701 592210 593444 593497 594077 595722 597849 601006 601905 605058 606873 608444 609993 610292 612348 618965 630460 636599 638550 641109 644453 649381 650915 651084 664368 667742 667842 670276 672622 682076 693956 714089 714654 715853 716112 720815 732754 738674 740903 775662 787608 792637 792819 792884 795522 796237 799616 799619 800016 800959 801064 801850 802458 805164 806103 808262 810233 814834 814848 815154 815226 815429 815555 815829 815831 815880 818470 821312 821656 822093 824405 ] |
||||||||||||||||||||||||||||||
|
21.38 ms (11.95%) |
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 649381 714089 714654 720815 682076 609993 593444 630460 636599 594077 618965 641109 589654 610292 805164 775662 792819 795522 806103 740903 787608 796237 799616 800016 801850 808262 810233 732754 738674 644453 792637 799619 800959 801064 415450 396970 398613 406081 490589 478839 484542 458614 542519 605058 494269 612348 517652 388366 390173 399889 414026 416795 445332 822093 814834 814848 815429 815555 815829 815831 815154 815226 815880 818470 821312 821656 824405 467978 482172 464355 496284 496294 496296 513805 521826 528051 534287 496305 524868 531791 526560 532372 496280 496311 534257 468515 556585 565335 549400 554759 562350 584693 580758 693956 650915 672622 715853 716112 651084 664368 667742 667842 670276 580500 608444 586672 591701 595722 601905 589146 589234 592210 593497 601006 586677 597849 606873 638550 792884 802458 ] |
||||||||||||||||||||||||||||||
|
3.07 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 388366 390173 396970 398613 399889 406081 414026 415450 416795 445332 458614 464355 467978 468515 478839 482172 484542 490589 494269 496280 496284 496294 496296 496305 496311 513805 517652 521826 524868 526560 528051 531791 532372 534257 534287 542519 549400 554759 556585 562350 565335 580500 580758 584693 586672 586677 589146 589234 589654 591701 592210 593444 593497 594077 595722 597849 601006 601905 605058 606873 608444 609993 610292 612348 618965 630460 636599 638550 641109 644453 649381 650915 651084 664368 667742 667842 670276 672622 682076 693956 714089 714654 715853 716112 720815 732754 738674 740903 775662 787608 792637 792819 792884 795522 796237 799616 799619 800016 800959 801064 801850 802458 805164 806103 808262 810233 814834 814848 815154 815226 815429 815555 815829 815831 815880 818470 821312 821656 822093 824405 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony boobs"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая boobs"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чернокожая boobs"
]
|
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.