Query Metrics
7
Database Queries
7
Different statements
197.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.18 ms (88.06%) |
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 24356 73204 84120 129955 191207 382101 383431 383530 384540 387146 393504 394710 397912 401001 401194 401288 403501 418997 428555 433045 442050 459230 474789 483398 497506 511572 521317 533022 533246 537109 537667 546409 557250 562013 578427 585532 586613 634559 638585 654187 695213 699011 710552 710562 710883 712239 714544 718253 719132 719276 722683 723659 725185 726320 726610 727036 728084 728277 729891 732065 748190 753007 759424 759730 760684 767070 767085 767192 767279 769477 769993 777439 779705 787557 788131 788583 789510 789982 789992 792564 793538 797020 799386 799517 800631 801012 802398 802402 803346 803548 805356 806095 806114 806713 807121 807792 810445 811984 813393 814249 814369 815162 815306 815804 815858 816932 817358 817613 817765 817840 817844 817890 820052 820947 821726 821956 823377 826938 828535 828869 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (6.92%) |
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 769993 732065 759424 759730 753007 760684 699011 710552 710562 777439 779705 789982 792564 793538 799386 799517 802398 803548 807121 807792 191207 387146 725185 788131 726610 805356 384540 129955 403501 723659 826938 815162 817765 654187 722683 586613 800631 767192 811984 814249 815306 820947 820052 821726 814369 815804 815858 817840 817844 823377 497506 537109 578427 695213 719132 710883 714544 557250 585532 638585 634559 801012 788583 729891 719276 787557 401194 748190 789992 393504 397912 767279 533022 383530 442050 789510 712239 767085 382101 73204 802402 24356 813393 803346 728277 401288 418997 433045 806713 727036 769477 797020 401001 383431 817358 806095 806114 726320 728084 767070 718253 810445 394710 84120 428555 817613 821956 816932 817890 828869 828535 459230 537667 511572 521317 533246 474789 483398 562013 546409 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.59%) |
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 24356 73204 84120 129955 191207 382101 383431 383530 384540 387146 393504 394710 397912 401001 401194 401288 403501 418997 428555 433045 442050 459230 474789 483398 497506 511572 521317 533022 533246 537109 537667 546409 557250 562013 578427 585532 586613 634559 638585 654187 695213 699011 710552 710562 710883 712239 714544 718253 719132 719276 722683 723659 725185 726320 726610 727036 728084 728277 729891 732065 748190 753007 759424 759730 760684 767070 767085 767192 767279 769477 769993 777439 779705 787557 788131 788583 789510 789982 789992 792564 793538 797020 799386 799517 800631 801012 802398 802402 803346 803548 805356 806095 806114 806713 807121 807792 810445 811984 813393 814249 814369 815162 815306 815804 815858 816932 817358 817613 817765 817840 817844 817890 820052 820947 821726 821956 823377 826938 828535 828869 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass mother"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
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.