Query Metrics
7
Database Queries
7
Different statements
154.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.20 ms (82.24%) |
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 75936 389062 397605 407562 420293 422243 423966 427359 428054 437305 441838 445112 450315 450563 450816 453021 453496 453512 453620 454973 455730 455757 458320 459098 459372 459899 460406 460757 460923 463173 464015 464545 466941 467835 467914 470504 476495 477715 479038 483367 485330 485980 488993 489285 491157 494592 499051 502600 503773 508163 509639 511083 513975 514301 517451 518828 525545 526642 526967 528707 548036 556436 559036 559038 562962 584048 589642 599550 618294 620438 622240 631322 654634 700611 702616 724592 726537 726556 726698 731004 733155 733481 734352 736285 744150 744156 744216 744831 750284 755600 756318 759763 763152 766236 768896 793713 793810 794506 796273 800152 801796 804398 804414 804579 810715 823598 824641 824642 824953 825065 825973 826060 826335 826448 826489 826594 826695 827308 827483 827711 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (11.76%) |
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 726698 459899 459098 731004 494592 599550 724592 826695 826448 463173 702616 460406 407562 476495 467835 589642 420293 518828 428054 548036 810715 511083 825065 744831 75936 389062 513975 654634 499051 503773 744156 750284 823598 454973 460923 445112 827483 397605 455757 464545 562962 793713 559038 459372 631322 733155 756318 450816 427359 824641 826060 826335 744216 491157 559036 824642 755600 441838 464015 458320 517451 526967 422243 526642 827308 827711 824953 825973 508163 479038 467914 485980 826489 733481 453021 804414 453496 509639 556436 453512 437305 759763 763152 804579 801796 450563 618294 584048 800152 477715 744150 489285 768896 793810 466941 528707 460757 450315 485330 423966 622240 766236 736285 470504 488993 525545 804398 794506 734352 726556 453620 620438 483367 826594 502600 514301 700611 726537 455730 796273 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.45%) |
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 75936 389062 397605 407562 420293 422243 423966 427359 428054 437305 441838 445112 450315 450563 450816 453021 453496 453512 453620 454973 455730 455757 458320 459098 459372 459899 460406 460757 460923 463173 464015 464545 466941 467835 467914 470504 476495 477715 479038 483367 485330 485980 488993 489285 491157 494592 499051 502600 503773 508163 509639 511083 513975 514301 517451 518828 525545 526642 526967 528707 548036 556436 559036 559038 562962 584048 589642 599550 618294 620438 622240 631322 654634 700611 702616 724592 726537 726556 726698 731004 733155 733481 734352 736285 744150 744156 744216 744831 750284 755600 756318 759763 763152 766236 768896 793713 793810 794506 796273 800152 801796 804398 804414 804579 810715 823598 824641 824642 824953 825065 825973 826060 826335 826448 826489 826594 826695 827308 827483 827711 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"полные домашнее куниÐ%…"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная домашн любительск куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
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.