Query Metrics
7
Database Queries
7
Different statements
217.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.97 ms (86.01%) |
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 396190 398932 411309 417403 422236 425562 426869 428647 434230 434248 437295 439682 440683 441519 441559 441579 443178 443761 443926 444135 444145 444291 444919 451498 454231 455004 455727 460543 460704 461480 461693 461787 464072 466248 466368 467845 469128 470513 471672 472582 473908 474056 474236 475174 475185 476490 476930 478377 479059 479115 479755 480906 481597 482952 483184 483867 484686 485377 485618 486879 487381 487702 488432 488433 489105 489942 490088 492373 492687 494933 494964 495226 495990 496249 496828 497206 497828 498188 500386 502748 504001 504200 504799 505779 506209 506440 507265 507542 508047 508393 509628 510121 510763 511722 512231 512593 513676 520057 520796 521083 522327 522517 523843 526865 528142 544163 556482 557939 559063 568164 573037 604217 673006 696985 707518 742777 754237 761840 797461 813532 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (8.33%) |
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 512231 441519 494933 496249 604217 476490 437295 466248 478377 508047 526865 495990 396190 504200 754237 761840 398932 474056 521083 522517 500386 483184 797461 742777 422236 461480 511722 492373 512593 485618 474236 461693 461787 444291 472582 528142 510763 496828 482952 494964 505779 485377 488433 520796 489942 696985 707518 573037 434248 440683 509628 507542 506209 451498 479115 444145 502748 441559 556482 522327 506440 426869 568164 544163 673006 441579 455004 460704 481597 470513 425562 428647 434230 471672 443178 460543 469128 523843 487381 443926 492687 411309 444135 443761 504799 510121 479755 417403 466368 489105 497828 490088 557939 454231 498188 467845 559063 444919 475185 464072 480906 495226 497206 483867 486879 488432 813532 439682 507265 475174 476930 455727 473908 520057 504001 508393 487702 513676 484686 479059 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.40%) |
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 396190 398932 411309 417403 422236 425562 426869 428647 434230 434248 437295 439682 440683 441519 441559 441579 443178 443761 443926 444135 444145 444291 444919 451498 454231 455004 455727 460543 460704 461480 461693 461787 464072 466248 466368 467845 469128 470513 471672 472582 473908 474056 474236 475174 475185 476490 476930 478377 479059 479115 479755 480906 481597 482952 483184 483867 484686 485377 485618 486879 487381 487702 488432 488433 489105 489942 490088 492373 492687 494933 494964 495226 495990 496249 496828 497206 497828 498188 500386 502748 504001 504200 504799 505779 506209 506440 507265 507542 508047 508393 509628 510121 510763 511722 512231 512593 513676 520057 520796 521083 522327 522517 523843 526865 528142 544163 556482 557939 559063 568164 573037 604217 673006 696985 707518 742777 754237 761840 797461 813532 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск пышн"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс русск пышн"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.