Query Metrics
7
Database Queries
7
Different statements
181.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.01 ms (83.96%) |
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 393081 394258 394376 395891 398236 400134 400481 403600 407111 409093 411165 418974 421884 428102 428463 428910 430393 432807 439571 439671 443167 447259 452629 452641 454423 457191 459131 459783 460197 462569 465545 466812 469549 470293 470762 472176 474097 474401 474498 474790 476250 477110 477987 479177 491991 493198 496056 496292 500806 502305 505822 505826 507884 515849 517428 518341 520883 521161 521473 521490 523031 524357 524655 524779 528858 531996 555889 561453 562952 562967 562985 586617 605261 607030 620245 693629 719912 723945 723955 724045 724476 725407 725440 725442 725456 725788 726612 731073 731204 734734 735908 735909 742839 743431 744184 744563 753148 753515 753764 757114 758174 764698 769503 769536 774316 775270 779576 779904 785945 788158 793294 795983 796202 796203 796205 796206 797632 799357 808496 ] |
||||||||||||||||||||||||||||||
|
18.11 ms (10.00%) |
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 693629 555889 561453 562952 562967 620245 605261 586617 607030 779576 779904 793294 795983 796205 775270 779905 788158 796202 799357 723955 724045 725407 725442 731204 735908 742839 744184 785945 796206 808496 724476 743431 744563 769536 723945 725456 725788 726612 734734 753148 758174 769503 774316 731073 725440 735909 753515 753764 757114 764698 719912 796203 797632 411165 428463 428910 430393 465545 469549 477987 393081 394258 398236 400134 400481 457191 459131 474790 418974 459783 470293 472176 474498 479177 395891 447259 452629 477110 409093 500806 515849 521473 491991 523031 496056 496292 518341 524357 493198 520883 521490 524655 524779 528858 507884 462569 432807 470762 474401 421884 439571 521161 394376 403600 428102 407111 443167 439671 452641 466812 474097 454423 505826 517428 531996 502305 505822 460197 476250 562985 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.79%) |
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 393081 394258 394376 395891 398236 400134 400481 403600 407111 409093 411165 418974 421884 428102 428463 428910 430393 432807 439571 439671 443167 447259 452629 452641 454423 457191 459131 459783 460197 462569 465545 466812 469549 470293 470762 472176 474097 474401 474498 474790 476250 477110 477987 479177 491991 493198 496056 496292 500806 502305 505822 505826 507884 515849 517428 518341 520883 521161 521473 521490 523031 524357 524655 524779 528858 531996 555889 561453 562952 562967 562985 586617 605261 607030 620245 693629 719912 723945 723955 724045 724476 725407 725440 725442 725456 725788 726612 731073 731204 734734 735908 735909 742839 743431 744184 744563 753148 753515 753764 757114 758174 764698 769503 769536 774316 775270 779576 779904 785945 788158 793294 795983 796202 796203 796205 796206 797632 799357 808496 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son boy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son парен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son парен"
]
|
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.