Query Metrics
7
Database Queries
7
Different statements
204.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.36 ms (89.35%) |
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 116757 223442 257963 360205 383565 384481 384902 385838 397425 398622 417711 424014 429263 429264 443599 456196 456702 460030 461123 461314 465770 465991 466668 466676 471777 472086 472337 472370 475106 478008 482682 483814 484070 485677 487046 488712 490815 491391 491674 491681 491865 502252 504259 506571 508828 510079 511048 512824 513286 518786 521920 525734 528880 529027 542972 545771 545798 548312 549282 551174 551175 551193 551844 560164 560166 562226 562927 569843 569877 569881 570251 570319 570339 570340 570356 570506 571559 571601 571861 571876 572112 572126 572153 572455 573006 573051 573958 573972 589805 594962 599261 607172 622009 632065 638971 669609 670171 673100 687206 695662 695674 696004 696052 696701 699457 719894 719907 723692 734650 746465 757606 763463 769094 769139 774052 785408 789297 816677 820655 822886 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (6.32%) |
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 488712 551174 542972 551844 491865 484070 607172 632065 785408 757606 560164 719907 820655 822886 816677 549282 571861 545771 670171 669609 673100 572112 769139 789297 746465 774052 734650 699457 384902 385838 360205 622009 551175 570506 571559 529027 443599 465770 456702 573958 573972 572126 572455 594962 466676 472337 472086 504259 521920 383565 398622 525734 560166 695674 696004 696052 769094 696701 424014 429263 599261 511048 687206 719894 638971 491674 460030 461314 569843 570340 570356 573051 475106 490815 513286 571601 723692 763463 384481 506571 528880 548312 570339 491391 508828 482682 570319 551193 569881 562226 570251 571876 572153 589805 478008 257963 429264 417711 487046 466668 569877 573006 397425 456196 465991 471777 483814 485677 512824 518786 116757 545798 695662 461123 472370 510079 223442 491681 502252 562927 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.19%) |
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 116757 223442 257963 360205 383565 384481 384902 385838 397425 398622 417711 424014 429263 429264 443599 456196 456702 460030 461123 461314 465770 465991 466668 466676 471777 472086 472337 472370 475106 478008 482682 483814 484070 485677 487046 488712 490815 491391 491674 491681 491865 502252 504259 506571 508828 510079 511048 512824 513286 518786 521920 525734 528880 529027 542972 545771 545798 548312 549282 551174 551175 551193 551844 560164 560166 562226 562927 569843 569877 569881 570251 570319 570339 570340 570356 570506 571559 571601 571861 571876 572112 572126 572153 572455 573006 573051 573958 573972 589805 594962 599261 607172 622009 632065 638971 669609 670171 673100 687206 695662 695674 696004 696052 696701 699457 719894 719907 723692 734650 746465 757606 763463 769094 769139 774052 785408 789297 816677 820655 822886 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pickup public"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.