Query Metrics
7
Database Queries
7
Different statements
206.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.60 ms (84.95%) |
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 31492 146078 188561 233622 330102 382993 386532 390912 391947 392729 394427 397592 397942 400855 404077 407449 410963 411374 426550 428138 439488 442066 443925 452964 456194 457998 458126 462557 466835 468341 471116 471450 472675 473400 475868 479028 479041 483362 483451 485979 491099 493172 495040 506888 511376 530688 536330 537972 544447 546389 554936 555242 555287 558175 573174 597158 600881 602295 604302 605136 609164 665960 704264 707484 710011 710214 712215 721955 725135 725227 726408 726980 727499 727735 730370 731137 731259 731836 734102 734333 736196 739927 740844 741023 742386 742716 743790 744339 746710 758118 759009 759931 759939 761025 761191 768330 769429 772691 778563 781753 781771 782470 794866 794869 794895 794897 795942 796119 799968 804251 818833 819011 824268 825751 825871 826084 826589 826827 827178 827662 ] |
||||||||||||||||||||||||||||||
|
20.63 ms (9.98%) |
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 605136 604302 731137 734102 781771 731259 769429 726408 739927 731836 736196 740844 741023 742716 761025 704264 710214 794897 799968 391947 458126 188561 602295 742386 233622 483451 400855 397592 826084 772691 495040 386532 394427 397942 818833 819011 826589 826827 827178 824268 456194 530688 506888 537972 546389 544447 555287 554936 555242 707484 665960 600881 781753 782470 794866 794869 795942 725227 727735 734333 744339 746710 759009 759931 759939 794895 796119 804251 730370 761191 768330 726980 710011 721955 479041 475868 479028 392729 825751 471116 725135 758118 727499 712215 439488 462557 428138 443925 472675 483362 493172 485979 558175 609164 597158 426550 457998 473400 452964 511376 382993 573174 778563 411374 825871 827662 743790 330102 404077 442066 146078 31492 390912 407449 410963 471450 466835 468341 491099 536330 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.48%) |
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 31492 146078 188561 233622 330102 382993 386532 390912 391947 392729 394427 397592 397942 400855 404077 407449 410963 411374 426550 428138 439488 442066 443925 452964 456194 457998 458126 462557 466835 468341 471116 471450 472675 473400 475868 479028 479041 483362 483451 485979 491099 493172 495040 506888 511376 530688 536330 537972 544447 546389 554936 555242 555287 558175 573174 597158 600881 602295 604302 605136 609164 665960 704264 707484 710011 710214 712215 721955 725135 725227 726408 726980 727499 727735 730370 731137 731259 731836 734102 734333 736196 739927 740844 741023 742386 742716 743790 744339 746710 758118 759009 759931 759939 761025 761191 768330 769429 772691 778563 781753 781771 782470 794866 794869 794895 794897 795942 796119 799968 804251 818833 819011 824268 825751 825871 826084 826589 826827 827178 827662 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature webcam"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature вебкамер"
]
|
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.