Query Metrics
7
Database Queries
7
Different statements
206.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.46 ms (88.88%) |
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 382361 464648 494254 511407 519717 524291 532639 541199 547570 547748 554990 556825 561347 563310 563628 565070 571195 572745 579769 587151 587787 589894 592874 596011 599813 600223 601553 603383 604118 605137 605233 629788 633066 633456 633836 637318 641940 642326 644187 645366 651132 664660 664991 665076 668948 669896 669899 678780 692701 698437 708614 708678 709416 710360 713117 713442 714377 714387 714408 714763 715412 715413 715419 718359 718775 718950 720464 721774 725562 733357 736994 738244 740169 744174 744688 744980 746573 751482 752777 752955 754993 755322 760714 765852 766349 769348 769886 769988 772166 774727 776818 777713 778387 781326 781764 783290 790740 793194 799630 803764 805551 805571 806535 810480 810892 811887 814179 816515 816718 816732 817885 819052 819223 819242 819253 821359 821377 822969 825773 826508 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (6.58%) |
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 769348 769886 769988 733357 744980 754993 755322 760714 738244 740169 744174 744688 725562 736994 751482 752777 752955 633066 633456 715412 715419 718775 720464 721774 790740 793194 803764 805551 805571 810480 765852 561347 669899 604118 781326 772166 524291 664660 592874 511407 382361 541199 709416 710360 713117 644187 629788 641940 776818 783290 811887 810892 746573 766349 774727 777713 778387 799630 806535 494254 601553 547570 547748 819223 781764 519717 817885 819242 819253 826508 816732 819052 821359 821377 814179 822969 825773 816515 816718 464648 532639 563310 565070 563628 572745 579769 664991 665076 708614 714377 714387 714408 714763 718359 668948 692701 698437 713442 715413 718950 645366 651132 669896 678780 708678 554990 556825 571195 587151 603383 633836 642326 587787 589894 600223 605233 637318 596011 599813 605137 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.18%) |
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 382361 464648 494254 511407 519717 524291 532639 541199 547570 547748 554990 556825 561347 563310 563628 565070 571195 572745 579769 587151 587787 589894 592874 596011 599813 600223 601553 603383 604118 605137 605233 629788 633066 633456 633836 637318 641940 642326 644187 645366 651132 664660 664991 665076 668948 669896 669899 678780 692701 698437 708614 708678 709416 710360 713117 713442 714377 714387 714408 714763 715412 715413 715419 718359 718775 718950 720464 721774 725562 733357 736994 738244 740169 744174 744688 744980 746573 751482 752777 752955 754993 755322 760714 765852 766349 769348 769886 769988 772166 774727 776818 777713 778387 781326 781764 783290 790740 793194 799630 803764 805551 805571 806535 810480 810892 811887 814179 816515 816718 816732 817885 819052 819223 819242 819253 821359 821377 822969 825773 826508 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom solo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom соло мастурбац"
]
|
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.