Query Metrics
7
Database Queries
7
Different statements
212.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.34 ms (88.62%) |
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 238771 324827 383542 395413 395755 397520 398022 401559 402164 408470 411518 413294 417758 418083 420586 425026 425163 425249 425891 429929 430365 433950 435799 444201 444226 445941 451595 452621 452791 454674 455192 456110 457509 458937 459790 461482 461528 461531 461625 462518 462891 466623 468166 468577 471962 472767 474615 475320 475444 480135 481154 484350 484952 487088 488797 489083 489587 489602 491514 495786 498936 506144 506217 509648 510383 510629 510985 511179 511235 516261 517911 521760 521879 523060 536861 536937 543662 551370 551521 552148 558069 560002 561695 562324 568359 569511 569689 570357 572494 573885 576082 578047 586777 586803 590955 597078 601772 603945 620852 630581 633811 643541 676342 680362 693930 697135 722035 731168 733787 737110 744725 754234 758691 773248 776191 786859 793985 802551 805684 811528 ] |
||||||||||||||||||||||||||||||
|
13.62 ms (6.41%) |
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 398022 506144 676342 805684 461482 417758 484350 506217 786859 543662 733787 693930 395413 484952 510985 551370 558069 552148 630581 597078 586803 590955 433950 475444 418083 461625 474615 480135 408470 425026 461531 491514 238771 324827 383542 744725 776191 793985 402164 802551 462891 633811 430365 516261 456110 568359 562324 454674 459790 413294 472767 451595 489083 444201 569511 697135 643541 811528 511179 517911 481154 471962 560002 468166 445941 425891 458937 511235 509648 569689 603945 758691 461528 435799 452621 551521 731168 576082 523060 395755 722035 773248 457509 462518 444226 425249 536937 452791 466623 488797 521760 487088 680362 754234 397520 489587 578047 572494 570357 573885 586777 601772 620852 737110 420586 475320 401559 455192 411518 425163 429929 468577 510383 521879 498936 510629 495786 561695 536861 489602 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.25%) |
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 238771 324827 383542 395413 395755 397520 398022 401559 402164 408470 411518 413294 417758 418083 420586 425026 425163 425249 425891 429929 430365 433950 435799 444201 444226 445941 451595 452621 452791 454674 455192 456110 457509 458937 459790 461482 461528 461531 461625 462518 462891 466623 468166 468577 471962 472767 474615 475320 475444 480135 481154 484350 484952 487088 488797 489083 489587 489602 491514 495786 498936 506144 506217 509648 510383 510629 510985 511179 511235 516261 517911 521760 521879 523060 536861 536937 543662 551370 551521 552148 558069 560002 561695 562324 568359 569511 569689 570357 572494 573885 576082 578047 586777 586803 590955 597078 601772 603945 620852 630581 633811 643541 676342 680362 693930 697135 722035 731168 733787 737110 744725 754234 758691 773248 776191 786859 793985 802551 805684 811528 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girls sex"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.78%) |
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.