Query Metrics
7
Database Queries
7
Different statements
156.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.02 ms (79.34%) |
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 6670 385948 388976 392449 395233 395756 396181 396307 401282 401655 401998 404753 414516 415145 418049 418495 419407 422604 422631 423007 423025 423039 423263 423401 426041 428523 429086 445269 447103 461737 463262 463962 463963 468584 474626 495792 506522 508000 508096 515178 521454 533747 533783 541324 545602 550327 561316 562872 564066 565256 575458 575788 575810 583397 592310 594173 597999 600016 603970 608425 614065 619367 622392 623196 626389 632969 633811 645004 646245 647333 649163 650158 651190 653496 665238 665681 665698 666875 670250 681319 684543 686047 687370 699586 702866 704235 704841 706269 720063 720392 720823 720840 722809 723580 733844 747387 747650 747687 748950 750143 760914 760957 775788 787936 788570 788794 796970 800282 800331 806277 807557 810848 811606 811938 814119 814223 814265 815002 820775 825522 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (9.03%) |
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 747387 750143 787936 800282 388976 806277 565256 623196 533747 545602 666875 704235 647333 650158 447103 575810 392449 401655 404753 418049 422631 423007 423039 428523 419407 429086 415145 426041 445269 423025 814223 815002 825522 723580 645004 814119 814265 820775 463963 533783 495792 521454 506522 508000 508096 515178 541324 575458 575788 583397 561316 562872 649163 665681 670250 681319 684543 687370 699586 706269 720063 646245 653496 665238 665698 686047 704841 720392 720823 720840 722809 651190 550327 564066 597999 603970 619367 592310 614065 633811 608425 594173 600016 775788 807557 788794 796970 811938 760914 800331 810848 811606 733844 747650 747687 760957 748950 622392 626389 632969 702866 788570 396181 401998 423263 423401 463262 6670 395756 422604 463962 468584 474626 385948 414516 418495 461737 395233 396307 401282 ] |
||||||||||||||||||||||||||||||
|
10.94 ms (7.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.68%) |
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 6670 385948 388976 392449 395233 395756 396181 396307 401282 401655 401998 404753 414516 415145 418049 418495 419407 422604 422631 423007 423025 423039 423263 423401 426041 428523 429086 445269 447103 461737 463262 463962 463963 468584 474626 495792 506522 508000 508096 515178 521454 533747 533783 541324 545602 550327 561316 562872 564066 565256 575458 575788 575810 583397 592310 594173 597999 600016 603970 608425 614065 619367 622392 623196 626389 632969 633811 645004 646245 647333 649163 650158 651190 653496 665238 665681 665698 666875 670250 681319 684543 686047 687370 699586 702866 704235 704841 706269 720063 720392 720823 720840 722809 723580 733844 747387 747650 747687 748950 750143 760914 760957 775788 787936 788570 788794 796970 800282 800331 806277 807557 810848 811606 811938 814119 814223 814265 815002 820775 825522 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small teen"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая teen"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая teen"
]
|
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.