Query Metrics
7
Database Queries
7
Different statements
416.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.56 ms (50.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small russian"
]
|
||||||||||||||||||||||||||||||
|
179.61 ms (43.10%) |
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 119987 384342 408776 408841 413577 415894 418405 418434 423766 424071 425887 428375 443423 451688 455363 462736 467776 467817 468683 471552 473687 481191 492500 522814 523286 524502 524715 525282 542953 548780 548796 551207 552143 552151 552212 552222 552423 552622 559055 560577 561635 561880 562109 562201 562235 563411 567773 569875 570021 570269 570531 570670 571885 571908 571926 571987 572085 572151 572442 572469 572483 573002 573110 573545 573951 574534 574550 574798 574819 574843 574878 575076 575112 575275 575467 575776 576285 576349 576372 577837 578080 578303 578375 580673 585910 588654 588899 590325 595403 595418 595865 595870 596577 597060 597136 597472 597504 597528 597576 598021 598032 598447 598535 598548 598662 598674 598753 598782 598798 601560 601978 656463 656780 658353 659793 715453 722825 736845 773638 828028 ] |
||||||||||||||||||||||||||||||
|
20.92 ms (5.02%) |
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 658353 656463 656780 659793 552423 560577 562235 570021 570531 570670 572469 573545 574798 574843 575467 576285 578080 578303 595403 595865 597136 598674 585910 598535 598021 597504 601560 413577 451688 481191 418405 418434 562201 569875 572151 572442 573002 542953 552143 573110 573951 552151 552212 552222 570269 571885 571908 572483 578375 715453 572085 580673 559055 562109 567773 575776 548780 548796 574819 575076 575275 576349 576372 561635 574550 577837 571926 574878 575112 597528 598447 588654 597472 598753 601978 571987 561880 563411 574534 552622 596577 597060 598032 588899 595870 595418 598782 590325 597576 722825 524502 525282 773638 736845 598548 598662 408776 443423 471552 473687 408841 424071 425887 384342 415894 468683 455363 467817 523286 522814 828028 492500 598798 119987 428375 467776 423766 462736 524715 551207 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.65%) |
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 119987 384342 408776 408841 413577 415894 418405 418434 423766 424071 425887 428375 443423 451688 455363 462736 467776 467817 468683 471552 473687 481191 492500 522814 523286 524502 524715 525282 542953 548780 548796 551207 552143 552151 552212 552222 552423 552622 559055 560577 561635 561880 562109 562201 562235 563411 567773 569875 570021 570269 570531 570670 571885 571908 571926 571987 572085 572151 572442 572469 572483 573002 573110 573545 573951 574534 574550 574798 574819 574843 574878 575076 575112 575275 575467 575776 576285 576349 576372 577837 578080 578303 578375 580673 585910 588654 588899 590325 595403 595418 595865 595870 596577 597060 597136 597472 597504 597528 597576 598021 598032 598447 598535 598548 598662 598674 598753 598782 598798 601560 601978 656463 656780 658353 659793 715453 722825 736845 773638 828028 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая русск"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.