Query Metrics
7
Database Queries
7
Different statements
193.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.89 ms (86.84%) |
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 8064 13181 16882 41433 157046 182352 231260 256431 290847 351291 382143 382490 383646 386675 386740 391449 391754 408824 415092 423662 434334 434338 439427 440723 441042 441122 443240 444952 445401 451221 456222 456239 462236 464044 464659 467588 467886 468222 470470 481335 482900 490767 492814 493258 493727 494293 495561 498114 504509 505800 510546 510783 519364 520910 521294 523869 526570 529869 531369 531589 531751 532007 532539 535555 538829 539241 539881 541251 541807 547790 555119 560050 561754 565585 589040 602347 616204 634108 697457 700837 706520 709917 714476 725495 741257 741496 742470 749677 749958 755019 757265 758975 759806 760580 765079 765601 765654 766298 768845 780028 780640 789403 796709 800673 803124 803143 806375 808272 809954 813557 814186 816184 818561 822698 823580 823992 827295 827692 827699 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (7.60%) |
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 755019 758975 765079 725495 741257 749958 765654 741496 742470 749677 757265 759806 760580 765601 766298 768845 602347 616204 700837 706520 780028 780640 789403 796709 800673 803124 803143 806375 808272 809954 8064 182352 351291 391449 13181 595376 589040 256431 481335 561754 408824 444952 492814 505800 290847 441122 423662 439427 445401 464659 470470 510546 495561 521294 547790 565585 541807 560050 555119 697457 709917 714476 634108 456222 462236 467886 468222 434334 440723 441042 467588 451221 391754 434338 456239 443240 523869 493258 519364 520910 541251 482900 504509 510783 526570 490767 498114 386675 386740 383646 157046 231260 382143 382490 41433 16882 415092 814186 816184 813557 823992 827295 827692 818561 822698 823580 827699 493727 464044 494293 531369 531751 539241 539881 538829 529869 532007 535555 531589 532539 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (2.13%) |
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 8064 13181 16882 41433 157046 182352 231260 256431 290847 351291 382143 382490 383646 386675 386740 391449 391754 408824 415092 423662 434334 434338 439427 440723 441042 441122 443240 444952 445401 451221 456222 456239 462236 464044 464659 467588 467886 468222 470470 481335 482900 490767 492814 493258 493727 494293 495561 498114 504509 505800 510546 510783 519364 520910 521294 523869 526570 529869 531369 531589 531751 532007 532539 535555 538829 539241 539881 541251 541807 547790 555119 560050 561754 565585 589040 602347 616204 634108 697457 700837 706520 709917 714476 725495 741257 741496 742470 749677 749958 755019 757265 758975 759806 760580 765079 765601 765654 766298 768845 780028 780640 789403 796709 800673 803124 803143 806375 808272 809954 813557 814186 816184 818561 822698 823580 823992 827295 827692 827699 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo doggy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло рак"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
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.