Query Metrics
7
Database Queries
7
Different statements
162.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.44 ms (83.42%) |
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 91248 410905 413968 417722 431497 437830 439811 439858 443499 446081 447449 455591 456221 462280 463705 468048 469715 472329 474487 476369 476856 479952 488925 489434 492721 495210 496311 497056 521818 522879 526116 528913 528929 531432 532743 538738 542187 548311 550107 551183 554889 558052 560075 561202 561411 562324 562844 564083 567075 569662 569902 570205 570321 570352 570503 571596 572160 573006 575490 575778 576051 577363 577381 578067 580522 584704 584713 589357 590306 590928 592047 592337 592436 592481 592494 601111 615709 624502 626202 626831 627672 633503 639218 639881 649905 652283 661330 661378 661575 662556 671088 671098 692713 695814 704669 729564 738664 742126 744034 747606 763739 765829 768765 768969 770246 776359 780114 787298 792532 799723 803948 806057 810598 812217 812240 818752 828021 828132 828243 828290 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (10.10%) |
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 522879 592494 496311 571596 554889 589357 577381 446081 561411 562844 792532 532743 601111 806057 787298 570205 521818 551183 765829 91248 573006 476369 479952 747606 592436 413968 528929 456221 763739 633503 417722 570352 592481 615709 590928 492721 558052 577363 572160 562324 474487 439811 463705 580522 569902 455591 447449 443499 528913 531432 462280 560075 570321 575490 567075 578067 439858 469715 489434 662556 468048 437830 584713 592047 526116 570503 476856 576051 569662 624502 548311 575778 584704 542187 639881 744034 495210 410905 768765 729564 692713 812217 592337 704669 818752 828243 799723 828132 627672 550107 738664 661330 828021 431497 768969 626831 803948 488925 671098 538738 561202 812240 649905 564083 742126 780114 770246 810598 671088 695814 626202 652283 639218 497056 472329 590306 828290 661575 776359 661378 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.83%) |
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 91248 410905 413968 417722 431497 437830 439811 439858 443499 446081 447449 455591 456221 462280 463705 468048 469715 472329 474487 476369 476856 479952 488925 489434 492721 495210 496311 497056 521818 522879 526116 528913 528929 531432 532743 538738 542187 548311 550107 551183 554889 558052 560075 561202 561411 562324 562844 564083 567075 569662 569902 570205 570321 570352 570503 571596 572160 573006 575490 575778 576051 577363 577381 578067 580522 584704 584713 589357 590306 590928 592047 592337 592436 592481 592494 601111 615709 624502 626202 626831 627672 633503 639218 639881 649905 652283 661330 661378 661575 662556 671088 671098 692713 695814 704669 729564 738664 742126 744034 747606 763739 765829 768765 768969 770246 776359 780114 787298 792532 799723 803948 806057 810598 812217 812240 818752 828021 828132 828243 828290 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl public car"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк на улиц вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк на улиц вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
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.