Query Metrics
7
Database Queries
7
Different statements
156.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.93 ms (81.33%) |
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 27593 107102 384796 440830 440892 456682 464627 507490 514032 514362 533058 535102 550438 560889 570170 575014 594771 603546 610065 610619 634474 637901 639986 641435 693926 697172 702378 707412 712308 712638 719146 719939 721178 722465 727475 728178 729013 729262 729649 733217 733329 733615 734342 734399 734848 735385 740119 741503 742918 744142 744832 746433 746546 750729 751245 753182 761940 767519 777791 779327 781780 782762 782773 788711 793676 793713 793824 794500 795004 795070 795236 795950 796076 796466 796589 800449 803080 804424 804950 807393 812116 816778 816997 817100 817104 817177 817474 817563 817707 817800 818197 818252 818482 819054 819143 819297 819957 820014 820022 820141 820157 823272 823289 823539 823551 824642 824773 824803 824953 825290 825991 826059 826561 826620 826980 827271 827522 827711 828228 828636 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (11.42%) |
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 440830 464627 533058 514032 697172 610619 634474 781780 793824 107102 440892 817707 823539 824803 826059 826561 819957 820022 826980 816778 819297 825991 818197 823551 828228 535102 514362 702378 707412 712638 722465 560889 594771 610065 782762 793713 796466 782773 812116 741503 744832 746433 795004 795236 795950 807393 729013 734399 744142 729262 735385 727475 746546 767519 733615 740119 637901 795070 796589 804950 27593 818252 816997 819143 828636 804424 793676 751245 641435 803080 796076 729649 693926 734342 750729 733217 603546 384796 817177 817563 818482 819054 824773 823289 719939 712308 719146 639986 777791 779327 742918 753182 788711 794500 800449 728178 734848 733329 761940 721178 820141 820157 826620 817100 817104 820014 825290 827271 827711 817474 817800 823272 824953 824642 827522 456682 507490 570170 575014 550438 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (2.63%) |
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 27593 107102 384796 440830 440892 456682 464627 507490 514032 514362 533058 535102 550438 560889 570170 575014 594771 603546 610065 610619 634474 637901 639986 641435 693926 697172 702378 707412 712308 712638 719146 719939 721178 722465 727475 728178 729013 729262 729649 733217 733329 733615 734342 734399 734848 735385 740119 741503 742918 744142 744832 746433 746546 750729 751245 753182 761940 767519 777791 779327 781780 782762 782773 788711 793676 793713 793824 794500 795004 795070 795236 795950 796076 796466 796589 800449 803080 804424 804950 807393 812116 816778 816997 817100 817104 817177 817474 817563 817707 817800 818197 818252 818482 819054 819143 819297 819957 820014 820022 820141 820157 823272 823289 823539 823551 824642 824773 824803 824953 825290 825991 826059 826561 826620 826980 827271 827522 827711 828228 828636 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf pussy"
]
|
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.