Query Metrics
7
Database Queries
7
Different statements
146.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.99 ms (82.03%) |
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 7092 152544 162000 187704 187843 238125 265654 266061 282038 289778 302771 310672 340567 365908 389623 390629 391519 393855 396941 396957 401000 403806 423433 424124 424436 424441 425999 426567 427086 428102 433888 437988 440569 441644 443135 443784 443808 448580 449296 451500 451528 451787 452081 452240 454175 454223 454237 454478 457010 461025 463825 466042 466226 466904 470201 470207 470296 470309 472889 475080 476961 481188 481957 482534 483607 486015 489169 491771 491964 491975 498019 502029 506047 507487 508246 512347 515262 517687 519582 522616 524177 526213 528507 528528 533741 549246 550232 551111 563020 563165 564363 564791 593418 603264 605296 646105 663443 665270 667209 669742 709623 715573 716078 741143 745806 748227 748244 748463 769494 781796 789215 794828 797271 797275 797685 803008 810606 826278 826480 828449 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (10.18%) |
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 466904 665270 781796 794828 507487 187843 266061 472889 391519 441644 289778 481957 741143 491975 826480 396957 549246 152544 826278 457010 748463 476961 454223 427086 498019 470309 433888 667209 593418 466042 483607 451500 491771 563020 451787 426567 451528 443808 486015 466226 443784 454478 515262 238125 797275 424124 810606 389623 491964 828449 423433 463825 470201 424441 425999 470207 502029 7092 522616 443135 396941 519582 424436 481188 506047 470296 508246 365908 340567 646105 461025 265654 437988 564791 390629 428102 452240 709623 715573 789215 769494 663443 669742 187704 440569 162000 716078 393855 401000 449296 454175 403806 452081 797685 454237 282038 482534 489169 533741 517687 564363 512347 448580 524177 605296 551111 748227 528507 528528 310672 745806 302771 803008 797271 475080 526213 563165 550232 603264 748244 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.91%) |
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 7092 152544 162000 187704 187843 238125 265654 266061 282038 289778 302771 310672 340567 365908 389623 390629 391519 393855 396941 396957 401000 403806 423433 424124 424436 424441 425999 426567 427086 428102 433888 437988 440569 441644 443135 443784 443808 448580 449296 451500 451528 451787 452081 452240 454175 454223 454237 454478 457010 461025 463825 466042 466226 466904 470201 470207 470296 470309 472889 475080 476961 481188 481957 482534 483607 486015 489169 491771 491964 491975 498019 502029 506047 507487 508246 512347 515262 517687 519582 522616 524177 526213 528507 528528 533741 549246 550232 551111 563020 563165 564363 564791 593418 603264 605296 646105 663443 665270 667209 669742 709623 715573 716078 741143 745806 748227 748244 748463 769494 781796 789215 794828 797271 797275 797685 803008 810606 826278 826480 828449 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная чулк нижн бел куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"полные в чулках кунилингус"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
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.