Query Metrics
7
Database Queries
7
Different statements
149.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.67 ms (82.69%) |
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 3561 8900 23003 382066 383201 386824 389935 395285 395769 405761 412078 423943 425508 425529 428955 429020 432884 442100 443248 450216 452205 463509 466925 473719 476754 476788 490238 494399 495376 499836 500738 507637 508152 513252 513258 514034 516588 523176 529189 531730 532444 536514 538378 539881 539976 552373 554685 560345 563359 577521 580817 582654 589593 593195 595213 595491 599653 600936 602221 606594 607997 624907 649388 652881 652884 664717 666492 671560 677432 679283 690031 702319 714348 718537 740262 742696 743248 751796 752500 752619 754403 754480 754504 755883 757186 763052 763496 767267 768025 772483 774774 775327 777705 783363 783377 785079 786916 790275 790399 793011 795156 797918 799734 803915 804140 804239 804306 804453 807070 810484 811319 811761 811816 811913 811914 812529 817304 820853 820984 822681 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (10.51%) |
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 523176 395285 382066 23003 8900 405761 514034 652884 664717 606594 790399 804140 807070 763496 767267 742696 752619 793011 803915 811816 412078 450216 490238 507637 513252 395769 389935 536514 531730 671560 714348 599653 752500 754480 443248 423943 494399 3561 466925 508152 529189 582654 811913 804453 820853 822681 777705 790275 539976 532444 499836 743248 476754 383201 754504 554685 811761 757186 452205 552373 624907 513258 820984 817304 425508 429020 432884 442100 463509 580817 563359 577521 600936 602221 593195 804306 428955 476788 425529 473719 516588 495376 539881 538378 560345 652881 677432 702319 690031 649388 666492 679283 718537 589593 595213 595491 607997 774774 786916 795156 810484 812529 775327 799734 811319 811914 755883 783363 783377 785079 797918 740262 754403 751796 768025 763052 804239 500738 772483 386824 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.09%) |
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 3561 8900 23003 382066 383201 386824 389935 395285 395769 405761 412078 423943 425508 425529 428955 429020 432884 442100 443248 450216 452205 463509 466925 473719 476754 476788 490238 494399 495376 499836 500738 507637 508152 513252 513258 514034 516588 523176 529189 531730 532444 536514 538378 539881 539976 552373 554685 560345 563359 577521 580817 582654 589593 593195 595213 595491 599653 600936 602221 606594 607997 624907 649388 652881 652884 664717 666492 671560 677432 679283 690031 702319 714348 718537 740262 742696 743248 751796 752500 752619 754403 754480 754504 755883 757186 763052 763496 767267 768025 772483 774774 775327 777705 783363 783377 785079 786916 790275 790399 793011 795156 797918 799734 803915 804140 804239 804306 804453 807070 810484 811319 811761 811816 811913 811914 812529 817304 820853 820984 822681 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo bathroom masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло ван мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло ван мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.