Query Metrics
7
Database Queries
7
Different statements
143.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.75 ms (83.41%) |
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 495384 496713 501657 511416 526990 529895 531052 531666 531842 531984 532116 534692 537722 537874 539552 540558 541160 541200 543485 543934 544302 544970 547297 547323 547331 547341 549282 549385 549960 549967 549973 550007 550149 550384 551710 557444 558110 561559 561575 563908 564264 566682 567981 568241 568242 570774 570802 570829 571184 572570 574077 574180 574210 574249 577257 579912 580900 581621 592741 593204 596853 596878 597209 598274 598390 603311 603348 603733 604867 605166 618377 621026 624532 626563 629796 630281 638278 639683 640393 643111 644357 646865 648470 651163 687127 710350 710585 712617 714384 720528 727384 774773 775341 776780 776849 782119 787634 790731 801887 802567 803025 804770 806837 807395 811315 811336 813451 813804 814602 817091 817097 819233 819247 819249 819250 819766 819803 820847 827400 827460 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (9.43%) |
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 511416 541200 550149 551710 549385 564264 544302 561575 570774 581621 648470 651163 549973 605166 603348 621026 817097 819250 820847 817091 819233 819247 819803 827460 827400 819249 813804 814602 819766 496713 534692 537874 495384 531052 531666 531842 532116 537722 539552 540558 501657 529895 531984 526990 543485 547323 547331 547341 549282 549960 550007 557444 566682 568241 574180 577257 543934 570829 574077 579912 580900 541160 544970 547297 550384 558110 567981 568242 646865 687127 710585 714384 710350 712617 720528 549967 561559 563908 570802 571184 572570 574210 574249 596878 597209 604867 639683 596853 598390 638278 592741 598274 603733 624532 626563 629796 630281 640393 643111 593204 603311 618377 644357 774773 775341 782119 790731 802567 806837 811315 813451 776780 776849 787634 801887 803025 804770 807395 811336 727384 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (2.01%) |
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 495384 496713 501657 511416 526990 529895 531052 531666 531842 531984 532116 534692 537722 537874 539552 540558 541160 541200 543485 543934 544302 544970 547297 547323 547331 547341 549282 549385 549960 549967 549973 550007 550149 550384 551710 557444 558110 561559 561575 563908 564264 566682 567981 568241 568242 570774 570802 570829 571184 572570 574077 574180 574210 574249 577257 579912 580900 581621 592741 593204 596853 596878 597209 598274 598390 603311 603348 603733 604867 605166 618377 621026 624532 626563 629796 630281 638278 639683 640393 643111 644357 646865 648470 651163 687127 710350 710585 712617 714384 720528 727384 774773 775341 776780 776849 782119 787634 790731 801887 802567 803025 804770 806837 807395 811315 811336 813451 813804 814602 817091 817097 819233 819247 819249 819250 819766 819803 820847 827400 827460 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик mom"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик mom"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic 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.