Query Metrics
7
Database Queries
7
Different statements
203.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.30 ms (88.10%) |
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 15129 25053 46052 47613 47689 47854 85792 117221 123010 123147 123921 129916 130089 195513 308783 321806 332249 382381 383103 383348 387990 388366 388886 389318 392760 395754 396368 396581 396595 397302 399090 400947 403633 404384 406881 409725 409879 409893 410163 411291 411953 416093 416863 422331 425958 428786 451527 454122 454289 470598 489245 490834 533351 534926 536210 542579 543867 583995 595717 603151 606700 610847 617432 628375 644296 651126 671740 675200 677098 679441 681305 684126 686073 688351 704547 706836 708421 715507 717724 718521 719335 720308 721538 726744 728899 742214 743117 747090 754174 756219 767281 775068 775787 775916 775934 775981 792007 792356 801927 804914 806449 810823 814893 816568 817351 817446 818297 818367 818475 819272 819320 819547 820331 820678 820774 820780 822212 822696 823501 823920 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (7.50%) |
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 129916 388366 756219 389318 416093 820780 675200 681305 721538 606700 416863 308783 85792 403633 409725 470598 489245 806449 46052 822696 409893 533351 490834 543867 628375 392760 819547 651126 583995 603151 792356 123921 123147 822212 818367 717724 671740 679441 715507 595717 775934 743117 754174 644296 47854 454289 123010 823920 818297 819320 820331 823501 686073 706836 718521 688351 704547 610847 775068 775916 767281 726744 383348 383103 542579 804914 321806 677098 684126 742214 47613 382381 396368 195513 395754 25053 15129 117221 388886 396595 396581 400947 404384 406881 411291 410163 422331 428786 818475 819272 536210 708421 719335 617432 775787 775981 792007 810823 728899 747090 720308 801927 332249 397302 399090 425958 409879 451527 454122 130089 47689 387990 411953 817351 817446 820678 814893 816568 820774 534926 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.36%) |
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 15129 25053 46052 47613 47689 47854 85792 117221 123010 123147 123921 129916 130089 195513 308783 321806 332249 382381 383103 383348 387990 388366 388886 389318 392760 395754 396368 396581 396595 397302 399090 400947 403633 404384 406881 409725 409879 409893 410163 411291 411953 416093 416863 422331 425958 428786 451527 454122 454289 470598 489245 490834 533351 534926 536210 542579 543867 583995 595717 603151 606700 610847 617432 628375 644296 651126 671740 675200 677098 679441 681305 684126 686073 688351 704547 706836 708421 715507 717724 718521 719335 720308 721538 726744 728899 742214 743117 747090 754174 756219 767281 775068 775787 775916 775934 775981 792007 792356 801927 804914 806449 810823 814893 816568 817351 817446 818297 818367 818475 819272 819320 819547 820331 820678 820774 820780 822212 822696 823501 823920 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.66%) |
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.