Query Metrics
7
Database Queries
7
Different statements
187.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.66 ms (84.20%) |
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 14602 21506 27844 239808 325660 385092 385228 385745 387274 388647 389788 391545 392554 393613 393745 393775 394636 395609 395651 395686 396060 396184 396226 396245 400026 400418 400452 400714 401306 401976 404059 404366 404950 405100 406042 406817 411218 414710 417476 418421 418484 418654 421519 422576 422584 422985 423283 425714 427449 427523 445062 445933 446480 447661 447662 448507 451554 456414 456929 462803 462961 464593 465245 470324 472471 472962 476944 477553 478853 479560 480420 491670 496356 499243 519227 526503 529025 544471 550051 552859 561929 568707 569427 574854 579439 580237 581652 581660 581700 581706 584537 591600 594121 594760 595875 597801 598505 598508 598806 604143 605329 620801 625605 672766 677352 680102 720273 720462 721551 726461 730367 740610 746423 770852 780713 793642 796731 799785 813128 815855 ] |
||||||||||||||||||||||||||||||
|
18.89 ms (10.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 594121 595875 598806 598505 406042 385745 385092 393775 395686 404366 422576 417476 422584 418484 423283 445933 451554 456414 476944 569427 580237 584537 721551 550051 561929 581660 581706 591600 620801 404059 479560 472962 480420 404950 405100 418421 462803 478853 395609 414710 470324 472471 422985 448507 526503 491670 496356 519227 396060 389788 447662 499243 464593 597801 604143 605329 598508 796731 799785 746423 391545 392554 400026 529025 385228 239808 393613 393745 394636 395651 325660 21506 27844 14602 388647 387274 396226 396184 396245 400452 400714 400418 401976 401306 406817 411218 418654 421519 445062 427449 425714 427523 815855 446480 465245 477553 447661 456929 462961 544471 568707 574854 579439 680102 672766 677352 720273 720462 552859 581652 581700 594760 625605 780713 813128 793642 730367 740610 770852 726461 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (1.90%) |
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 14602 21506 27844 239808 325660 385092 385228 385745 387274 388647 389788 391545 392554 393613 393745 393775 394636 395609 395651 395686 396060 396184 396226 396245 400026 400418 400452 400714 401306 401976 404059 404366 404950 405100 406042 406817 411218 414710 417476 418421 418484 418654 421519 422576 422584 422985 423283 425714 427449 427523 445062 445933 446480 447661 447662 448507 451554 456414 456929 462803 462961 464593 465245 470324 472471 472962 476944 477553 478853 479560 480420 491670 496356 499243 519227 526503 529025 544471 550051 552859 561929 568707 569427 574854 579439 580237 581652 581660 581700 581706 584537 591600 594121 594760 595875 597801 598505 598508 598806 604143 605329 620801 625605 672766 677352 680102 720273 720462 721551 726461 730367 740610 746423 770852 780713 793642 796731 799785 813128 815855 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen and man"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen мужчин"
]
|
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.