Query Metrics
7
Database Queries
7
Different statements
157.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.65 ms (84.77%) |
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 14940 47220 70046 80089 86315 86926 87363 195888 196306 281801 305519 330409 373842 382851 387501 387534 387805 388028 388775 389288 390388 390629 390663 393310 393320 393509 396086 396541 396567 396596 396748 396843 396905 398435 400967 404555 405242 407523 409590 409701 417939 417998 419104 419917 422441 436418 442642 443368 452145 455069 457153 457671 459776 461397 467988 470141 471137 475165 476327 481589 482156 486151 488206 490691 500228 506279 508921 522407 529735 530815 531576 536268 539228 539400 539435 539624 540887 542850 542994 543911 549535 550309 557114 559574 566138 567031 585914 589030 605490 624884 625470 632892 635460 639364 639571 643406 647087 648497 650012 650336 681511 696732 698165 699191 716255 717211 717757 730306 734450 738316 752517 763511 763537 772927 776944 779992 780026 801638 805308 809574 ] |
||||||||||||||||||||||||||||||
|
13.34 ms (8.46%) |
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 557114 417939 467988 476327 442642 330409 648497 639571 388028 650336 716255 681511 730306 390388 481589 47220 393509 396596 455069 624884 549535 459776 539228 567031 776944 699191 506279 393310 400967 443368 470141 809574 80089 393320 530815 531576 539624 529735 539435 508921 539400 542994 550309 696732 717757 639364 589030 635460 407523 409590 305519 396843 540887 650012 643406 805308 734450 752517 738316 396905 70046 522407 387534 419917 559574 566138 436418 471137 422441 475165 452145 373842 404555 543911 195888 417998 647087 585914 801638 772927 382851 388775 396086 486151 542850 780026 632892 717211 87363 387501 14940 457153 405242 605490 763511 281801 419104 779992 409701 387805 482156 488206 625470 396567 196306 86315 86926 698165 763537 396748 390629 396541 389288 390663 461397 398435 490691 457671 500228 536268 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (2.05%) |
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 14940 47220 70046 80089 86315 86926 87363 195888 196306 281801 305519 330409 373842 382851 387501 387534 387805 388028 388775 389288 390388 390629 390663 393310 393320 393509 396086 396541 396567 396596 396748 396843 396905 398435 400967 404555 405242 407523 409590 409701 417939 417998 419104 419917 422441 436418 442642 443368 452145 455069 457153 457671 459776 461397 467988 470141 471137 475165 476327 481589 482156 486151 488206 490691 500228 506279 508921 522407 529735 530815 531576 536268 539228 539400 539435 539624 540887 542850 542994 543911 549535 550309 557114 559574 566138 567031 585914 589030 605490 624884 625470 632892 635460 639364 639571 643406 647087 648497 650012 650336 681511 696732 698165 699191 716255 717211 717757 730306 734450 738316 752517 763511 763537 772927 776944 779992 780026 801638 805308 809574 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой отсос"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.