Query Metrics
7
Database Queries
7
Different statements
194.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.69 ms (85.49%) |
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 6739 150487 170836 187203 191487 234584 239495 257966 276441 319863 365989 381987 382272 382421 383065 383326 385653 386083 389680 390169 390545 393105 395955 396656 397923 398539 400195 401209 402960 403054 404341 404777 407339 407595 407867 409114 409942 411368 413068 413768 414057 420151 432723 450305 451998 453131 453750 456915 457435 457891 460187 460908 462949 464961 466213 468120 472232 472628 473194 473740 475873 476280 478039 478510 480305 480470 480759 480760 481466 482140 482627 489127 489388 491790 502495 506768 515372 520665 522140 522364 533190 546255 555100 557171 560138 599909 601536 617638 624874 637481 665878 667320 668161 689359 707519 710498 721463 731785 732243 734699 734726 739938 740159 748299 759145 773346 776745 796920 797634 801277 807635 810234 817776 818966 818984 818999 819006 819015 819019 824172 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (9.03%) |
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 506768 409942 398539 824172 480759 457435 480305 397923 466213 472628 257966 819006 818966 170836 239495 276441 381987 407339 533190 557171 665878 689359 668161 707519 546255 637481 599909 776745 734726 740159 748299 810234 759145 731785 734699 739938 773346 710498 796920 382272 6739 402960 456915 491790 462949 401209 721463 395955 383326 393105 390545 396656 404777 413768 432723 482627 453750 475873 489127 520665 801277 601536 797634 365989 386083 481466 403054 515372 409114 818984 819015 817776 818999 819019 382421 150487 383065 187203 234584 191487 319863 390169 404341 414057 407595 420151 457891 460187 478039 480470 480760 472232 450305 451998 478510 502495 522140 522364 464961 482140 489388 555100 667320 560138 624874 617638 807635 732243 407867 453131 460908 468120 389680 400195 411368 413068 473194 473740 476280 385653 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.54%) |
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 6739 150487 170836 187203 191487 234584 239495 257966 276441 319863 365989 381987 382272 382421 383065 383326 385653 386083 389680 390169 390545 393105 395955 396656 397923 398539 400195 401209 402960 403054 404341 404777 407339 407595 407867 409114 409942 411368 413068 413768 414057 420151 432723 450305 451998 453131 453750 456915 457435 457891 460187 460908 462949 464961 466213 468120 472232 472628 473194 473740 475873 476280 478039 478510 480305 480470 480759 480760 481466 482140 482627 489127 489388 491790 502495 506768 515372 520665 522140 522364 533190 546255 555100 557171 560138 599909 601536 617638 624874 637481 665878 667320 668161 689359 707519 710498 721463 731785 732243 734699 734726 739938 740159 748299 759145 773346 776745 796920 797634 801277 807635 810234 817776 818966 818984 818999 819006 819015 819019 824172 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a mature blonde"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.