Query Metrics
7
Database Queries
7
Different statements
157.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.35 ms (80.12%) |
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 389098 390568 390571 390582 391651 391655 391911 397850 397853 397863 398964 400479 400494 400807 400808 400842 400849 400852 400865 401006 410937 411863 418125 419517 419522 419531 419539 421945 422183 422358 424325 424430 424436 424446 424452 424462 428136 428142 428817 439320 439529 439591 439609 439806 440707 440991 443407 443771 443773 443790 446740 447350 447751 450368 450901 451480 451488 452677 461441 462305 465892 465949 466208 466213 466267 466877 466893 468097 470166 470189 470275 470971 472148 474635 474648 474678 474693 477961 479049 479126 480059 481918 484608 484626 484644 484673 484704 484746 485246 486341 486344 490085 491114 491910 498491 501797 503411 505023 508003 514436 518264 534028 547622 549799 550219 551226 558131 561692 563413 590398 601338 602653 636026 650155 651841 699625 788767 798680 807326 808691 ] |
||||||||||||||||||||||||||||||
|
20.34 ms (12.90%) |
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 547622 561692 651841 590398 808691 422183 424452 447751 466893 390568 390582 440707 451488 470189 470971 397853 418125 477961 400842 466267 428817 450368 465949 468097 490085 484608 391651 411863 443773 400807 472148 479049 400808 424446 439591 452677 474648 419522 505023 439806 397863 391655 400852 474635 397850 470166 470275 443407 422358 439529 424325 465892 481918 440991 443790 474678 484704 486341 391911 563413 550219 601338 400865 419539 424436 428136 400494 400849 424430 428142 466877 401006 419517 421945 439609 451480 461441 508003 518264 498491 446740 558131 484644 486344 503411 534028 551226 390571 466213 400479 480059 514436 484673 474693 443771 466208 462305 450901 479126 501797 484746 650155 699625 636026 602653 798680 807326 788767 424462 398964 389098 439320 447350 410937 419531 484626 491114 491910 485246 549799 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.13%) |
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 389098 390568 390571 390582 391651 391655 391911 397850 397853 397863 398964 400479 400494 400807 400808 400842 400849 400852 400865 401006 410937 411863 418125 419517 419522 419531 419539 421945 422183 422358 424325 424430 424436 424446 424452 424462 428136 428142 428817 439320 439529 439591 439609 439806 440707 440991 443407 443771 443773 443790 446740 447350 447751 450368 450901 451480 451488 452677 461441 462305 465892 465949 466208 466213 466267 466877 466893 468097 470166 470189 470275 470971 472148 474635 474648 474678 474693 477961 479049 479126 480059 481918 484608 484626 484644 484673 484704 484746 485246 486341 486344 490085 491114 491910 498491 501797 503411 505023 508003 514436 518264 534028 547622 549799 550219 551226 558131 561692 563413 590398 601338 602653 636026 650155 651841 699625 788767 798680 807326 808691 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal russian young"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал русск young"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал русск young"
]
|
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.