Query Metrics
7
Database Queries
7
Different statements
370.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.16 ms (55.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
142.09 ms (38.37%) |
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 79765 233135 233147 233670 365924 383912 388568 388604 390294 391287 392750 395142 395910 395988 396428 397174 398951 400989 401013 401216 401229 402045 403651 406969 407185 407754 407779 412227 413462 428456 430833 439715 443682 443759 446622 453702 454212 454256 462710 464446 465825 466250 466986 469370 471883 475870 482378 518826 518849 518852 520696 530348 536330 538972 539157 550642 556653 556655 557991 558021 563196 565684 566014 587558 606791 608049 608338 621067 623145 624284 636039 663504 665276 669448 682071 682514 688554 689373 710485 710578 714886 714938 717645 724295 740156 741893 747284 761103 765306 770494 776892 779224 780645 782230 786167 788229 788282 788812 789016 789536 789698 790013 793294 800557 801223 802441 805199 807369 807380 807452 807454 807459 807636 808452 808474 808552 808649 820726 823692 827861 ] |
||||||||||||||||||||||||||||||
|
14.93 ms (4.03%) |
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 710578 623145 800557 788282 805199 808552 402045 443682 395910 530348 550642 688554 717645 788229 807459 741893 790013 808649 388604 401216 407779 407754 453702 466986 518826 558021 563196 710485 714938 557991 624284 608338 789536 400989 443759 471883 475870 391287 482378 412227 465825 395142 390294 428456 464446 556655 606791 401229 430833 520696 556653 566014 789698 793294 801223 807369 770494 807636 740156 608049 779224 407185 233135 823692 820726 827861 663504 789016 807380 782230 761103 780645 462710 518852 383912 392750 395988 413462 538972 565684 587558 802441 388568 233670 365924 406969 439715 454212 454256 466250 79765 446622 518849 682514 682071 689373 776892 808474 621067 788812 401013 397174 403651 469370 536330 539157 665276 669448 714886 636039 807452 808452 747284 765306 724295 786167 807454 396428 398951 233147 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.61%) |
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 79765 233135 233147 233670 365924 383912 388568 388604 390294 391287 392750 395142 395910 395988 396428 397174 398951 400989 401013 401216 401229 402045 403651 406969 407185 407754 407779 412227 413462 428456 430833 439715 443682 443759 446622 453702 454212 454256 462710 464446 465825 466250 466986 469370 471883 475870 482378 518826 518849 518852 520696 530348 536330 538972 539157 550642 556653 556655 557991 558021 563196 565684 566014 587558 606791 608049 608338 621067 623145 624284 636039 663504 665276 669448 682071 682514 688554 689373 710485 710578 714886 714938 717645 724295 740156 741893 747284 761103 765306 770494 776892 779224 780645 782230 786167 788229 788282 788812 789016 789536 789698 790013 793294 800557 801223 802441 805199 807369 807380 807452 807454 807459 807636 808452 808474 808552 808649 820726 823692 827861 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young mom boy"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young mom парен"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young 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.