Query Metrics
7
Database Queries
7
Different statements
166.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.55 ms (79.81%) |
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 400237 400249 401114 405485 408240 411838 413161 425802 425966 426369 426384 428653 431750 435226 435917 437494 440620 446718 447104 447746 449613 451932 457446 460135 460204 462465 464395 472544 473871 474761 475410 476105 476228 478333 482228 482679 486594 487344 492268 493244 496771 497473 497478 498030 499446 504423 507512 508275 508474 510177 511895 512896 514097 514804 518176 519930 520253 520639 520766 521723 523659 524200 524262 527085 527377 528406 533505 537600 545779 556819 557534 561512 563844 565317 566317 566606 568052 568641 577390 578492 583329 587907 606649 608049 623444 626353 638360 640721 642556 647901 650806 674056 702460 714973 724656 758585 771924 788161 789690 790019 790026 790878 792610 792612 793340 798683 801240 806430 807363 808470 810663 810669 810983 815232 815449 815865 816569 817917 820683 820973 ] |
||||||||||||||||||||||||||||||
|
23.53 ms (14.17%) |
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 815449 817917 815865 460204 476105 533505 537600 514804 493244 568052 578492 638360 606649 810669 790026 793340 810663 810983 623444 702460 808470 447746 431750 476228 478333 608049 565317 425802 519930 492268 563844 789690 447104 464395 475410 425966 426369 527085 508275 437494 435226 446718 520766 496771 405485 650806 408240 426384 413161 428653 411838 820973 820683 449613 460135 524262 626353 642556 587907 798683 806430 801240 771924 714973 790878 474761 518176 524200 497478 497473 462465 435917 400249 499446 510177 498030 507512 788161 724656 486594 816569 815232 482679 482228 514097 472544 545779 566606 556819 568641 583329 561512 647901 674056 566317 790019 792610 792612 758585 401114 400237 451932 523659 528406 527377 504423 511895 512896 520639 487344 521723 473871 457446 440620 508474 520253 557534 577390 640721 807363 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.52%) |
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 400237 400249 401114 405485 408240 411838 413161 425802 425966 426369 426384 428653 431750 435226 435917 437494 440620 446718 447104 447746 449613 451932 457446 460135 460204 462465 464395 472544 473871 474761 475410 476105 476228 478333 482228 482679 486594 487344 492268 493244 496771 497473 497478 498030 499446 504423 507512 508275 508474 510177 511895 512896 514097 514804 518176 519930 520253 520639 520766 521723 523659 524200 524262 527085 527377 528406 533505 537600 545779 556819 557534 561512 563844 565317 566317 566606 568052 568641 577390 578492 583329 587907 606649 608049 623444 626353 638360 640721 642556 647901 650806 674056 702460 714973 724656 758585 771924 788161 789690 790019 790026 790878 792610 792612 793340 798683 801240 806430 807363 808470 810663 810669 810983 815232 815449 815865 816569 817917 820683 820973 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina mom boy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская mom парен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская mom парен"
]
|
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.