Query Metrics
7
Database Queries
7
Different statements
193.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.15 ms (85.68%) |
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 384570 396204 396786 398425 401089 402716 408824 413577 414256 417421 417592 420494 420507 424089 429575 429877 443119 445545 448641 455456 464250 481251 546476 547570 548773 550306 551283 552077 552124 552148 552565 552668 552684 554085 558504 558858 560626 562047 562119 562286 562294 562395 566220 569850 569991 570013 570021 570038 570193 570199 570274 570531 570606 570670 571769 571865 571906 572154 572165 573022 573100 573341 573770 573790 573840 573908 574611 576076 576369 577834 579202 581185 585910 586546 586663 586803 586932 590609 590615 591041 591309 593137 594048 594225 594826 596618 596619 597136 597504 598021 598058 598526 598528 598535 598674 598700 598816 598923 599107 599454 600472 600894 601534 601880 605050 606392 607125 652923 659042 714491 714498 714526 718696 728730 730715 732423 770814 792767 795690 805346 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (9.35%) |
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 659042 714491 652923 714498 718696 546476 547570 548773 550306 551283 552077 552124 552148 552565 552668 552684 554085 558504 558858 560626 562047 562119 562286 562294 562395 566220 569850 569991 570013 570021 570038 570193 570199 570274 570531 570606 570670 571769 571865 571906 572154 572165 573022 573100 573341 573770 573790 573840 573908 574611 576076 576369 577834 579202 581185 593137 594826 597136 598058 598674 598700 598923 600472 601880 605050 607125 585910 590615 591041 596618 596619 598535 598816 599454 600894 606392 586803 590609 591309 594048 594225 598021 598526 598528 599107 586546 586663 586932 597504 795690 805346 730715 770814 728730 732423 601534 714526 792767 398425 402716 408824 413577 417592 420494 420507 443119 445545 448641 396204 384570 401089 414256 417421 424089 429575 429877 455456 464250 481251 396786 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.53%) |
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 384570 396204 396786 398425 401089 402716 408824 413577 414256 417421 417592 420494 420507 424089 429575 429877 443119 445545 448641 455456 464250 481251 546476 547570 548773 550306 551283 552077 552124 552148 552565 552668 552684 554085 558504 558858 560626 562047 562119 562286 562294 562395 566220 569850 569991 570013 570021 570038 570193 570199 570274 570531 570606 570670 571769 571865 571906 572154 572165 573022 573100 573341 573770 573790 573840 573908 574611 576076 576369 577834 579202 581185 585910 586546 586663 586803 586932 590609 590615 591041 591309 593137 594048 594225 594826 596618 596619 597136 597504 598021 598058 598526 598528 598535 598674 598700 598816 598923 599107 599454 600472 600894 601534 601880 605050 606392 607125 652923 659042 714491 714498 714526 718696 728730 730715 732423 770814 792767 795690 805346 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая жоп"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая попу"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.70%) |
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.