Query Metrics
7
Database Queries
7
Different statements
202.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.89 ms (86.08%) |
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 6866 17037 82143 103889 116720 229361 342646 383112 383328 385066 386518 386782 388080 390646 391432 391674 392386 394013 395372 396225 396323 396864 397464 398057 398204 398686 398774 398802 399837 402483 405827 407359 410217 411335 412679 413179 417683 417770 418046 418371 419848 420086 420501 420642 422336 423862 423992 424617 425916 426723 426925 428303 431161 435888 437560 438293 439349 440909 441293 441479 442088 442344 445030 446345 447139 449472 449990 451219 453961 454749 454895 455311 456943 457212 457328 458674 462383 464618 464869 467777 468914 472874 472944 479398 479980 483576 488791 491441 492038 501513 505867 508171 522703 526760 528994 530195 530938 534361 544458 544602 561157 562929 571003 573275 577338 581015 600028 602525 608668 611030 611611 622418 646949 668015 717877 739802 779144 783044 807166 813285 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (8.09%) |
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 398057 399837 402483 405827 441479 410217 412679 426723 435888 438293 442344 428303 437560 419848 426925 442088 431161 446345 449472 451219 455311 457328 458674 479980 447139 453961 454895 456943 462383 464618 483576 522703 530938 534361 501513 528994 530195 491441 544458 562929 577338 571003 581015 646949 717877 668015 544602 561157 573275 602525 608668 600028 611611 622418 611030 783044 813285 779144 739802 807166 395372 396225 407359 413179 423862 439349 464869 17037 82143 383328 386518 386782 394013 417770 445030 472944 391432 396864 398686 420086 454749 385066 397464 398774 411335 418046 418371 423992 440909 441293 449990 457212 467777 468914 472874 479398 417683 492038 505867 526760 488791 508171 383112 229361 116720 391674 392386 342646 6866 103889 388080 390646 396323 398204 398802 420501 420642 422336 424617 425916 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (2.20%) |
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 6866 17037 82143 103889 116720 229361 342646 383112 383328 385066 386518 386782 388080 390646 391432 391674 392386 394013 395372 396225 396323 396864 397464 398057 398204 398686 398774 398802 399837 402483 405827 407359 410217 411335 412679 413179 417683 417770 418046 418371 419848 420086 420501 420642 422336 423862 423992 424617 425916 426723 426925 428303 431161 435888 437560 438293 439349 440909 441293 441479 442088 442344 445030 446345 447139 449472 449990 451219 453961 454749 454895 455311 456943 457212 457328 458674 462383 464618 464869 467777 468914 472874 472944 479398 479980 483576 488791 491441 492038 501513 505867 508171 522703 526760 528994 530195 530938 534361 544458 544602 561157 562929 571003 573275 577338 581015 600028 602525 608668 611030 611611 622418 646949 668015 717877 739802 779144 783044 807166 813285 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"упругую"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"упругая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.82%) |
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.