Query Metrics
7
Database Queries
7
Different statements
154.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.90 ms (85.43%) |
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 399473 416288 417308 419490 424741 425832 435735 444935 447913 454840 456201 456630 459378 462275 462959 470716 475122 477415 488203 491750 503953 503962 504765 504770 506665 517144 518913 552534 557983 564432 564440 565044 565046 565286 565617 566886 568283 568440 571464 571468 574589 575726 581206 585747 589786 593212 599410 601291 609746 610608 611349 620275 621288 623855 624214 624216 624237 644078 673063 673092 673127 675370 681400 682211 687205 687541 689315 689340 689693 690032 696929 697298 698302 699056 699142 699338 699347 699359 699796 699798 701846 702838 703193 703678 703897 704010 705624 706293 706673 706985 706997 707011 712021 712025 713618 715218 715228 715231 715319 715323 719698 719703 719716 719719 725943 729673 730821 741494 752165 755749 757891 762248 764754 765904 766644 776396 790168 794126 799402 814128 ] |
||||||||||||||||||||||||||||||
|
12.15 ms (7.87%) |
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 503953 477415 673127 699142 715228 689340 699359 701846 706293 715218 682211 690032 707011 565286 794126 755749 730821 764754 752165 729673 725943 741494 757891 762248 611349 703678 712025 715319 704010 454840 456630 564432 673063 699796 719698 697298 719719 696929 706997 624237 790168 424741 447913 491750 575726 698302 571468 462959 475122 399473 470716 506665 624214 456201 488203 568283 435735 589786 417308 504770 719703 719716 675370 715231 699798 706673 609746 624216 610608 623855 593212 620275 621288 644078 766644 765904 776396 462275 799402 419490 565617 416288 425832 444935 459378 504765 565046 571464 557983 517144 503962 814128 518913 568440 564440 566886 574589 581206 552534 565044 687205 689693 699338 706985 712021 715323 673092 699056 702838 681400 687541 689315 699347 703193 703897 705624 713618 599410 585747 601291 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.00%) |
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 399473 416288 417308 419490 424741 425832 435735 444935 447913 454840 456201 456630 459378 462275 462959 470716 475122 477415 488203 491750 503953 503962 504765 504770 506665 517144 518913 552534 557983 564432 564440 565044 565046 565286 565617 566886 568283 568440 571464 571468 574589 575726 581206 585747 589786 593212 599410 601291 609746 610608 611349 620275 621288 623855 624214 624216 624237 644078 673063 673092 673127 675370 681400 682211 687205 687541 689315 689340 689693 690032 696929 697298 698302 699056 699142 699338 699347 699359 699796 699798 701846 702838 703193 703678 703897 704010 705624 706293 706673 706985 706997 707011 712021 712025 713618 715218 715228 715231 715319 715323 719698 719703 719716 719719 725943 729673 730821 741494 752165 755749 757891 762248 764754 765904 766644 776396 790168 794126 799402 814128 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden old man"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт old мужчин"
]
|
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.