Query Metrics
7
Database Queries
7
Different statements
248.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.58 ms (90.20%) |
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 381952 389994 390139 390257 390947 391597 391667 391767 391983 392021 392025 401374 411402 421828 422201 424114 426821 427001 429953 432545 433640 434242 437369 443135 444132 445288 447716 450285 451525 455118 455128 455202 457359 458190 460408 460425 462522 462580 465133 466899 472392 475097 476494 477933 477937 478382 479604 480851 485383 485971 489172 489225 490383 491124 492967 492991 494594 495520 495573 495814 496019 498158 507081 509044 509651 514015 514028 517696 522334 525695 533679 543689 548010 558178 558324 565302 565303 576208 576915 586199 590539 623385 630112 642237 642249 685509 728489 730936 731018 733232 741710 741751 742056 742386 742407 742412 743719 744101 746118 749617 749620 751513 758206 766288 768896 778492 778521 789748 792607 794878 796563 796836 797351 800736 800742 803433 807837 819401 824528 824735 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (5.82%) |
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 744101 746118 749617 749620 766288 768896 630112 778521 789748 792607 794878 796836 797351 800736 800742 803433 392025 429953 457359 458190 476494 433640 466899 390947 391983 392021 477937 390257 455118 450285 472392 509651 489172 507081 495814 728489 485971 525695 514028 558178 445288 391667 443135 533679 543689 741710 742386 623385 460425 391767 492991 565302 444132 558324 778492 437369 489225 475097 496019 495520 548010 391597 432545 479604 421828 427001 460408 401374 411402 422201 462522 477933 389994 426821 434242 455202 491124 492967 494594 498158 390139 462580 796563 733232 742056 522334 565303 642237 741751 807837 730936 742412 742407 642249 381952 819401 824528 824735 455128 485383 576208 743719 758206 478382 480851 451525 509044 514015 495573 590539 424114 685509 576915 586199 731018 751513 447716 465133 517696 490383 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.03%) |
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 381952 389994 390139 390257 390947 391597 391667 391767 391983 392021 392025 401374 411402 421828 422201 424114 426821 427001 429953 432545 433640 434242 437369 443135 444132 445288 447716 450285 451525 455118 455128 455202 457359 458190 460408 460425 462522 462580 465133 466899 472392 475097 476494 477933 477937 478382 479604 480851 485383 485971 489172 489225 490383 491124 492967 492991 494594 495520 495573 495814 496019 498158 507081 509044 509651 514015 514028 517696 522334 525695 533679 543689 548010 558178 558324 565302 565303 576208 576915 586199 590539 623385 630112 642237 642249 685509 728489 730936 731018 733232 741710 741751 742056 742386 742407 742412 743719 744101 746118 749617 749620 751513 758206 766288 768896 778492 778521 789748 792607 794878 796563 796836 797351 800736 800742 803433 807837 819401 824528 824735 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian chubby wife"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск chubby жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск chubby жен"
]
|
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.