Query Metrics
7
Database Queries
7
Different statements
172.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.61 ms (84.20%) |
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 66919 83083 145336 336085 361992 391317 391762 395439 396776 400595 412616 421623 426487 454290 457275 458203 460327 462189 466925 473692 489731 495733 497809 497894 509717 512190 517508 523407 526767 527140 528370 529638 531655 533224 533785 541124 547416 548945 550511 553160 553547 554707 555315 555959 558402 559863 560345 560723 561409 562051 571304 578987 581357 581550 585784 586100 589526 591836 596800 602964 603023 611476 614485 627425 630468 649388 649474 650524 651784 658492 658931 658939 662212 668330 669941 670934 671779 673375 679281 679391 683080 683698 686867 690014 691785 692691 698196 698797 700830 704662 704788 708561 709374 710860 712446 715743 719439 720297 722043 732178 744138 751386 751669 753605 755608 760315 762526 768599 793721 794082 798762 803367 812399 815989 816147 817734 817829 818209 824000 827627 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (8.95%) |
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 145336 391762 396776 466925 489731 512190 517508 562051 581357 720297 722043 668330 669941 715743 670934 673375 704662 553547 585784 589526 591836 614485 627425 586100 611476 596800 798762 803367 812399 793721 755608 760315 762526 794082 751669 698797 391317 421623 753605 751386 66919 555959 454290 497809 558402 690014 630468 528370 426487 460327 457275 527140 550511 602964 523407 412616 495733 603023 744138 768599 732178 395439 336085 361992 83083 400595 815989 817829 816147 827627 817734 818209 824000 458203 473692 462189 529638 533785 531655 533224 497894 509717 526767 553160 554707 559863 560723 561409 571304 547416 548945 578987 541124 555315 560345 581550 650524 658939 662212 671779 683080 686867 692691 719439 649474 651784 658492 683698 700830 709374 710860 649388 658931 679281 679391 691785 698196 704788 708561 712446 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.14%) |
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 66919 83083 145336 336085 361992 391317 391762 395439 396776 400595 412616 421623 426487 454290 457275 458203 460327 462189 466925 473692 489731 495733 497809 497894 509717 512190 517508 523407 526767 527140 528370 529638 531655 533224 533785 541124 547416 548945 550511 553160 553547 554707 555315 555959 558402 559863 560345 560723 561409 562051 571304 578987 581357 581550 585784 586100 589526 591836 596800 602964 603023 611476 614485 627425 630468 649388 649474 650524 651784 658492 658931 658939 662212 668330 669941 670934 671779 673375 679281 679391 683080 683698 686867 690014 691785 692691 698196 698797 700830 704662 704788 708561 709374 710860 712446 715743 719439 720297 722043 732178 744138 751386 751669 753605 755608 760315 762526 768599 793721 794082 798762 803367 812399 815989 816147 817734 817829 818209 824000 827627 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пися туалет"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин туалет"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.