Query Metrics
7
Database Queries
7
Different statements
152.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.01 ms (80.89%) |
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 65568 384823 410694 412525 414130 414384 416706 419445 419583 419819 425780 428750 428931 432211 432824 432976 434325 434330 434345 434349 439130 439195 439382 445013 445440 445825 445986 446508 447385 450707 451073 451727 452910 454711 457092 458114 466443 466455 466467 467873 467889 473103 487824 488797 489579 490675 491642 493793 493849 494487 499917 508552 515389 515527 525758 526156 529004 529606 529731 529737 530422 531029 534065 534975 538506 538556 539092 539205 540158 540857 544106 544413 547189 547982 554844 555834 556900 557415 558407 558457 560898 562440 563363 564641 567770 571335 573324 573332 575935 577540 580395 581428 581762 583666 584558 585058 588674 588935 591427 594434 596963 597043 597977 601695 723658 770264 814196 816117 819089 819123 819216 819969 821131 821547 821785 822817 823056 825033 826353 827228 ] |
||||||||||||||||||||||||||||||
|
18.90 ms (12.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 428931 416706 419445 432976 434345 434349 414130 434330 410694 419583 439195 439382 445440 445825 445986 450707 458114 446508 490675 451727 466467 555834 556900 557415 560898 563363 577540 581762 558457 564641 567770 571335 573332 581428 583666 584558 588674 597977 596963 597043 601695 588935 591427 594434 770264 432824 473103 65568 425780 434325 467873 467889 414384 428750 439130 451073 466443 466455 412525 419819 432211 445013 447385 452910 457092 534065 491642 493849 494487 499917 525758 487824 488797 489579 493793 508552 515389 526156 384823 819216 540857 585058 723658 826353 819969 821547 827228 814196 819123 822817 823056 816117 819089 821131 821785 825033 454711 529606 539092 540158 529731 529737 538506 538556 539205 515527 529004 531029 534975 530422 544413 547189 547982 554844 558407 562440 573324 575935 580395 544106 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (2.28%) |
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 65568 384823 410694 412525 414130 414384 416706 419445 419583 419819 425780 428750 428931 432211 432824 432976 434325 434330 434345 434349 439130 439195 439382 445013 445440 445825 445986 446508 447385 450707 451073 451727 452910 454711 457092 458114 466443 466455 466467 467873 467889 473103 487824 488797 489579 490675 491642 493793 493849 494487 499917 508552 515389 515527 525758 526156 529004 529606 529731 529737 530422 531029 534065 534975 538506 538556 539092 539205 540158 540857 544106 544413 547189 547982 554844 555834 556900 557415 558407 558457 560898 562440 563363 564641 567770 571335 573324 573332 575935 577540 580395 581428 581762 583666 584558 585058 588674 588935 591427 594434 596963 597043 597977 601695 723658 770264 814196 816117 819089 819123 819216 819969 821131 821547 821785 822817 823056 825033 826353 827228 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny girl solo"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая соло"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.96%) |
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.