Query Metrics
7
Database Queries
7
Different statements
193.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.78 ms (86.36%) |
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 11582 154463 386813 387301 391027 400878 400932 414048 415203 416600 417075 417839 417841 418825 423464 424174 424556 424995 430801 439109 439325 439463 443335 444099 444470 444638 446943 447079 447526 447557 448065 448317 448320 448560 454091 457406 459666 462623 464910 466104 468122 469782 476148 479726 485575 486391 489573 497941 498544 498649 501533 503203 508224 515339 518217 518233 519187 519690 521970 522468 523064 536819 536835 541274 546665 558132 560416 567335 575170 575810 576412 577068 577376 577520 577544 577816 591468 596228 600382 607021 607315 611322 621648 622400 624375 627635 628865 630081 637520 641638 642359 649163 649576 650158 650802 653549 676024 677295 687339 690153 695262 695831 703089 705160 708444 708714 720401 721088 721579 723492 724139 737153 738786 748053 758072 763437 765807 786526 804756 814246 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (8.30%) |
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 650158 386813 11582 439463 443335 454091 497941 523064 498544 567335 653549 596228 622400 607315 591468 607021 423464 417839 457406 466104 417075 447557 676024 154463 418825 444099 448560 459666 464910 476148 501533 577376 708444 649576 546665 577520 637520 627635 765807 400878 415203 424556 444470 448065 536819 503203 518217 521970 387301 417841 430801 439109 814246 508224 541274 560416 650802 687339 695262 695831 708714 721579 720401 641638 628865 804756 748053 737153 724139 738786 721088 723492 786526 424174 448317 519690 519187 400932 424995 414048 690153 448320 518233 515339 468122 479726 577816 649163 705160 577068 621648 758072 763437 611322 630081 703089 416600 444638 469782 391027 462623 446943 439325 447526 522468 485575 486391 498649 489573 576412 575810 536835 577544 575170 677295 558132 600382 624375 642359 447079 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.75%) |
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 11582 154463 386813 387301 391027 400878 400932 414048 415203 416600 417075 417839 417841 418825 423464 424174 424556 424995 430801 439109 439325 439463 443335 444099 444470 444638 446943 447079 447526 447557 448065 448317 448320 448560 454091 457406 459666 462623 464910 466104 468122 469782 476148 479726 485575 486391 489573 497941 498544 498649 501533 503203 508224 515339 518217 518233 519187 519690 521970 522468 523064 536819 536835 541274 546665 558132 560416 567335 575170 575810 576412 577068 577376 577520 577544 577816 591468 596228 600382 607021 607315 611322 621648 622400 624375 627635 628865 630081 637520 641638 642359 649163 649576 650158 650802 653549 676024 677295 687339 690153 695262 695831 703089 705160 708444 708714 720401 721088 721579 723492 724139 737153 738786 748053 758072 763437 765807 786526 804756 814246 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen fucking анал"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen fucking anal"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen fucking анал"
]
|
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.