Query Metrics
7
Database Queries
7
Different statements
347.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.20 ms (59.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
117.90 ms (33.90%) |
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 6656 370829 387711 388350 393391 402896 404185 415287 424125 428580 428583 432810 433372 439727 440906 471407 471458 488619 503407 510064 512506 515441 516226 522857 527908 534991 543983 545342 547476 565164 571266 591666 595309 597165 598306 598556 600004 600179 604138 606618 611893 617825 620310 624895 632358 639736 642075 664226 666736 669016 669370 671701 673983 678744 686009 696308 697354 698969 702463 702621 705404 712617 715145 716055 716897 718152 720410 720713 723461 723735 726277 734487 739998 750554 751515 751627 758191 758355 759369 760814 761570 761600 761696 766523 766860 766896 770337 770499 770900 770908 770938 775477 778889 781332 782657 785051 786763 788284 788856 790575 790974 795731 797520 800495 801542 801609 802845 803461 803524 805434 807402 809122 810824 810899 813255 814359 814656 814851 822168 823510 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (3.88%) |
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 801609 402896 471458 512506 534991 510064 666736 705404 624895 785051 761600 790575 439727 424125 393391 440906 516226 702621 712617 611893 598556 726277 428583 488619 571266 678744 696308 595309 600004 591666 810899 803524 803461 810824 766896 770337 715145 788284 370829 471407 433372 503407 775477 527908 415287 432810 814359 822168 814656 823510 515441 522857 545342 547476 565164 543983 671701 697354 723461 664226 669016 669370 686009 698969 673983 716055 720410 600179 606618 598306 597165 604138 642075 781332 782657 790974 778889 800495 805434 809122 723735 750554 761696 766523 770499 770908 786763 788856 795731 813255 759369 760814 766860 734487 751627 770900 770938 758355 761570 739998 751515 758191 617825 620310 632358 639736 702463 716897 718152 720713 797520 801542 802845 807402 387711 6656 388350 404185 428580 814851 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (0.77%) |
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 6656 370829 387711 388350 393391 402896 404185 415287 424125 428580 428583 432810 433372 439727 440906 471407 471458 488619 503407 510064 512506 515441 516226 522857 527908 534991 543983 545342 547476 565164 571266 591666 595309 597165 598306 598556 600004 600179 604138 606618 611893 617825 620310 624895 632358 639736 642075 664226 666736 669016 669370 671701 673983 678744 686009 696308 697354 698969 702463 702621 705404 712617 715145 716055 716897 718152 720410 720713 723461 723735 726277 734487 739998 750554 751515 751627 758191 758355 759369 760814 761570 761600 761696 766523 766860 766896 770337 770499 770900 770908 770938 775477 778889 781332 782657 785051 786763 788284 788856 790575 790974 795731 797520 800495 801542 801609 802845 803461 803524 805434 807402 809122 810824 810899 813255 814359 814656 814851 822168 823510 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf-mom-anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mom анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf 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.