Query Metrics
7
Database Queries
7
Different statements
247.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.70 ms (87.46%) |
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 361993 390994 395406 396562 400459 400662 400912 400946 404368 405045 405182 406290 408439 409921 418534 421107 426085 429763 437526 445941 451565 457963 470631 500431 518467 521927 522792 527792 548265 549261 550347 557938 572736 576019 576355 587037 590958 595759 597236 597243 597254 597257 597271 597793 598939 600175 600329 601609 603164 603891 606816 625736 629330 630493 630755 632586 632638 632658 632660 632698 634154 634211 634786 634791 635210 635225 635277 636108 636593 636991 637089 637096 637120 637431 639257 639335 639792 639797 640083 641413 644910 644940 644982 648862 651489 651620 651669 665918 679420 679761 679775 679808 680150 680153 680188 681005 696214 704226 712797 720825 733838 733843 733849 733863 733883 735057 746995 748950 752155 758979 771820 771845 775752 775790 775962 775985 780530 788115 788257 811606 ] |
||||||||||||||||||||||||||||||
|
20.88 ms (8.43%) |
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 648862 651489 651620 651669 665918 679420 679761 679775 679808 680150 680153 680188 681005 696214 704226 720825 548265 549261 550347 572736 576355 595759 597254 625736 632638 632698 634154 635225 637431 639335 639792 590958 597243 597257 597271 598939 600329 601609 603891 630755 632658 636108 636991 637089 637096 637120 600175 606816 630493 632660 636593 639797 587037 597236 597793 603164 632586 635210 635277 639257 641413 775752 775985 780530 788115 775790 775962 811606 733849 733883 733838 735057 746995 758979 733863 748950 733843 752155 771820 771845 629330 634211 634786 634791 640083 712797 788257 400912 408439 421107 400459 405045 445941 395406 396562 405182 406290 426085 361993 451565 470631 500431 522792 527792 521927 576019 557938 457963 518467 390994 400662 400946 404368 437526 409921 418534 429763 644940 644910 644982 ] |
||||||||||||||||||||||||||||||
|
2.80 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 361993 390994 395406 396562 400459 400662 400912 400946 404368 405045 405182 406290 408439 409921 418534 421107 426085 429763 437526 445941 451565 457963 470631 500431 518467 521927 522792 527792 548265 549261 550347 557938 572736 576019 576355 587037 590958 595759 597236 597243 597254 597257 597271 597793 598939 600175 600329 601609 603164 603891 606816 625736 629330 630493 630755 632586 632638 632658 632660 632698 634154 634211 634786 634791 635210 635225 635277 636108 636593 636991 637089 637096 637120 637431 639257 639335 639792 639797 640083 641413 644910 644940 644982 648862 651489 651620 651669 665918 679420 679761 679775 679808 680150 680153 680188 681005 696214 704226 712797 720825 733838 733843 733849 733863 733883 735057 746995 748950 752155 758979 771820 771845 775752 775790 775962 775985 780530 788115 788257 811606 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang teens"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang teens"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang teens"
]
|
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.