Query Metrics
7
Database Queries
7
Different statements
191.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.45 ms (84.32%) |
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 16851 395750 422187 422261 422286 423517 426701 433323 433977 435941 437582 441629 442410 447262 449720 450171 455957 458795 460370 461613 463630 466074 475575 481360 483569 488867 489634 493280 493402 497372 504927 504929 506131 513084 513118 513398 513876 516094 516923 517711 518781 519845 521355 521520 522215 522992 524613 524944 525253 528215 528815 529651 537123 537481 538002 542739 542792 546722 546771 551572 553303 554872 557776 561056 562398 562719 564696 567074 569921 570842 570875 572916 584516 588249 590856 593876 595054 595639 600279 601141 603705 603842 604304 604805 605663 606776 616091 620500 621179 623650 625860 642556 644917 653594 659986 667757 674269 690851 702125 749936 750725 752868 771749 772399 775976 779012 785145 785397 791679 791943 792423 797464 798443 803846 805832 811770 812821 813246 813265 822654 ] |
||||||||||||||||||||||||||||||
|
18.62 ms (9.72%) |
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 620500 437582 595639 395750 423517 519845 528815 553303 557776 569921 564696 606776 625860 812821 772399 528215 475575 567074 463630 516923 537481 603842 481360 518781 506131 516094 561056 822654 623650 752868 433977 521355 422261 422286 785145 811770 791679 805832 813246 616091 600279 441629 455957 813265 447262 489634 522215 690851 458795 524613 504927 584516 435941 546771 551572 674269 572916 593876 604304 798443 750725 749936 644917 449720 497372 542792 785397 779012 524944 483569 771749 659986 605663 433323 460370 513118 513084 488867 570875 522992 562719 595054 603705 797464 461613 521520 590856 570842 554872 667757 653594 642556 604805 792423 426701 16851 450171 422187 513398 442410 702125 513876 466074 493402 621179 529651 504929 542739 546722 562398 601141 791943 803846 775976 517711 538002 525253 537123 588249 493280 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom дрочк член домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.70 ms (1.41%) |
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 16851 395750 422187 422261 422286 423517 426701 433323 433977 435941 437582 441629 442410 447262 449720 450171 455957 458795 460370 461613 463630 466074 475575 481360 483569 488867 489634 493280 493402 497372 504927 504929 506131 513084 513118 513398 513876 516094 516923 517711 518781 519845 521355 521520 522215 522992 524613 524944 525253 528215 528815 529651 537123 537481 538002 542739 542792 546722 546771 551572 553303 554872 557776 561056 562398 562719 564696 567074 569921 570842 570875 572916 584516 588249 590856 593876 595054 595639 600279 601141 603705 603842 604304 604805 605663 606776 616091 620500 621179 623650 625860 642556 644917 653594 659986 667757 674269 690851 702125 749936 750725 752868 771749 772399 775976 779012 785145 785397 791679 791943 792423 797464 798443 803846 805832 811770 812821 813246 813265 822654 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom handjob homemade"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom дрочк член домашн любительск"
]
|
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.