Query Metrics
7
Database Queries
7
Different statements
161.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.89 ms (83.11%) |
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 393789 408708 416934 419073 419751 424658 426547 431410 444636 445037 448380 451595 451696 453248 455180 464275 464288 464320 467294 467330 470546 470849 471511 472616 472912 473073 476955 484767 486237 487902 491646 492002 492387 493184 494367 494557 504354 505004 511724 513739 514733 515136 515153 515158 515160 515165 515167 515170 515171 515175 515189 515193 515197 515226 515231 515234 515249 515724 516709 518296 519991 520464 520714 520721 520722 520724 520725 520727 525119 525566 526004 528076 528778 529206 529219 530779 534752 539001 540912 543924 547823 550602 554134 554309 557274 557304 569668 570840 571383 580321 584062 585136 586632 588300 593529 593847 597139 597599 598568 598699 603304 606731 607237 613180 618888 619403 620934 621657 632314 642672 653523 668176 676467 678791 681310 714480 720480 736920 790884 809153 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (10.85%) |
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 593847 603304 620934 586632 606731 588300 736920 618888 445037 393789 426547 444636 484767 528076 570840 584062 619403 451595 472912 515249 597139 491646 419073 453248 467294 471511 473073 513739 516709 515165 525566 515193 518296 642672 613180 408708 424658 455180 464320 464275 529219 492002 494367 511724 515158 515167 515197 520721 520724 515189 520464 540912 431410 492387 543924 539001 557304 569668 419751 668176 678791 676467 554309 515171 448380 476955 486237 525119 504354 520714 681310 593529 520725 520722 585136 451696 464288 530779 550602 554134 547823 580321 653523 714480 557274 598568 598699 607237 597599 809153 720480 514733 470546 528778 515234 515724 520727 526004 515231 534752 519991 571383 632314 621657 790884 467330 416934 470849 472616 515136 487902 494557 515170 515175 529206 493184 505004 515153 515160 515226 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.92%) |
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 393789 408708 416934 419073 419751 424658 426547 431410 444636 445037 448380 451595 451696 453248 455180 464275 464288 464320 467294 467330 470546 470849 471511 472616 472912 473073 476955 484767 486237 487902 491646 492002 492387 493184 494367 494557 504354 505004 511724 513739 514733 515136 515153 515158 515160 515165 515167 515170 515171 515175 515189 515193 515197 515226 515231 515234 515249 515724 516709 518296 519991 520464 520714 520721 520722 520724 520725 520727 525119 525566 526004 528076 528778 529206 529219 530779 534752 539001 540912 543924 547823 550602 554134 554309 557274 557304 569668 570840 571383 580321 584062 585136 586632 588300 593529 593847 597139 597599 598568 598699 603304 606731 607237 613180 618888 619403 620934 621657 632314 642672 653523 668176 676467 678791 681310 714480 720480 736920 790884 809153 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"grandpa big cock"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"grandpa большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"grandpa большие cock"
]
|
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.