Query Metrics
7
Database Queries
7
Different statements
227.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.41 ms (89.34%) |
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 12203 382692 392909 395920 401940 402458 423094 440261 446061 446626 451591 457701 462273 462285 462352 471992 472305 472859 472972 485917 489648 493260 495331 497519 503308 506518 512948 513458 516692 518308 522857 531290 534539 540705 541568 547429 548113 554892 555066 558903 560696 561097 568477 571221 577678 581006 590372 590461 590795 605218 614237 617711 626400 628258 628656 629656 648674 656804 660441 663747 671247 680797 685466 685513 685523 685524 693496 694288 696103 707323 710400 714033 714037 714056 717543 719249 721885 721909 722014 726878 727796 729929 734386 736444 739151 745081 745912 747098 747129 747503 749204 751441 758028 760924 761152 761157 761160 762771 764868 766692 766696 768042 768759 769104 772960 775203 776918 778867 778989 778992 784298 784816 786790 787013 794116 800304 805241 817375 819005 819020 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (6.15%) |
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 693496 778989 696103 778867 560696 714033 776918 819020 547429 402458 462285 768042 761160 382692 648674 629656 590372 794116 736444 769104 749204 762771 714037 660441 721909 577678 531290 714056 590795 747129 555066 446626 707323 495331 745081 772960 462352 568477 758028 503308 656804 628258 617711 721885 512948 541568 558903 605218 440261 719249 768759 472305 571221 395920 685513 457701 729929 761157 497519 671247 554892 614237 747503 726878 764868 745912 766692 493260 819005 760924 423094 747098 522857 778992 506518 472859 446061 451591 680797 685466 685524 401940 817375 548113 800304 472972 581006 513458 462273 787013 739151 561097 784298 518308 12203 734386 722014 485917 516692 626400 751441 761152 710400 489648 392909 534539 663747 694288 717543 628656 784816 786790 805241 766696 727796 775203 540705 685523 590461 471992 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.47%) |
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 12203 382692 392909 395920 401940 402458 423094 440261 446061 446626 451591 457701 462273 462285 462352 471992 472305 472859 472972 485917 489648 493260 495331 497519 503308 506518 512948 513458 516692 518308 522857 531290 534539 540705 541568 547429 548113 554892 555066 558903 560696 561097 568477 571221 577678 581006 590372 590461 590795 605218 614237 617711 626400 628258 628656 629656 648674 656804 660441 663747 671247 680797 685466 685513 685523 685524 693496 694288 696103 707323 710400 714033 714037 714056 717543 719249 721885 721909 722014 726878 727796 729929 734386 736444 739151 745081 745912 747098 747129 747503 749204 751441 758028 760924 761152 761157 761160 762771 764868 766692 766696 768042 768759 769104 772960 775203 776918 778867 778989 778992 784298 784816 786790 787013 794116 800304 805241 817375 819005 819020 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.60%) |
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.