Query Metrics
7
Database Queries
7
Different statements
179.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.83 ms (82.48%) |
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 417391 418293 418591 423123 426789 426818 428771 443029 444267 445759 447023 447079 447909 448265 448876 450912 451492 452657 455227 455247 455861 462675 463000 465006 470758 477114 479558 482916 484628 485570 490253 491167 491168 493288 494161 500210 502588 506928 507533 507785 508497 509005 510690 512263 512495 512540 513325 514685 518818 519331 519460 519768 519776 520478 520623 520912 522083 522362 522463 522508 522559 522745 523016 524060 524930 525601 527370 527609 527738 528187 528265 529107 530001 551156 552353 555056 556241 557035 558545 559080 559722 560393 560791 563742 564078 564160 567068 567703 572324 576286 581749 583112 583997 586390 592263 593296 597126 597821 598605 599424 601853 601963 602031 603967 614918 616754 619005 626089 627139 650624 668360 676472 743706 751265 751572 763741 780517 799941 814175 814971 ] |
||||||||||||||||||||||||||||||
|
20.62 ms (11.51%) |
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 583112 626089 751265 443029 462675 513325 520912 520478 525601 522083 417391 452657 444267 520623 814971 465006 558545 650624 559080 592263 586390 599424 799941 780517 470758 447909 479558 447023 448265 491167 522463 522745 519768 567703 507785 514685 519776 581749 455227 556241 447079 522362 522559 524060 529107 490253 560393 572324 448876 524930 482916 509005 555056 559722 552353 668360 560791 567068 603967 616754 751572 602031 418293 510690 522508 502588 557035 445759 527370 527738 743706 564078 463000 512540 530001 485570 494161 506928 519460 563742 583997 426789 455247 814175 493288 523016 507533 763741 477114 528187 500210 491168 512263 614918 428771 418591 527609 508497 593296 426818 676472 551156 512495 423123 450912 455861 518818 519331 601853 597126 597821 564160 598605 601963 528265 451492 484628 576286 619005 627139 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.63%) |
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 417391 418293 418591 423123 426789 426818 428771 443029 444267 445759 447023 447079 447909 448265 448876 450912 451492 452657 455227 455247 455861 462675 463000 465006 470758 477114 479558 482916 484628 485570 490253 491167 491168 493288 494161 500210 502588 506928 507533 507785 508497 509005 510690 512263 512495 512540 513325 514685 518818 519331 519460 519768 519776 520478 520623 520912 522083 522362 522463 522508 522559 522745 523016 524060 524930 525601 527370 527609 527738 528187 528265 529107 530001 551156 552353 555056 556241 557035 558545 559080 559722 560393 560791 563742 564078 564160 567068 567703 572324 576286 581749 583112 583997 586390 592263 593296 597126 597821 598605 599424 601853 601963 602031 603967 614918 616754 619005 626089 627139 650624 668360 676472 743706 751265 751572 763741 780517 799941 814175 814971 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl suck"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск девушк suck"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк suck"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.