Query Metrics
7
Database Queries
7
Different statements
161.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.95 ms (82.14%) |
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 9792 10065 31563 53768 91278 134210 384070 384371 388424 390493 391059 391447 395425 396397 397642 398029 401979 402541 402551 403216 403289 405472 406469 409046 413346 415517 415525 421129 425430 429260 438587 447641 464903 468687 468712 468749 470788 473723 474711 474719 474734 477987 484486 491590 497140 497877 512881 512882 521240 526782 527492 527593 528901 528959 529018 529053 529058 531140 532970 534991 536701 541913 550342 558047 558052 566785 567184 571209 571214 571215 571219 575727 576090 582445 584457 593116 594912 598565 600358 603432 605325 605331 605333 605334 605339 605342 605352 609870 609878 619375 628310 631944 634536 634552 634553 637079 638412 638533 644288 644291 644330 671523 672412 673074 673082 687431 689315 689616 702152 702624 714526 729894 730107 730918 758540 758557 784494 792180 792534 810258 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (10.42%) |
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 529058 91278 53768 31563 9792 402551 527593 672412 637079 605352 730918 792534 397642 395425 384070 134210 10065 391447 398029 402541 401979 403216 405472 425430 468687 468712 447641 468749 474734 512881 526782 532970 528901 528959 531140 534991 497877 512882 529018 536701 521240 527492 529053 464903 473723 474711 541913 558047 575727 584457 550342 566785 567184 576090 582445 558052 571209 571215 671523 673074 673082 689616 702152 687431 689315 571214 571219 609870 609878 628310 638412 644288 644291 603432 605325 605339 605342 631944 634553 593116 594912 598565 600358 605331 634536 634552 638533 605334 784494 792180 758540 729894 730107 758557 605333 619375 644330 702624 714526 810258 409046 438587 470788 477987 396397 429260 384371 390493 403289 406469 421129 388424 391059 413346 415517 415525 474719 484486 491590 497140 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (2.67%) |
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 9792 10065 31563 53768 91278 134210 384070 384371 388424 390493 391059 391447 395425 396397 397642 398029 401979 402541 402551 403216 403289 405472 406469 409046 413346 415517 415525 421129 425430 429260 438587 447641 464903 468687 468712 468749 470788 473723 474711 474719 474734 477987 484486 491590 497140 497877 512881 512882 521240 526782 527492 527593 528901 528959 529018 529053 529058 531140 532970 534991 536701 541913 550342 558047 558052 566785 567184 571209 571214 571215 571219 575727 576090 582445 584457 593116 594912 598565 600358 603432 605325 605331 605333 605334 605339 605342 605352 609870 609878 619375 628310 631944 634536 634552 634553 637079 638412 638533 644288 644291 644330 671523 672412 673074 673082 687431 689315 689616 702152 702624 714526 729894 730107 730918 758540 758557 784494 792180 792534 810258 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx casting"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.