Query Metrics
7
Database Queries
7
Different statements
164.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.52 ms (81.13%) |
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 388847 395973 397382 416086 417319 419720 423039 423263 423499 426997 428481 429952 431452 431687 443150 443312 444807 445835 447969 450226 456818 460209 463305 463884 463915 464916 465061 467306 467310 467934 468490 469745 472149 472891 475225 475454 475720 476176 476552 477069 478528 479492 479694 480425 483024 485336 486202 488477 489093 489820 489973 493220 493307 495066 496702 499481 503899 507939 509799 512857 512877 513412 514088 515058 517431 518577 519316 519690 530713 531133 532965 536264 538837 539280 543259 543850 543867 549106 553292 555872 559856 561024 565800 568475 580263 584940 591590 597251 598470 600382 603649 614186 625780 626538 636555 638416 640749 642359 648534 649147 650802 651913 663976 664459 665916 665923 666532 676095 678893 688666 696234 717924 720050 720872 731971 804487 806113 817115 818160 819530 ] |
||||||||||||||||||||||||||||||
|
18.52 ms (11.25%) |
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 580263 568475 663976 688666 600382 642359 625780 467934 450226 463305 469745 472149 472891 539280 513412 517431 488477 499481 388847 444807 443312 817115 818160 819530 477069 475720 468490 489973 493220 536264 515058 530713 531133 512877 489093 493307 543850 543867 648534 649147 650802 666532 664459 665923 676095 696234 720872 665916 678893 717924 720050 598470 640749 597251 638416 614186 591590 804487 806113 731971 636555 419720 429952 431452 475225 475454 416086 483024 489820 519690 514088 397382 431687 584940 426997 395973 423039 428481 423499 417319 463915 447969 456818 445835 479492 485336 495066 519316 507939 512857 518577 538837 503899 509799 496702 532965 460209 463884 464916 486202 549106 555872 553292 543259 565800 651913 559856 561024 626538 603649 423263 465061 467306 476176 479694 467310 443150 476552 478528 480425 ] |
||||||||||||||||||||||||||||||
|
5.69 ms (3.46%) |
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 388847 395973 397382 416086 417319 419720 423039 423263 423499 426997 428481 429952 431452 431687 443150 443312 444807 445835 447969 450226 456818 460209 463305 463884 463915 464916 465061 467306 467310 467934 468490 469745 472149 472891 475225 475454 475720 476176 476552 477069 478528 479492 479694 480425 483024 485336 486202 488477 489093 489820 489973 493220 493307 495066 496702 499481 503899 507939 509799 512857 512877 513412 514088 515058 517431 518577 519316 519690 530713 531133 532965 536264 538837 539280 543259 543850 543867 549106 553292 555872 559856 561024 565800 568475 580263 584940 591590 597251 598470 600382 603649 614186 625780 626538 636555 638416 640749 642359 648534 649147 650802 651913 663976 664459 665916 665923 666532 676095 678893 688666 696234 717924 720050 720872 731971 804487 806113 817115 818160 819530 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination anal"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination анал"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination анал"
]
|
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.