Query Metrics
7
Database Queries
7
Different statements
155.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.33 ms (84.41%) |
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 397104 397432 397523 407654 416138 429050 432778 432803 435177 441420 441495 441503 448636 449053 455897 456207 457380 459635 459686 460773 461306 469162 471554 475472 484318 488238 488239 489271 491588 492948 493417 493573 498163 505803 507253 508560 509123 509600 510001 510230 511357 511481 511868 515003 524319 527874 532104 538266 542886 545598 546573 559999 561388 564358 570676 578246 579469 580210 580423 581064 584955 585296 586589 588661 591742 592399 592614 602580 603824 603833 604706 606697 607928 609582 611348 613849 618021 618133 618364 623339 627013 632096 632114 634600 637802 653866 653888 658222 677899 683332 695900 696081 697885 720828 736470 740871 741656 742320 742861 743068 752613 754140 754160 757394 759673 759961 761048 765493 765514 766996 772419 777742 787506 788893 796165 797060 797394 802053 803722 805502 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (9.58%) |
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 754140 459686 618021 532104 653888 653866 586589 607928 592399 592614 637802 623339 632114 493573 515003 559999 697885 441503 484318 469162 471554 546573 564358 545598 580423 777742 797394 805502 742861 765514 759673 772419 797060 397523 460773 397432 448636 507253 561388 581064 720828 618133 585296 796165 802053 803722 757394 759961 752613 787506 441420 456207 407654 602580 606697 498163 491588 509123 509600 524319 542886 578246 580210 658222 696081 683332 695900 611348 603824 603833 613849 618364 588661 591742 627013 632096 538266 489271 492948 511868 505803 511357 510001 455897 579469 570676 677899 736470 432803 435177 432778 510230 488239 493417 527874 397104 416138 429050 441495 449053 461306 457380 459635 475472 488238 508560 511481 584955 604706 609582 634600 788893 740871 742320 754160 761048 741656 743068 765493 766996 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.81%) |
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 397104 397432 397523 407654 416138 429050 432778 432803 435177 441420 441495 441503 448636 449053 455897 456207 457380 459635 459686 460773 461306 469162 471554 475472 484318 488238 488239 489271 491588 492948 493417 493573 498163 505803 507253 508560 509123 509600 510001 510230 511357 511481 511868 515003 524319 527874 532104 538266 542886 545598 546573 559999 561388 564358 570676 578246 579469 580210 580423 581064 584955 585296 586589 588661 591742 592399 592614 602580 603824 603833 604706 606697 607928 609582 611348 613849 618021 618133 618364 623339 627013 632096 632114 634600 637802 653866 653888 658222 677899 683332 695900 696081 697885 720828 736470 740871 741656 742320 742861 743068 752613 754140 754160 757394 759673 759961 761048 765493 765514 766996 772419 777742 787506 788893 796165 797060 797394 802053 803722 805502 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur screaming"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.