Query Metrics
7
Database Queries
7
Different statements
173.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.58 ms (84.34%) |
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 396415 397524 398719 402807 403215 414968 415829 416585 421725 423706 423707 427115 429602 432270 434314 434349 435131 435171 439156 441080 449305 449322 451118 458435 459212 459745 460323 460813 461262 471939 472066 475140 475755 478055 479008 483704 485247 492648 496301 498630 504474 505101 507626 511348 513330 517798 518643 531062 533276 533389 537856 539370 541757 546534 547734 547762 555449 556902 561495 567737 581296 593615 604909 605742 618394 624841 625753 631604 636414 639645 664972 666511 666680 666888 677843 680242 682911 695882 699538 704152 711771 712286 714126 720235 728465 734276 734860 736033 736349 736725 756992 763724 764081 768890 778892 780162 783108 783928 784125 784868 786604 786658 792223 795012 797037 800663 800884 801041 803089 805336 807011 808641 809009 812050 812310 812336 816163 818557 820186 827541 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (9.72%) |
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 734860 797037 800663 801041 805336 624841 764081 475755 533276 513330 666680 695882 712286 720235 714126 677843 783108 786658 795012 812310 783928 736349 784125 812050 402807 432270 429602 416585 434349 414968 434314 423706 449322 451118 458435 460323 479008 459745 511348 504474 485247 547762 547734 680242 664972 711771 604909 631604 786604 809009 812336 807011 728465 625753 800884 808641 403215 427115 461262 472066 415829 435171 441080 459212 460813 475140 483704 498630 517798 492648 539370 567737 593615 507626 792223 449305 518643 531062 561495 541757 618394 636414 605742 763724 435131 439156 421725 768890 478055 471939 496301 505101 396415 397524 398719 423707 827541 818557 816163 820186 533389 537856 555449 546534 556902 581296 666888 682911 666511 704152 699538 639645 778892 780162 784868 803089 734276 736033 736725 756992 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.65%) |
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 396415 397524 398719 402807 403215 414968 415829 416585 421725 423706 423707 427115 429602 432270 434314 434349 435131 435171 439156 441080 449305 449322 451118 458435 459212 459745 460323 460813 461262 471939 472066 475140 475755 478055 479008 483704 485247 492648 496301 498630 504474 505101 507626 511348 513330 517798 518643 531062 533276 533389 537856 539370 541757 546534 547734 547762 555449 556902 561495 567737 581296 593615 604909 605742 618394 624841 625753 631604 636414 639645 664972 666511 666680 666888 677843 680242 682911 695882 699538 704152 711771 712286 714126 720235 728465 734276 734860 736033 736349 736725 756992 763724 764081 768890 778892 780162 783108 783928 784125 784868 786604 786658 792223 795012 797037 800663 800884 801041 803089 805336 807011 808641 809009 812050 812310 812336 816163 818557 820186 827541 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife squirt"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.84%) |
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.