Query Metrics
7
Database Queries
7
Different statements
220.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.50 ms (88.31%) |
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 46409 383926 397068 399475 399484 400668 400829 403074 403264 404216 411663 420513 420830 421618 424334 425514 432493 433385 434057 434887 437156 437243 437580 437914 441442 441595 444429 444562 445535 445551 446531 446914 447818 449398 453744 455498 455787 456286 457181 457201 459517 459885 459991 460118 461596 462242 463530 463654 465084 472122 472913 473233 473626 473715 477088 477235 480960 483888 485254 485455 488090 489630 490205 491177 491317 494814 495557 498473 506353 507890 511555 514432 515740 516465 516513 517909 517912 519275 523476 523490 524266 526813 528107 536652 551440 561948 565043 568070 568098 574168 581704 588266 590174 597865 599615 599637 600982 603721 608287 614445 669251 709914 714580 718070 727147 743877 763842 770595 772017 775295 778014 779656 780128 782753 793959 797748 799318 802024 809868 821798 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (7.50%) |
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 447818 456286 463530 498473 536652 574168 568098 588266 603721 599637 600982 400829 455498 462242 465084 403264 437156 437580 446914 477235 420513 444429 444562 463654 473626 459517 472122 516465 516513 517912 485455 495557 514432 519275 488090 523476 489630 494814 511555 403074 421618 420830 437243 821798 457181 491317 506353 517909 669251 709914 565043 597865 599615 608287 614445 799318 802024 775295 727147 743877 763842 778014 779656 793959 46409 397068 459991 424334 433385 460118 515740 524266 528107 551440 590174 449398 526813 383926 441595 411663 425514 453744 485254 445535 459885 523490 718070 780128 782753 809868 770595 797748 772017 714580 400668 434057 434887 473233 472913 399475 404216 457201 473715 399484 432493 477088 483888 490205 441442 445551 491177 507890 568070 581704 561948 455787 446531 480960 437914 461596 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.21%) |
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 46409 383926 397068 399475 399484 400668 400829 403074 403264 404216 411663 420513 420830 421618 424334 425514 432493 433385 434057 434887 437156 437243 437580 437914 441442 441595 444429 444562 445535 445551 446531 446914 447818 449398 453744 455498 455787 456286 457181 457201 459517 459885 459991 460118 461596 462242 463530 463654 465084 472122 472913 473233 473626 473715 477088 477235 480960 483888 485254 485455 488090 489630 490205 491177 491317 494814 495557 498473 506353 507890 511555 514432 515740 516465 516513 517909 517912 519275 523476 523490 524266 526813 528107 536652 551440 561948 565043 568070 568098 574168 581704 588266 590174 597865 599615 599637 600982 603721 608287 614445 669251 709914 714580 718070 727147 743877 763842 770595 772017 775295 778014 779656 780128 782753 793959 797748 799318 802024 809868 821798 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sister"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sister"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sister"
]
|
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.