Query Metrics
7
Database Queries
7
Different statements
147.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.11 ms (82.28%) |
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 391125 396065 414432 421623 423625 428052 428753 431740 433980 436844 437801 444188 447300 448585 450450 451003 452922 455670 458739 461551 462038 462169 463394 464915 468757 471712 471933 473115 474283 474575 475548 476383 476536 478012 479605 479662 483036 483129 483995 486519 487623 489021 490387 490619 494864 498645 499474 499502 501185 501910 502709 502855 503315 503822 505324 507657 508687 510503 512488 512604 516036 516108 516377 516512 516538 518091 521533 521871 521903 521959 521978 522282 522801 524447 524514 524684 524935 525453 526053 527057 528781 528797 536878 538212 541065 546381 546652 547845 550453 551639 552210 552518 552948 558049 558853 558950 558955 561639 563750 569898 570271 570382 571283 571575 572062 572128 572448 573812 574858 578503 578865 579200 584108 587005 598554 598777 627135 655656 656345 778610 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (11.01%) |
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 512604 462038 483129 473115 437801 414432 464915 501910 524447 524514 458739 510503 516108 475548 391125 498645 778610 516538 552518 563750 474575 578865 463394 547845 541065 516377 490619 448585 569898 558853 538212 525453 455670 598554 468757 499502 656345 471712 521533 573812 570271 461551 476383 558049 450450 452922 505324 524935 552210 503822 486519 550453 551639 655656 462169 521978 522282 489021 451003 572062 572448 574858 571575 521903 522801 558950 487623 584108 587005 431740 478012 507657 428753 436844 433980 528781 558955 471933 526053 528797 483995 579200 521871 490387 474283 428052 516036 502855 552948 508687 494864 479605 572128 521959 516512 570382 546381 444188 578503 524684 502709 503315 527057 571283 627135 423625 421623 479662 476536 536878 598777 396065 546652 447300 483036 518091 501185 512488 499474 561639 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.68%) |
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 391125 396065 414432 421623 423625 428052 428753 431740 433980 436844 437801 444188 447300 448585 450450 451003 452922 455670 458739 461551 462038 462169 463394 464915 468757 471712 471933 473115 474283 474575 475548 476383 476536 478012 479605 479662 483036 483129 483995 486519 487623 489021 490387 490619 494864 498645 499474 499502 501185 501910 502709 502855 503315 503822 505324 507657 508687 510503 512488 512604 516036 516108 516377 516512 516538 518091 521533 521871 521903 521959 521978 522282 522801 524447 524514 524684 524935 525453 526053 527057 528781 528797 536878 538212 541065 546381 546652 547845 550453 551639 552210 552518 552948 558049 558853 558950 558955 561639 563750 569898 570271 570382 571283 571575 572062 572128 572448 573812 574858 578503 578865 579200 584108 587005 598554 598777 627135 655656 656345 778610 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская молодуха в розовой"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск молодая девушк в розов"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.