Query Metrics
7
Database Queries
7
Different statements
193.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.98 ms (86.43%) |
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 124361 382724 385528 388712 390929 396954 398467 406063 406288 407722 407760 407810 409408 411291 411721 411756 411769 411923 413454 414019 445669 446249 446853 446867 448620 453113 453143 454267 458118 459830 460331 460332 464321 466885 466970 469317 470388 474410 474864 474871 476338 479690 485716 486821 487913 496346 496547 499274 512046 512993 516138 518854 525488 525493 525495 544488 545769 562596 580088 583527 587207 591285 608345 621400 623477 624790 629837 649527 651621 663895 665115 665195 665359 665364 665476 665499 665508 665867 666754 666804 667288 667669 668901 669752 678766 696309 696311 698428 710127 712314 712809 725368 728328 741016 744232 754133 758441 770114 770115 772883 776312 779198 780670 781646 781657 781699 781782 782203 782256 782268 782281 788481 789215 789407 792097 800571 807998 817393 825238 825241 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (8.35%) |
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 770115 466970 583527 741016 396954 470388 388712 728328 466885 453113 469317 608345 825238 817393 665115 665195 665499 621400 789215 779198 780670 781657 789407 754133 623477 782256 776312 411291 409408 485716 665508 698428 649527 781782 725368 807998 545769 385528 499274 460332 382724 669752 666804 474864 782281 587207 665476 666754 667669 712809 800571 414019 667288 411923 458118 459830 781646 512046 518854 512993 663895 591285 486821 496346 562596 479690 782268 744232 413454 407760 464321 496547 525493 580088 390929 454267 825241 665867 665359 665364 782203 770114 406288 525495 516138 445669 446853 460331 758441 624790 446867 448620 124361 406063 446249 668901 651621 678766 629837 792097 781699 788481 772883 712314 411721 525488 544488 411756 487913 474410 411769 407810 696309 696311 710127 398467 407722 474871 453143 476338 ] |
||||||||||||||||||||||||||||||
|
2.85 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 124361 382724 385528 388712 390929 396954 398467 406063 406288 407722 407760 407810 409408 411291 411721 411756 411769 411923 413454 414019 445669 446249 446853 446867 448620 453113 453143 454267 458118 459830 460331 460332 464321 466885 466970 469317 470388 474410 474864 474871 476338 479690 485716 486821 487913 496346 496547 499274 512046 512993 516138 518854 525488 525493 525495 544488 545769 562596 580088 583527 587207 591285 608345 621400 623477 624790 629837 649527 651621 663895 665115 665195 665359 665364 665476 665499 665508 665867 666754 666804 667288 667669 668901 669752 678766 696309 696311 698428 710127 712314 712809 725368 728328 741016 744232 754133 758441 770114 770115 772883 776312 779198 780670 781646 781657 781699 781782 782203 782256 782268 782281 788481 789215 789407 792097 800571 807998 817393 825238 825241 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old granny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old granny blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old granny минет оральн секс"
]
|
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.