Query Metrics
7
Database Queries
7
Different statements
157.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.13 ms (82.58%) |
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 90684 391574 392493 396313 399473 413316 417274 419487 425500 429794 432735 443711 447913 448557 450515 453844 456496 456630 456889 462253 462306 462959 466847 467426 467445 470716 470802 474792 476264 476381 476746 482521 484088 486568 488203 492154 496361 498064 498066 504195 504261 506522 506665 511532 513280 520982 525774 526492 531903 537636 540098 540151 550505 550507 550636 551627 552282 553723 571466 571468 572827 575726 593533 594782 594833 594918 598614 600553 601065 605929 611880 615622 617216 620276 620291 623860 623874 624241 624249 640738 664433 671927 672408 679472 682047 682599 687542 688342 689622 693023 694154 697623 698289 698301 698302 699023 699025 699335 699480 699804 699808 700426 703192 704010 704726 704735 706280 706290 712973 727594 729302 734630 744171 764352 764593 766687 798864 798886 800373 805347 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (11.18%) |
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 486568 688342 694154 593533 623860 474792 448557 496361 525774 664433 703192 672408 615622 620276 601065 727594 766687 640738 476381 456630 552282 443711 392493 537636 594782 798864 466847 492154 698301 605929 805347 90684 419487 462306 476264 484088 699025 526492 396313 417274 462253 620291 624249 600553 594918 764352 456496 744171 550636 697623 712973 482521 504261 504195 413316 798886 699480 682047 700426 704010 699023 706290 699804 704726 704735 624241 699808 432735 453844 551627 698302 623874 488203 550507 699335 687542 698289 594833 617216 598614 800373 706280 470716 425500 447913 470802 540098 550505 572827 575726 682599 689622 467445 511532 540151 571466 391574 450515 476746 498066 462959 429794 399473 506665 498064 513280 671927 679472 734630 764593 729302 467426 506522 520982 531903 553723 693023 571468 611880 456889 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.54%) |
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 90684 391574 392493 396313 399473 413316 417274 419487 425500 429794 432735 443711 447913 448557 450515 453844 456496 456630 456889 462253 462306 462959 466847 467426 467445 470716 470802 474792 476264 476381 476746 482521 484088 486568 488203 492154 496361 498064 498066 504195 504261 506522 506665 511532 513280 520982 525774 526492 531903 537636 540098 540151 550505 550507 550636 551627 552282 553723 571466 571468 572827 575726 593533 594782 594833 594918 598614 600553 601065 605929 611880 615622 617216 620276 620291 623860 623874 624241 624249 640738 664433 671927 672408 679472 682047 682599 687542 688342 689622 693023 694154 697623 698289 698301 698302 699023 699025 699335 699480 699804 699808 700426 703192 704010 704726 704735 706280 706290 712973 727594 729302 734630 744171 764352 764593 766687 798864 798886 800373 805347 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young hidden sex"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young скрыт секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young скрыт секс"
]
|
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.