Query Metrics
7
Database Queries
7
Different statements
177.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.78 ms (87.00%) |
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 6663 353401 381912 388826 392458 395499 395567 398740 399358 404234 406002 411637 415735 416236 425694 428408 430290 430400 433883 434716 436030 443231 444748 445623 446632 446873 446972 451570 455805 458919 467699 468490 468589 470332 473063 474647 479676 480419 482797 491464 492484 494349 494351 494361 495367 497452 497570 507899 508534 508826 513015 517864 520409 523292 525962 534047 535749 536869 536911 536932 537498 538454 540985 545596 551321 554366 558307 559163 559293 560621 560622 561309 564608 565395 565402 565436 565916 568190 570197 570312 570468 572416 573026 574480 574855 575121 575482 575510 575725 578380 580122 583541 590244 597113 597120 598014 601710 603038 603096 603875 604506 605562 606546 609876 622583 623288 630292 630544 630566 630586 636053 637750 676073 677362 693967 720033 728072 743159 745246 814800 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (7.88%) |
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 606546 623288 636053 630586 745246 395567 428408 494349 523292 497570 381912 6663 430290 433883 468589 492484 458919 480419 508534 535749 494351 537498 494361 479676 578380 551321 558307 575121 575510 559293 568190 570197 676073 677362 565916 603038 603096 609876 622583 451570 406002 473063 411637 416236 491464 495367 513015 525962 388826 434716 443231 430400 444748 814800 446873 446972 455805 468490 536932 538454 536911 540985 560621 570312 575725 559163 564608 570468 565395 573026 560622 565402 572416 574480 630566 630292 637750 590244 605562 728072 743159 601710 404234 474647 395499 446632 399358 425694 436030 536869 508826 517864 507899 603875 497452 392458 353401 398740 415735 482797 470332 445623 520409 534047 467699 575482 545596 565436 583541 720033 693967 554366 561309 574855 580122 598014 604506 597113 597120 630544 ] |
||||||||||||||||||||||||||||||
|
2.44 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 6663 353401 381912 388826 392458 395499 395567 398740 399358 404234 406002 411637 415735 416236 425694 428408 430290 430400 433883 434716 436030 443231 444748 445623 446632 446873 446972 451570 455805 458919 467699 468490 468589 470332 473063 474647 479676 480419 482797 491464 492484 494349 494351 494361 495367 497452 497570 507899 508534 508826 513015 517864 520409 523292 525962 534047 535749 536869 536911 536932 537498 538454 540985 545596 551321 554366 558307 559163 559293 560621 560622 561309 564608 565395 565402 565436 565916 568190 570197 570312 570468 572416 573026 574480 574855 575121 575482 575510 575725 578380 580122 583541 590244 597113 597120 598014 601710 603038 603096 603875 604506 605562 606546 609876 622583 623288 630292 630544 630566 630586 636053 637750 676073 677362 693967 720033 728072 743159 745246 814800 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc skinny fuck"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc худые секс"
]
|
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.