Query Metrics
7
Database Queries
7
Different statements
245.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.23 ms (88.09%) |
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 388690 390831 420182 428382 428392 428891 429950 436030 436037 445426 451560 451562 451582 457795 461554 464195 464650 465652 478930 483560 489166 490843 490868 491378 491385 493963 497550 497554 497557 508857 508874 512329 512830 521928 521966 521970 523948 525966 528921 533743 533833 533911 534032 534041 535582 539420 548733 552253 554366 556051 558983 558990 559986 560446 560488 560610 560622 562263 562266 562281 562311 564075 564078 564082 565349 565354 565355 565359 565373 565377 565390 565391 565405 565411 565413 565414 565426 565436 565462 568307 568309 570673 571534 571855 571857 572042 572389 572397 573026 573776 573814 574512 574855 575104 575217 575748 575762 576344 578376 578898 580263 586595 596160 596991 597005 597112 597113 597997 598014 598138 598498 600016 632851 644971 645010 718675 765848 808075 810698 820662 ] |
||||||||||||||||||||||||||||||
|
18.97 ms (7.73%) |
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 573026 560622 808075 436030 461554 490843 491385 558990 565436 554366 574855 598014 597005 597113 765848 451582 508874 497557 560488 570673 571855 571857 508857 445426 388690 451560 483560 533743 533833 565426 810698 390831 565349 565462 457795 521928 491378 512830 497554 565391 572389 596160 428382 525966 575217 596991 451562 436037 497550 820662 632851 552253 534032 575762 573776 578376 560446 575104 573814 600016 521966 598498 493963 429950 572397 574512 565377 598138 490868 521970 464650 645010 559986 564082 565414 718675 512329 597112 575748 528921 580263 548733 534041 533911 478930 562281 565390 564078 523948 565405 560610 562263 565373 568307 428392 535582 568309 562266 565355 586595 428891 420182 644971 464195 572042 597997 489166 539420 564075 565354 578898 558983 565411 565413 571534 562311 465652 576344 556051 565359 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.37%) |
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 388690 390831 420182 428382 428392 428891 429950 436030 436037 445426 451560 451562 451582 457795 461554 464195 464650 465652 478930 483560 489166 490843 490868 491378 491385 493963 497550 497554 497557 508857 508874 512329 512830 521928 521966 521970 523948 525966 528921 533743 533833 533911 534032 534041 535582 539420 548733 552253 554366 556051 558983 558990 559986 560446 560488 560610 560622 562263 562266 562281 562311 564075 564078 564082 565349 565354 565355 565359 565373 565377 565390 565391 565405 565411 565413 565414 565426 565436 565462 568307 568309 570673 571534 571855 571857 572042 572389 572397 573026 573776 573814 574512 574855 575104 575217 575748 575762 576344 578376 578898 580263 586595 596160 596991 597005 597112 597113 597997 598014 598138 598498 600016 632851 644971 645010 718675 765848 808075 810698 820662 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian interracial sex"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск межрасов секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 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.