Query Metrics
7
Database Queries
7
Different statements
185.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.38 ms (83.72%) |
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 72285 117876 354774 358200 387453 396924 398534 404602 408433 410979 414782 415633 417457 420151 423653 424411 430314 430411 435662 439470 439591 439784 440614 440908 443173 443278 444045 446059 449375 450649 452254 453138 453262 453263 454053 457852 458930 460138 460187 460689 464291 464970 465341 466217 467626 467926 467974 468685 469455 470295 472148 475676 475875 475881 476168 476908 477587 477716 478503 479717 480305 482505 482575 484310 484439 484558 484591 484705 485267 485693 485945 489317 489388 489398 489400 496724 497517 500458 504692 505636 505641 509204 510333 510915 513131 513635 513976 518828 518839 522140 523929 525133 527964 529246 535452 536625 536824 544464 549728 552850 555181 557022 558289 558490 563196 565726 573742 573801 580913 587272 590797 591883 602974 604018 617389 682303 726294 746114 762208 799369 ] |
||||||||||||||||||||||||||||||
|
18.44 ms (9.94%) |
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 465341 475881 529246 484591 513635 497517 484439 496724 518828 527964 555181 573742 523929 682303 476908 430314 513976 482575 485267 500458 525133 518839 480305 580913 573801 587272 602974 604018 439784 440614 467626 470295 472148 439591 424411 443278 444045 446059 466217 477716 509204 484558 484705 535452 117876 358200 72285 387453 396924 404602 439470 414782 415633 440908 443173 410979 435662 464291 479717 453262 453263 469455 505636 536824 552850 591883 590797 799369 746114 726294 762208 617389 398534 417457 467926 408433 354774 450649 475875 484310 485945 430411 420151 423653 482505 452254 458930 460187 467974 485693 489317 489398 489400 454053 457852 460138 460689 476168 477587 449375 453138 464970 478503 513131 522140 510915 536625 504692 510333 505641 468685 475676 489388 558289 544464 549728 563196 565726 557022 558490 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.85%) |
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 72285 117876 354774 358200 387453 396924 398534 404602 408433 410979 414782 415633 417457 420151 423653 424411 430314 430411 435662 439470 439591 439784 440614 440908 443173 443278 444045 446059 449375 450649 452254 453138 453262 453263 454053 457852 458930 460138 460187 460689 464291 464970 465341 466217 467626 467926 467974 468685 469455 470295 472148 475676 475875 475881 476168 476908 477587 477716 478503 479717 480305 482505 482575 484310 484439 484558 484591 484705 485267 485693 485945 489317 489388 489398 489400 496724 497517 500458 504692 505636 505641 509204 510333 510915 513131 513635 513976 518828 518839 522140 523929 525133 527964 529246 535452 536625 536824 544464 549728 552850 555181 557022 558289 558490 563196 565726 573742 573801 580913 587272 590797 591883 602974 604018 617389 682303 726294 746114 762208 799369 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature in bed"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature постел"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.06%) |
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.