Query Metrics
7
Database Queries
7
Different statements
215.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.42 ms (85.14%) |
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 359089 386371 389610 391697 404485 410807 417063 422357 422802 425495 427623 432081 438712 440156 442348 445946 445954 450485 451154 454609 455772 455917 458721 459620 466288 469819 471836 473054 478020 484140 484226 485008 487351 490645 491025 491901 493098 493584 500519 500712 501615 502033 503891 504162 504321 505528 506935 506976 514032 518153 518482 518909 519496 520028 521485 526214 526754 526757 528212 528261 539607 549639 553107 553321 554448 555984 564461 565205 570207 577917 579445 593069 593531 594215 595419 598150 599670 602692 606436 624854 628727 641418 668374 669332 692051 693926 696230 709458 715291 718496 718996 719524 722718 725793 726712 726713 733498 735544 748997 751435 770867 784417 784791 785330 792556 793296 793640 794424 800009 800215 801167 802723 808527 817100 818717 819759 823185 824320 827326 828421 ] |
||||||||||||||||||||||||||||||
|
21.88 ms (10.16%) |
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 471836 438712 469819 501615 595419 733498 473054 445954 455917 391697 484140 478020 669332 593069 598150 425495 823185 490645 505528 817100 792556 641418 793640 722718 410807 454609 484226 386371 389610 404485 427623 819759 458721 748997 526214 520028 359089 827326 445946 579445 709458 794424 503891 514032 491901 553321 718496 784417 504321 521485 504162 518153 487351 493098 518482 539607 554448 599670 593531 785330 802723 808527 726713 726712 751435 518909 519496 828421 493584 455772 502033 526754 577917 628727 440156 528261 506976 526757 417063 624854 500519 500712 565205 594215 450485 692051 451154 693926 422802 491025 824320 570207 553107 715291 793296 801167 784791 459620 466288 432081 770867 725793 549639 555984 602692 528212 818717 719524 668374 696230 800009 735544 800215 718996 442348 564461 606436 422357 506935 485008 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (0.98%) |
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 359089 386371 389610 391697 404485 410807 417063 422357 422802 425495 427623 432081 438712 440156 442348 445946 445954 450485 451154 454609 455772 455917 458721 459620 466288 469819 471836 473054 478020 484140 484226 485008 487351 490645 491025 491901 493098 493584 500519 500712 501615 502033 503891 504162 504321 505528 506935 506976 514032 518153 518482 518909 519496 520028 521485 526214 526754 526757 528212 528261 539607 549639 553107 553321 554448 555984 564461 565205 570207 577917 579445 593069 593531 594215 595419 598150 599670 602692 606436 624854 628727 641418 668374 669332 692051 693926 696230 709458 715291 718496 718996 719524 722718 725793 726712 726713 733498 735544 748997 751435 770867 784417 784791 785330 792556 793296 793640 794424 800009 800215 801167 802723 808527 817100 818717 819759 823185 824320 827326 828421 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy big tits"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.81%) |
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.