Query Metrics
7
Database Queries
7
Different statements
204.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.77 ms (87.93%) |
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 70186 221320 382488 386821 393339 398019 405584 409867 419038 428405 431897 433384 437265 444984 456554 457061 457373 458183 483421 501618 514079 514247 517455 520166 522154 522333 523303 524020 525073 526805 527581 528513 528854 529866 529882 530299 530609 531267 531268 531324 531526 531669 531945 531955 532677 532891 534716 539003 539630 540657 540972 542662 543049 543914 553252 554148 561571 568559 569772 579073 581655 584130 602709 615975 621875 638505 660933 669224 669636 674590 682987 696091 706260 708064 710066 715688 723425 723993 724814 726397 730554 730980 732028 734062 737353 737486 738856 739670 740043 744640 745249 747264 748948 753957 756920 759501 759889 760775 760868 762426 762670 769250 771379 781170 783523 789000 797722 799739 800037 808876 811334 818587 822252 823469 824980 826549 827991 828337 828367 828794 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (6.94%) |
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 522333 531267 534716 501618 520166 528513 528854 522154 523303 524020 530609 531955 483421 543914 553252 561571 584130 568559 569772 581655 543049 554148 696091 723425 669224 579073 781170 740043 753957 756920 799739 800037 811334 744640 760775 723993 771379 745249 748948 759889 762426 621875 710066 715688 419038 525073 70186 433384 818587 822252 823469 824980 826549 828794 828367 828337 827991 529866 531268 531526 531945 532891 539630 514247 530299 539003 527581 529882 531324 531669 540972 542662 660933 706260 708064 669636 674590 682987 638505 602709 808876 783523 724814 760868 769250 797722 730980 734062 739670 762670 747264 730554 732028 737353 759501 726397 737486 738856 789000 221320 615975 456554 514079 532677 540657 517455 526805 458183 386821 393339 382488 398019 405584 409867 428405 444984 437265 431897 457061 457373 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.68%) |
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 70186 221320 382488 386821 393339 398019 405584 409867 419038 428405 431897 433384 437265 444984 456554 457061 457373 458183 483421 501618 514079 514247 517455 520166 522154 522333 523303 524020 525073 526805 527581 528513 528854 529866 529882 530299 530609 531267 531268 531324 531526 531669 531945 531955 532677 532891 534716 539003 539630 540657 540972 542662 543049 543914 553252 554148 561571 568559 569772 579073 581655 584130 602709 615975 621875 638505 660933 669224 669636 674590 682987 696091 706260 708064 710066 715688 723425 723993 724814 726397 730554 730980 732028 734062 737353 737486 738856 739670 740043 744640 745249 747264 748948 753957 756920 759501 759889 760775 760868 762426 762670 769250 771379 781170 783523 789000 797722 799739 800037 808876 811334 818587 822252 823469 824980 826549 827991 828337 828367 828794 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хер"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
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.