Query Metrics
7
Database Queries
7
Different statements
157.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.41 ms (81.38%) |
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 14534 397714 400912 425118 428387 428408 428415 436031 436044 442696 447314 447571 451548 451551 451565 451570 451571 451579 451583 451591 451602 453965 455111 460806 462037 462045 472340 472341 472393 473225 474058 477387 478086 484841 487150 489998 490000 490019 491387 497568 508837 511750 512652 521897 521942 521943 523282 523291 523292 523300 523316 523702 523951 523956 524704 524705 524732 525942 525962 527206 533465 534114 544393 551185 551416 558307 560639 562223 562274 565358 565372 565375 565379 565395 565487 566235 568001 570197 570242 570312 571627 571865 572809 573081 573094 573568 573717 573817 575121 575524 578380 579106 589378 592385 595764 597999 598679 603475 606694 614110 626866 636275 641756 654803 659258 661237 661281 661283 663254 664444 675531 675806 677362 704233 742203 744978 748547 765853 776503 805164 ] |
||||||||||||||||||||||||||||||
|
18.26 ms (11.58%) |
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 455111 462037 523282 742203 451579 478086 428415 436044 659258 675806 521942 654803 589378 14534 603475 472340 523702 523956 474058 477387 573094 573717 675531 442696 453965 527206 524705 565379 661237 400912 436031 565358 663254 776503 744978 451551 472393 524704 490000 490019 524732 525942 562223 451602 447314 512652 566235 451591 451565 565375 571627 551416 573568 614110 748547 397714 462045 521897 572809 597999 533465 511750 573817 661283 805164 508837 551185 606694 765853 473225 451571 565372 487150 641756 497568 523300 425118 592385 562274 570242 664444 565487 521943 491387 523951 568001 573081 544393 575524 626866 428408 451548 523292 595764 472341 428387 523291 578380 579106 558307 575121 570197 677362 636275 704233 447571 451583 451570 460806 523316 525962 534114 571865 598679 484841 489998 661281 560639 570312 565395 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.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 14534 397714 400912 425118 428387 428408 428415 436031 436044 442696 447314 447571 451548 451551 451565 451570 451571 451579 451583 451591 451602 453965 455111 460806 462037 462045 472340 472341 472393 473225 474058 477387 478086 484841 487150 489998 490000 490019 491387 497568 508837 511750 512652 521897 521942 521943 523282 523291 523292 523300 523316 523702 523951 523956 524704 524705 524732 525942 525962 527206 533465 534114 544393 551185 551416 558307 560639 562223 562274 565358 565372 565375 565379 565395 565487 566235 568001 570197 570242 570312 571627 571865 572809 573081 573094 573568 573717 573817 575121 575524 578380 579106 589378 592385 595764 597999 598679 603475 606694 614110 626866 636275 641756 654803 659258 661237 661281 661283 663254 664444 675531 675806 677362 704233 742203 744978 748547 765853 776503 805164 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian interracial sex"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск межрасов секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 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.