Query Metrics
7
Database Queries
7
Different statements
152.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.09 ms (82.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 187717 232940 383940 388365 390610 391025 392744 395705 398561 400861 401006 401821 401899 411690 421945 422200 424248 426007 429292 439574 440996 443176 444104 454217 454224 454558 454567 456602 458714 460138 462010 462183 463177 464296 465892 466085 466240 466272 470306 471054 471061 471384 472695 474029 474076 474493 474635 475115 476278 476285 477725 477730 477983 478932 479027 479080 479097 479099 479108 480059 482371 482490 484392 484557 484580 484652 485696 486341 486577 501519 502749 502753 503961 504837 506210 513246 518851 520743 520859 520897 529386 530006 532051 549135 549799 555180 557591 557932 558002 561871 563058 563152 565732 565749 571713 584395 589590 602623 619100 621198 621456 649249 651651 665233 668949 697758 705058 710402 721476 726533 728317 732203 736044 738326 739739 745252 748876 780705 823456 827912 ] |
||||||||||||||||||||||||||||||
|
17.41 ms (11.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 474635 479027 479080 479097 479099 479108 454567 470306 474076 474493 477983 401006 421945 454224 454558 463177 475115 476278 476285 440996 466085 466272 502749 503961 506210 484580 484652 485696 520897 484392 486577 518851 520743 429292 589590 422200 466240 454217 477725 484557 458714 460138 472695 478932 726533 443176 392744 474029 504837 187717 391025 728317 563058 558002 232940 501519 549799 439574 465892 477730 486341 480059 827912 532051 651651 705058 721476 710402 602623 619100 780705 748876 739739 738326 732203 736044 745252 395705 665233 621456 621198 383940 388365 390610 400861 398561 401821 401899 426007 444104 411690 424248 823456 482490 471061 471384 456602 513246 520859 529386 502753 530006 462010 462183 464296 471054 482371 561871 565732 571713 549135 584395 555180 557591 565749 649249 668949 697758 557932 563152 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.78%) |
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 187717 232940 383940 388365 390610 391025 392744 395705 398561 400861 401006 401821 401899 411690 421945 422200 424248 426007 429292 439574 440996 443176 444104 454217 454224 454558 454567 456602 458714 460138 462010 462183 463177 464296 465892 466085 466240 466272 470306 471054 471061 471384 472695 474029 474076 474493 474635 475115 476278 476285 477725 477730 477983 478932 479027 479080 479097 479099 479108 480059 482371 482490 484392 484557 484580 484652 485696 486341 486577 501519 502749 502753 503961 504837 506210 513246 518851 520743 520859 520897 529386 530006 532051 549135 549799 555180 557591 557932 558002 561871 563058 563152 565732 565749 571713 584395 589590 602623 619100 621198 621456 649249 651651 665233 668949 697758 705058 710402 721476 726533 728317 732203 736044 738326 739739 745252 748876 780705 823456 827912 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature wife"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mature жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mature жен"
]
|
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.