Query Metrics
7
Database Queries
7
Different statements
139.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.75 ms (85.61%) |
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 90979 190925 322014 381776 385165 388308 396173 396910 399662 401100 402547 407424 408383 417063 419707 419768 420566 421207 424401 424494 430297 443799 444732 446476 447458 448805 449091 450833 451469 454262 455241 456889 462526 462531 466765 467846 469069 469914 472316 480372 480474 484713 485270 485708 485918 486670 486672 489903 489906 490908 491871 492276 492511 492515 498030 498039 498054 498163 498252 501465 504405 506213 506522 506659 506803 507394 508780 508782 515119 515122 515285 516040 516445 519620 519622 519942 520028 524016 526025 531195 531236 533844 541589 541630 541639 541698 542196 546767 548584 550406 550432 553717 554386 558904 560153 560154 563489 565186 570725 573315 576648 586440 586468 586486 586503 586506 592532 604172 622317 622331 630260 641931 698933 730074 795437 803075 807704 808108 814748 814956 ] |
||||||||||||||||||||||||||||||
|
11.15 ms (7.97%) |
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 489903 560153 807704 402547 533844 508782 526025 498039 808108 508780 322014 419768 515285 498030 504405 396910 90979 449091 576648 190925 424494 515122 401100 469069 546767 586506 630260 803075 385165 490908 519620 622317 417063 492276 524016 516445 541639 466765 592532 560154 467846 396173 641931 480372 444732 446476 586503 519622 586486 480474 730074 419707 507394 408383 586440 506522 451469 489906 554386 814956 492511 565186 399662 381776 455241 454262 498163 407424 469914 430297 795437 498252 462531 541589 450833 550406 456889 506213 420566 486672 443799 485918 550432 506659 501465 814748 531195 586468 563489 498054 485708 462526 492515 520028 421207 388308 486670 573315 424401 447458 604172 558904 485270 531236 472316 548584 506803 484713 553717 622331 519942 448805 515119 570725 541630 516040 542196 541698 491871 698933 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.53%) |
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 90979 190925 322014 381776 385165 388308 396173 396910 399662 401100 402547 407424 408383 417063 419707 419768 420566 421207 424401 424494 430297 443799 444732 446476 447458 448805 449091 450833 451469 454262 455241 456889 462526 462531 466765 467846 469069 469914 472316 480372 480474 484713 485270 485708 485918 486670 486672 489903 489906 490908 491871 492276 492511 492515 498030 498039 498054 498163 498252 501465 504405 506213 506522 506659 506803 507394 508780 508782 515119 515122 515285 516040 516445 519620 519622 519942 520028 524016 526025 531195 531236 533844 541589 541630 541639 541698 542196 546767 548584 550406 550432 553717 554386 558904 560153 560154 563489 565186 570725 573315 576648 586440 586468 586486 586503 586506 592532 604172 622317 622331 630260 641931 698933 730074 795437 803075 807704 808108 814748 814956 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни в больниц"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс в медицин"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс в медицин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.09%) |
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.