Query Metrics
7
Database Queries
7
Different statements
204.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.58 ms (87.02%) |
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 7748 263868 392778 392787 395530 405500 407185 407664 409334 410177 411867 413112 414302 415584 417018 424191 424850 424982 425691 429306 430245 432189 447937 450801 450813 454057 469549 473921 477335 482230 489960 493899 502791 511823 532111 552047 556511 556641 556653 556656 561589 562408 564697 581878 586682 587215 589616 591048 591530 608049 609966 610114 624286 624300 625435 631358 639127 662140 665940 670748 673654 687942 692365 694707 695186 710523 710883 711671 717948 721748 721822 724706 725362 726621 726887 726891 727339 730955 742638 742839 746621 753722 755383 757568 758414 758605 764919 771243 777154 777220 777270 778852 779224 782564 786455 786462 787342 789698 790534 793121 793223 793294 793372 801223 801356 802402 805367 806767 807365 807367 807373 807377 807490 807491 808679 813118 817269 818502 819231 825112 ] |
||||||||||||||||||||||||||||||
|
16.48 ms (8.08%) |
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 392778 778852 793223 782564 807365 757568 807367 7748 424982 489960 665940 730955 493899 710883 807377 727339 742638 564697 808679 721748 407185 415584 473921 482230 432189 561589 581878 670748 692365 695186 721822 694707 631358 805367 786462 711671 405500 392787 409334 477335 417018 410177 825112 532111 687942 710523 562408 587215 591530 777220 777270 813118 726887 755383 764919 787342 263868 395530 425691 430245 817269 447937 552047 673654 793294 806767 609966 414302 511823 818502 819231 802402 758605 413112 556653 556511 556641 662140 717948 624286 624300 591048 625435 589616 586682 789698 801223 801356 807491 742839 726621 753722 608049 779224 807373 469549 411867 454057 407664 429306 424191 502791 450801 450813 786455 610114 807490 771243 793121 724706 725362 726891 639127 790534 424850 556656 777154 793372 758414 746621 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.46%) |
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 7748 263868 392778 392787 395530 405500 407185 407664 409334 410177 411867 413112 414302 415584 417018 424191 424850 424982 425691 429306 430245 432189 447937 450801 450813 454057 469549 473921 477335 482230 489960 493899 502791 511823 532111 552047 556511 556641 556653 556656 561589 562408 564697 581878 586682 587215 589616 591048 591530 608049 609966 610114 624286 624300 625435 631358 639127 662140 665940 670748 673654 687942 692365 694707 695186 710523 710883 711671 717948 721748 721822 724706 725362 726621 726887 726891 727339 730955 742638 742839 746621 753722 755383 757568 758414 758605 764919 771243 777154 777220 777270 778852 779224 782564 786455 786462 787342 789698 790534 793121 793223 793294 793372 801223 801356 802402 805367 806767 807365 807367 807373 807377 807490 807491 808679 813118 817269 818502 819231 825112 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big as mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие mom"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.77%) |
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.