Query Metrics
7
Database Queries
7
Different statements
214.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.42 ms (89.17%) |
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 198365 382642 399908 401352 434962 435596 435603 435614 435625 435632 438506 438641 445227 454086 461658 466485 468252 473724 486141 489131 494460 500032 500304 502752 505601 508899 512415 514226 515443 515570 535359 546057 548634 551589 555560 563365 577517 577802 589927 595625 617596 621496 644024 649437 657788 663195 667931 671558 689849 698156 703011 706057 708223 708748 709542 709983 716081 722328 731119 735958 739140 740636 745715 747427 747433 748509 749830 750364 750626 750662 750764 751294 752773 752780 754986 755510 756144 756538 757216 765479 768244 769371 772632 777677 777829 782528 782855 783342 784001 784048 784409 784513 784647 785170 785250 785606 786088 790924 791024 791450 791500 791597 792441 795362 796388 796402 801780 801841 803384 809150 809606 810180 813582 813598 814189 814202 824733 825131 827185 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (6.28%) |
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 748509 756144 740636 750764 755510 757216 749830 752773 756538 769371 731119 735958 747427 750364 751294 752780 768244 703011 722328 777829 782528 783342 784647 785170 791024 791597 795362 796388 796402 801780 809606 803384 792441 784409 502752 785606 790924 772632 198365 435632 813582 814202 454086 505601 508899 577517 546057 551589 555560 708223 698156 706057 649437 671558 689849 716081 644024 589927 604910 617596 791450 801841 785250 809150 810180 750626 784048 739140 745715 747433 754986 784001 468252 399908 466485 382642 401352 438506 438641 515570 515443 489131 435625 813598 473724 461658 563365 577802 709542 663195 708748 595625 782855 791500 784513 786088 750662 709983 435614 486141 765479 657788 548634 621496 777677 667931 435603 435596 445227 434962 814189 827185 824733 825131 535359 494460 514226 500032 512415 500304 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.13%) |
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 198365 382642 399908 401352 434962 435596 435603 435614 435625 435632 438506 438641 445227 454086 461658 466485 468252 473724 486141 489131 494460 500032 500304 502752 505601 508899 512415 514226 515443 515570 535359 546057 548634 551589 555560 563365 577517 577802 589927 595625 617596 621496 644024 649437 657788 663195 667931 671558 689849 698156 703011 706057 708223 708748 709542 709983 716081 722328 731119 735958 739140 740636 745715 747427 747433 748509 749830 750364 750626 750662 750764 751294 752773 752780 754986 755510 756144 756538 757216 765479 768244 769371 772632 777677 777829 782528 782855 783342 784001 784048 784409 784513 784647 785170 785250 785606 786088 790924 791024 791450 791500 791597 792441 795362 796388 796402 801780 801841 803384 809150 809606 810180 813582 813598 814189 814202 824733 825131 827185 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation solo orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац соло orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац соло orgasm"
]
|
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.