Query Metrics
7
Database Queries
7
Different statements
373.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.57 ms (55.08%) |
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 126458 145314 213330 391517 391581 393701 396757 397279 398957 401124 402340 404125 414091 417276 418421 419558 424582 426725 443673 443686 443706 443723 444001 444142 444258 445040 445052 446254 449125 462579 464303 466187 467169 467173 469844 469898 469910 470734 470738 470785 473252 474033 477958 477980 489548 492205 494382 501845 503958 504744 515294 523976 526111 539381 542942 544301 552859 556849 560383 560397 563207 566303 595363 598041 598443 598583 612000 622111 627748 635897 637589 654717 654764 656381 656751 657434 658014 658066 658419 669344 676453 676473 677681 678972 695849 701501 709578 710959 712906 712913 713441 714455 716835 718716 721434 721502 722897 730600 731098 740083 741646 742151 747380 750561 755735 755818 766536 772388 775819 780628 782279 802632 810843 813941 818073 818078 818994 819550 820087 825804 ] |
||||||||||||||||||||||||||||||
|
146.98 ms (39.38%) |
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 126458 145314 213330 391517 391581 393701 396757 397279 398957 401124 402340 404125 414091 417276 418421 419558 424582 426725 443673 443686 443706 443723 444001 444142 444258 445040 445052 446254 449125 462579 464303 466187 467169 467173 469844 469898 469910 470734 470738 470785 473252 474033 477958 477980 489548 492205 494382 501845 503958 504744 515294 523976 526111 539381 542942 544301 552859 556849 560383 560397 563207 566303 595363 598041 598443 598583 612000 622111 627748 635897 637589 654717 654764 656381 656751 657434 658014 658066 658419 669344 676453 676473 677681 678972 695849 701501 709578 710959 712906 712913 713441 714455 716835 718716 721434 721502 722897 730600 731098 740083 741646 742151 747380 750561 755735 755818 766536 772388 775819 780628 782279 802632 810843 813941 818073 818078 818994 819550 820087 825804 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (3.71%) |
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 443723 424582 709578 714455 676473 701501 676453 622111 750561 747380 467169 397279 470734 492205 560397 419558 126458 775819 542942 716835 552859 598443 627748 595363 741646 766536 443686 443706 466187 470785 477958 445040 477980 444142 444258 396757 462579 469844 469898 473252 443673 444001 501845 494382 515294 526111 598041 414091 818078 813941 819550 820087 544301 658066 658419 678972 712913 721502 656381 712906 721434 635897 755735 772388 731098 782279 445052 449125 418421 464303 523976 489548 393701 556849 563207 401124 417276 426725 402340 391581 398957 469910 677681 742151 722897 446254 467173 470738 503958 818994 825804 818073 539381 657434 713441 654717 669344 656751 658014 695849 710959 598583 612000 780628 740083 730600 755818 718716 802632 810843 145314 213330 504744 566303 560383 654764 637589 474033 404125 391517 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск young"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian young"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.