Query Metrics
7
Database Queries
7
Different statements
345.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
313.17 ms (90.54%) |
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 418083 425415 427379 428083 429358 441956 449039 449643 459783 460379 461393 461485 461976 462297 462706 463142 465617 466679 466984 467131 469216 469840 470667 471574 473557 474099 475490 475603 480240 480814 480927 481237 482923 482927 483654 484150 484346 486846 487020 487612 488194 488214 488512 488588 488716 488750 489789 491909 492180 492677 494106 494175 494193 495157 495685 496056 498164 502678 503943 504246 504274 504328 504904 506054 506488 506520 507130 508588 508592 509192 510100 510111 511118 511218 514609 517277 519101 519176 520117 520610 520631 521963 522326 524169 524170 531069 559035 559659 562809 563022 566747 567485 567782 571036 574176 578077 582592 582724 588605 591898 592210 601952 603908 611767 612030 618234 618750 622826 623831 625121 680906 694380 694387 705118 725442 731080 734364 771891 779624 798936 ] |
||||||||||||||||||||||||||||||
|
23.24 ms (6.72%) |
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 506488 506520 511218 495157 504904 507130 463142 466679 474099 480927 488750 491909 559035 566747 582724 559659 574176 562809 567782 694380 680906 694387 563022 567485 571036 578077 582592 588605 622826 601952 591898 592210 603908 611767 625121 618234 623831 725442 731080 734364 771891 612030 618750 705118 779624 798936 429358 461393 462297 462706 470667 475490 480814 418083 460379 461976 465617 466984 467131 469216 471574 425415 427379 428083 441956 459783 461485 480240 481237 449039 449643 469840 475603 473557 503943 517277 522326 524169 482923 484150 486846 488194 488512 494175 504274 504328 506054 508588 510111 520610 521963 524170 487020 487612 488716 489789 492180 496056 509192 514609 519101 520117 520631 531069 482927 483654 484346 488214 488588 492677 494106 494193 495685 498164 502678 504246 508592 510100 511118 519176 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (0.89%) |
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 418083 425415 427379 428083 429358 441956 449039 449643 459783 460379 461393 461485 461976 462297 462706 463142 465617 466679 466984 467131 469216 469840 470667 471574 473557 474099 475490 475603 480240 480814 480927 481237 482923 482927 483654 484150 484346 486846 487020 487612 488194 488214 488512 488588 488716 488750 489789 491909 492180 492677 494106 494175 494193 495157 495685 496056 498164 502678 503943 504246 504274 504328 504904 506054 506488 506520 507130 508588 508592 509192 510100 510111 511118 511218 514609 517277 519101 519176 520117 520610 520631 521963 522326 524169 524170 531069 559035 559659 562809 563022 566747 567485 567782 571036 574176 578077 582592 582724 588605 591898 592210 601952 603908 611767 612030 618234 618750 622826 623831 625121 680906 694380 694387 705118 725442 731080 734364 771891 779624 798936 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт парен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden boy"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.