Query Metrics
7
Database Queries
7
Different statements
170.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.14 ms (83.87%) |
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 12710 382950 384233 385589 394335 395320 395751 395913 396806 398916 399255 400466 401091 404352 404935 408987 411954 413114 413468 418803 419490 422576 422881 423283 423412 425714 427230 445933 447448 447913 448697 454861 456885 458058 460459 463134 463298 470842 472249 475588 478864 479560 481288 482624 487370 490791 494697 495270 503944 504456 504744 510022 511725 515109 515182 515245 516618 518316 519227 520008 521989 528340 532153 534713 542469 557272 558417 567761 569689 569692 569933 570073 576082 586761 603957 621620 624850 628303 645003 665431 665883 668894 669443 672767 676924 677697 680036 694600 702396 704010 708823 709881 714390 716264 720462 722114 722654 722917 732421 742249 743063 743116 744313 744337 754216 759662 774109 775781 788734 789038 789304 793642 800373 803083 814065 815780 817677 819563 822137 823802 ] |
||||||||||||||||||||||||||||||
|
17.86 ms (10.46%) |
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 732421 743116 570073 395913 395751 401091 12710 534713 720462 603957 396806 569689 460459 472249 418803 487370 694600 422576 423283 445933 558417 423412 422881 495270 504456 404352 478864 494697 722917 557272 413114 427230 481288 463134 528340 408987 815780 823802 665883 714390 722114 628303 789038 742249 621620 394335 382950 399255 413468 425714 542469 490791 384233 470842 624850 576082 447913 567761 516618 411954 447448 385589 665431 754216 744313 817677 814065 515245 722654 789304 774109 803083 759662 456885 511725 569692 448697 515109 532153 702396 668894 677697 743063 404935 569933 479560 475588 510022 672767 704010 819563 822137 680036 709881 520008 800373 482624 419490 400466 519227 645003 515182 503944 504744 788734 395320 454861 518316 793642 398916 676924 669443 708823 744337 716264 775781 463298 521989 458058 586761 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.62%) |
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 12710 382950 384233 385589 394335 395320 395751 395913 396806 398916 399255 400466 401091 404352 404935 408987 411954 413114 413468 418803 419490 422576 422881 423283 423412 425714 427230 445933 447448 447913 448697 454861 456885 458058 460459 463134 463298 470842 472249 475588 478864 479560 481288 482624 487370 490791 494697 495270 503944 504456 504744 510022 511725 515109 515182 515245 516618 518316 519227 520008 521989 528340 532153 534713 542469 557272 558417 567761 569689 569692 569933 570073 576082 586761 603957 621620 624850 628303 645003 665431 665883 668894 669443 672767 676924 677697 680036 694600 702396 704010 708823 709881 714390 716264 720462 722114 722654 722917 732421 742249 743063 743116 744313 744337 754216 759662 774109 775781 788734 789038 789304 793642 800373 803083 814065 815780 817677 819563 822137 823802 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
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.