Query Metrics
7
Database Queries
7
Different statements
179.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.86 ms (84.74%) |
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 382465 480379 527413 530006 530724 530727 530730 531522 532180 532270 532776 533505 534236 534258 534261 534279 534286 534304 534305 534314 534318 534780 535012 535014 535020 535264 535823 535825 535835 536347 537101 537105 537873 545451 554573 554759 564800 565150 577388 577390 577406 586670 586671 586672 586673 586678 587925 596082 596084 596096 596477 606863 607713 630247 633150 633176 638578 640692 640713 649171 650008 650343 650389 651025 697766 704239 727482 756377 756415 756611 757362 759845 759896 760839 790784 792531 797646 797801 801370 801960 803317 804677 807529 807542 807770 807949 808461 808472 808579 811393 814749 814752 814760 814777 814778 814796 814806 814807 814831 814832 814833 814839 814840 814841 814845 814850 814865 814867 814873 814877 814885 814887 814892 814908 814930 814933 814936 815273 815420 815931 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (9.34%) |
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 814850 814908 814760 814749 532776 577406 633150 607713 640713 808472 535014 815931 537101 530727 534305 535264 814806 814831 814752 814887 814841 530724 534304 535825 537873 534286 554759 577388 649171 650343 651025 586672 640692 756415 759896 807542 760839 757362 697766 797646 814930 814796 814867 814885 533505 534261 530006 532270 534258 535012 537105 596477 586671 638578 807529 792531 759845 808461 382465 814845 577390 586673 596082 633176 756611 727482 531522 801370 527413 535020 814865 814832 814892 480379 565150 801960 808579 814933 536347 814777 815420 815273 814873 814778 814807 814833 814839 814877 814840 814936 535835 534236 534279 535823 532180 554573 545451 650008 650389 704239 564800 587925 596096 596084 586670 606863 790784 804677 797801 807949 756377 630247 803317 807770 534318 534780 530730 534314 586678 811393 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.84%) |
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 382465 480379 527413 530006 530724 530727 530730 531522 532180 532270 532776 533505 534236 534258 534261 534279 534286 534304 534305 534314 534318 534780 535012 535014 535020 535264 535823 535825 535835 536347 537101 537105 537873 545451 554573 554759 564800 565150 577388 577390 577406 586670 586671 586672 586673 586678 587925 596082 596084 596096 596477 606863 607713 630247 633150 633176 638578 640692 640713 649171 650008 650343 650389 651025 697766 704239 727482 756377 756415 756611 757362 759845 759896 760839 790784 792531 797646 797801 801370 801960 803317 804677 807529 807542 807770 807949 808461 808472 808579 811393 814749 814752 814760 814777 814778 814796 814806 814807 814831 814832 814833 814839 814840 814841 814845 814850 814865 814867 814873 814877 814885 814887 814892 814908 814930 814933 814936 815273 815420 815931 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers mother"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
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.