Query Metrics
7
Database Queries
7
Different statements
153.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.34 ms (86.03%) |
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 145706 191474 231164 383090 383667 384562 387851 392928 401201 403330 492416 492418 515060 532281 534482 538578 541402 543958 546139 552287 552291 554190 560166 587151 591121 594186 594220 594233 604920 604928 609206 611978 612199 612344 620273 625755 629528 641372 643264 649859 650366 663810 663941 663979 664217 664991 665970 666518 667339 668680 669197 672092 672723 692415 694438 696937 701581 706254 708856 713271 716722 717102 718241 718719 718925 720430 721675 721826 722678 723460 726038 726610 733900 738208 738529 740490 748145 753251 755403 756562 760834 761217 767279 768398 770113 771087 772011 773989 775129 776788 777592 781987 782477 784602 797627 799096 800214 800416 800885 801666 802265 804112 806124 808087 811428 814552 815411 815604 815667 816059 817680 818930 819135 821489 822229 823715 823937 826225 828833 ] |
||||||||||||||||||||||||||||||
|
10.72 ms (6.97%) |
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 770113 726610 767279 771087 811428 384562 387851 401201 716722 383090 231164 532281 694438 720430 723460 733900 392928 701581 665970 609206 594186 594233 641372 800214 802265 738208 612344 760834 145706 826225 814552 821489 822229 828833 543958 664991 692415 663979 664217 587151 604920 775129 776788 800416 777592 808087 772918 717102 706254 819135 554190 666518 718241 672092 629528 594220 756562 773989 772011 538578 515060 492418 541402 650366 668680 721826 649859 782477 806124 753251 784602 800885 740490 748145 718719 781987 797627 768398 383667 815411 818930 815604 817680 552291 552287 713271 722678 663941 672723 718925 667339 669197 721675 604928 612199 625755 620273 643264 761217 804112 726038 738529 755403 696937 816059 801666 815667 492416 560166 534482 403330 191474 823937 823715 708856 663810 546139 611978 591121 799096 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.29%) |
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 145706 191474 231164 383090 383667 384562 387851 392928 401201 403330 492416 492418 515060 532281 534482 538578 541402 543958 546139 552287 552291 554190 560166 587151 591121 594186 594220 594233 604920 604928 609206 611978 612199 612344 620273 625755 629528 641372 643264 649859 650366 663810 663941 663979 664217 664991 665970 666518 667339 668680 669197 672092 672723 692415 694438 696937 701581 706254 708856 713271 716722 717102 718241 718719 718925 720430 721675 721826 722678 723460 726038 726610 733900 738208 738529 740490 748145 753251 755403 756562 760834 761217 767279 768398 770113 771087 772011 773989 775129 776788 777592 781987 782477 784602 797627 799096 800214 800416 800885 801666 802265 804112 806124 808087 811428 814552 815411 815604 815667 816059 817680 818930 819135 821489 822229 823715 823937 826225 828833 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big busty fuck"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие busty секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие busty секс"
]
|
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.