Query Metrics
7
Database Queries
7
Different statements
183.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.45 ms (86.68%) |
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 52454 278442 372986 373048 384384 384865 396400 401559 413485 413542 456039 458199 458584 459222 461891 468554 468761 470288 471188 475166 484299 484374 486664 490708 492275 494715 497284 499414 503323 504259 504355 504603 510103 520949 525471 528460 529427 559586 559619 566491 574190 584663 584691 592566 593212 595864 597172 599410 599826 602712 605936 608092 609613 610601 610603 610722 614527 614694 617009 617716 621508 622037 625069 628347 630279 640868 649019 649066 650346 650359 650363 662429 662456 663341 672402 673081 673143 673150 674905 682460 687854 688172 689672 689735 694362 695656 698983 706476 718904 719127 728415 738463 738957 740049 775022 778200 779334 779384 785179 785978 788440 789661 789922 791363 793901 798696 798867 798971 798973 798977 798978 798980 798981 798984 798995 807313 809895 817495 822593 826882 ] |
||||||||||||||||||||||||||||||
|
13.40 ms (7.28%) |
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 719127 574190 662429 788440 628347 706476 775022 650359 490708 384384 694362 592566 673081 807313 625069 497284 503323 798867 486664 673143 459222 793901 682460 456039 458199 470288 559619 826882 384865 640868 595864 468554 510103 650363 798696 673150 584663 779384 610601 413542 614527 52454 798980 662456 617716 798973 689735 798995 785179 649019 689672 559586 525471 809895 529427 798981 605936 396400 373048 798984 791363 779334 672402 372986 798977 475166 649066 630279 785978 688172 789922 798971 798978 597172 738463 458584 778200 608092 584691 484299 650346 599826 610722 621508 698983 609613 674905 602712 738957 471188 504355 728415 494715 528460 499414 593212 789661 663341 718904 520949 599410 622037 461891 695656 468761 504603 817495 484374 401559 740049 278442 822593 566491 687854 614694 617009 413485 610603 504259 492275 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (2.26%) |
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 52454 278442 372986 373048 384384 384865 396400 401559 413485 413542 456039 458199 458584 459222 461891 468554 468761 470288 471188 475166 484299 484374 486664 490708 492275 494715 497284 499414 503323 504259 504355 504603 510103 520949 525471 528460 529427 559586 559619 566491 574190 584663 584691 592566 593212 595864 597172 599410 599826 602712 605936 608092 609613 610601 610603 610722 614527 614694 617009 617716 621508 622037 625069 628347 630279 640868 649019 649066 650346 650359 650363 662429 662456 663341 672402 673081 673143 673150 674905 682460 687854 688172 689672 689735 694362 695656 698983 706476 718904 719127 728415 738463 738957 740049 775022 778200 779334 779384 785179 785978 788440 789661 789922 791363 793901 798696 798867 798971 798973 798977 798978 798980 798981 798984 798995 807313 809895 817495 822593 826882 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex taxi"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в такс машин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
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.