Query Metrics
7
Database Queries
7
Different statements
386.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.85 ms (54.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus mom sex"
]
|
||||||||||||||||||||||||||||||
|
149.28 ms (38.63%) |
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 181009 387711 397421 398936 414319 420549 422280 422345 424120 424124 424193 424269 439743 441821 443365 443747 443811 444134 453184 456000 458072 460915 462560 463173 465342 465372 465388 465789 465970 466270 466965 468355 470289 477104 478377 485364 486578 488514 490741 491916 491983 502748 506084 508744 512485 518335 522480 523834 525509 535332 542090 542741 545726 546950 547909 558304 563224 563453 565859 565898 578821 580363 588958 590223 594942 598456 599218 601618 603767 605475 612977 613052 620247 625567 627064 651006 660137 677862 693396 705317 705890 709540 721409 722302 725401 725579 727330 739622 741013 744494 744860 751571 751585 751627 751906 754081 758417 758512 766165 777499 777973 778784 779069 779478 779565 781713 785349 786238 788756 790648 794019 796583 797361 808562 810896 816124 817725 817733 820187 825830 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (4.27%) |
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 660137 565859 422345 424120 424269 439743 443747 456000 465789 465970 463173 420549 477104 424124 466965 468355 522480 506084 491916 518335 523834 816124 558304 620247 594942 612977 601618 777499 781713 794019 797361 808562 779069 779565 766165 785349 790648 725401 751585 758512 751571 725579 709540 777973 422280 414319 458072 542741 512485 491983 508744 462560 181009 613052 741013 387711 465388 466270 488514 542090 545726 547909 578821 580363 546950 563453 397421 424193 453184 441821 460915 465342 470289 443365 444134 478377 486578 705890 465372 502748 490741 817733 825830 820187 563224 590223 605475 754081 758417 739622 751627 744494 744860 398936 485364 443811 525509 817725 535332 565898 721409 677862 693396 705317 722302 651006 588958 598456 599218 625567 603767 627064 779478 786238 778784 788756 796583 727330 751906 810896 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (0.82%) |
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 181009 387711 397421 398936 414319 420549 422280 422345 424120 424124 424193 424269 439743 441821 443365 443747 443811 444134 453184 456000 458072 460915 462560 463173 465342 465372 465388 465789 465970 466270 466965 468355 470289 477104 478377 485364 486578 488514 490741 491916 491983 502748 506084 508744 512485 518335 522480 523834 525509 535332 542090 542741 545726 546950 547909 558304 563224 563453 565859 565898 578821 580363 588958 590223 594942 598456 599218 601618 603767 605475 612977 613052 620247 625567 627064 651006 660137 677862 693396 705317 705890 709540 721409 722302 725401 725579 727330 739622 741013 744494 744860 751571 751585 751627 751906 754081 758417 758512 766165 777499 777973 778784 779069 779478 779565 781713 785349 786238 788756 790648 794019 796583 797361 808562 810896 816124 817725 817733 820187 825830 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mom секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск 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.