Query Metrics
7
Database Queries
7
Different statements
142.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.71 ms (81.98%) |
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 73052 382724 386191 387285 390051 392076 394031 395897 396337 398576 400484 402093 402599 403778 412827 418655 418900 418975 427433 429242 432521 458077 459849 462705 464293 469912 480792 483725 492048 492444 495144 505261 508863 531317 532416 534232 536944 536998 540788 542934 555808 556916 560504 567622 569665 570056 574280 587163 587989 589931 591008 592648 593932 603471 605565 606783 614820 616855 617512 619147 619271 620967 623149 626994 630834 639236 639957 647547 647762 648670 657246 659064 663411 663930 663936 665124 665503 668848 669652 672706 674683 683724 685237 688083 694751 696107 707506 713853 718091 742809 744234 745015 781605 781666 788945 790971 792097 796102 796418 796887 799988 800000 801519 802185 803813 804513 807333 809707 814092 814453 817070 818045 820333 823625 823995 824233 824388 826285 827152 827919 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (10.83%) |
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 796102 796418 386191 400484 469912 387285 418900 462705 464293 483725 505261 382724 402093 495144 542934 569665 570056 427433 663936 688083 718091 619271 605565 606783 802185 801519 745015 623149 458077 394031 390051 824233 536944 574280 617512 800000 744234 742809 803813 412827 663930 781605 663411 668848 804513 790971 781666 480792 536998 492048 73052 392076 395897 396337 398576 402599 403778 418655 432521 418975 429242 814092 814453 817070 820333 824388 540788 823625 827152 818045 823995 827919 826285 492444 459849 508863 531317 534232 532416 560504 567622 555808 556916 669652 683724 694751 647762 657246 659064 672706 674683 685237 696107 707506 647547 648670 665124 665503 713853 591008 593932 614820 630834 587163 603471 616855 619147 626994 589931 620967 639236 587989 592648 639957 788945 792097 796887 807333 809707 799988 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.98%) |
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 73052 382724 386191 387285 390051 392076 394031 395897 396337 398576 400484 402093 402599 403778 412827 418655 418900 418975 427433 429242 432521 458077 459849 462705 464293 469912 480792 483725 492048 492444 495144 505261 508863 531317 532416 534232 536944 536998 540788 542934 555808 556916 560504 567622 569665 570056 574280 587163 587989 589931 591008 592648 593932 603471 605565 606783 614820 616855 617512 619147 619271 620967 623149 626994 630834 639236 639957 647547 647762 648670 657246 659064 663411 663930 663936 665124 665503 668848 669652 672706 674683 683724 685237 688083 694751 696107 707506 713853 718091 742809 744234 745015 781605 781666 788945 790971 792097 796102 796418 796887 799988 800000 801519 802185 803813 804513 807333 809707 814092 814453 817070 818045 820333 823625 823995 824233 824388 826285 827152 827919 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old wife"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old жен"
]
|
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.