Query Metrics
7
Database Queries
7
Different statements
193.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.43 ms (85.34%) |
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 132341 383418 388036 389858 390165 391296 392902 392909 396403 397918 399088 401144 401216 409156 410781 413087 417336 417721 417723 417725 417727 417750 420200 423427 424606 438898 443167 443396 447275 453539 453620 453750 454550 457984 457985 458830 459457 460512 460770 461129 461144 464311 466861 469457 471012 471074 471077 471395 471411 471413 471416 472858 473886 474146 474878 476295 477296 480758 484079 494057 494060 495878 498731 504116 505910 520057 520218 523330 526751 526755 539504 541255 548231 557415 568383 569050 569053 569068 569110 569518 574457 581025 582944 590696 591032 591253 591694 592036 594467 597878 599713 602024 602632 603548 606162 606357 606424 606460 606590 606608 615542 619612 620491 621787 719887 724133 729256 750867 759570 766687 774028 774061 788178 794557 799007 800030 804168 808946 810466 812929 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (9.05%) |
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 620491 804168 388036 410781 132341 397918 409156 443396 424606 471074 471416 454550 460770 466861 471077 539504 498731 460512 469457 472858 557415 548231 568383 574457 619612 602632 800030 766687 774028 774061 391296 392902 396403 417727 417721 453620 458830 474146 520218 569053 591032 794557 799007 788178 812929 750867 729256 759570 808946 401144 420200 453539 606460 810466 392909 523330 494060 464311 569518 599713 401216 438898 459457 480758 471411 477296 526751 505910 541255 606424 606608 520057 390165 457984 471012 474878 526755 461129 494057 569050 569068 582944 719887 592036 602024 606162 606357 591694 597878 389858 471413 413087 471395 473886 495878 383418 417723 417725 447275 453750 603548 594467 590696 724133 417750 484079 443167 461144 581025 591253 399088 476295 569110 606590 621787 615542 417336 423427 457985 504116 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.73%) |
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 132341 383418 388036 389858 390165 391296 392902 392909 396403 397918 399088 401144 401216 409156 410781 413087 417336 417721 417723 417725 417727 417750 420200 423427 424606 438898 443167 443396 447275 453539 453620 453750 454550 457984 457985 458830 459457 460512 460770 461129 461144 464311 466861 469457 471012 471074 471077 471395 471411 471413 471416 472858 473886 474146 474878 476295 477296 480758 484079 494057 494060 495878 498731 504116 505910 520057 520218 523330 526751 526755 539504 541255 548231 557415 568383 569050 569053 569068 569110 569518 574457 581025 582944 590696 591032 591253 591694 592036 594467 597878 599713 602024 602632 603548 606162 606357 606424 606460 606590 606608 615542 619612 620491 621787 719887 724133 729256 750867 759570 766687 774028 774061 788178 794557 799007 800030 804168 808946 810466 812929 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск german xxx"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur german xxx"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск german xxx"
]
|
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.