Query Metrics
7
Database Queries
7
Different statements
163.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.24 ms (84.12%) |
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 383635 387937 389167 391079 396191 401235 405712 406558 415184 415199 417741 418290 419001 421130 421592 423424 425582 429570 431210 433481 437516 443910 445947 445951 447893 454119 455603 456409 458675 458833 461948 463267 463977 464922 469648 470242 475119 477422 482353 482570 484836 488100 488709 490070 491488 492002 494127 496098 497958 500425 502325 503044 503915 509855 510869 511295 513954 515906 515924 517461 518369 524460 524520 525203 525838 527793 528470 531145 533012 533929 534670 535918 536864 539420 542566 545747 546979 551119 555123 555133 555144 558802 569211 570179 575709 581091 584724 585102 588971 590259 590623 591545 592313 599974 604060 604360 620230 620246 620252 622925 648593 663789 672743 679818 696518 697945 704561 709407 729920 733886 754530 759488 760958 782091 787427 788608 789398 809668 815019 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (10.10%) |
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 445951 454119 456409 389167 445947 396191 488709 527793 515906 494127 524520 525838 510869 555144 458675 419001 488100 648593 546979 591545 590259 447893 502325 421592 497958 525203 406558 500425 604360 787427 458833 620230 729920 809668 470242 391079 592313 590623 437516 443910 815019 475119 704561 696518 622925 490070 528470 581091 555133 620252 496098 524460 383635 585102 511295 531145 555123 663789 679818 782091 401235 415184 415199 534670 387937 433481 417741 463267 535918 518369 477422 709407 482353 418290 429570 461948 513954 491488 492002 558802 788608 533012 570179 588971 503915 484836 431210 828391 463977 464922 539420 759488 672743 536864 789398 754530 604060 584724 575709 697945 503044 517461 515924 469648 405712 423424 620246 733886 509855 599974 533929 545747 760958 421130 551119 569211 425582 455603 482570 542566 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.48%) |
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 383635 387937 389167 391079 396191 401235 405712 406558 415184 415199 417741 418290 419001 421130 421592 423424 425582 429570 431210 433481 437516 443910 445947 445951 447893 454119 455603 456409 458675 458833 461948 463267 463977 464922 469648 470242 475119 477422 482353 482570 484836 488100 488709 490070 491488 492002 494127 496098 497958 500425 502325 503044 503915 509855 510869 511295 513954 515906 515924 517461 518369 524460 524520 525203 525838 527793 528470 531145 533012 533929 534670 535918 536864 539420 542566 545747 546979 551119 555123 555133 555144 558802 569211 570179 575709 581091 584724 585102 588971 590259 590623 591545 592313 599974 604060 604360 620230 620246 620252 622925 648593 663789 672743 679818 696518 697945 704561 709407 729920 733886 754530 759488 760958 782091 787427 788608 789398 809668 815019 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex small"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.