Query Metrics
7
Database Queries
7
Different statements
425.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.01 ms (49.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian homemade orgasm"
]
|
||||||||||||||||||||||||||||||
|
189.63 ms (44.56%) |
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 418554 418714 425319 426696 426762 433452 434307 434335 435398 436440 437861 439052 440980 441050 442382 442855 444913 445383 446578 447712 450077 450599 451251 452431 452764 456229 456917 460754 464721 467875 470122 470188 478384 478797 480004 481968 482869 484241 484371 488260 489207 492994 495235 495294 495501 496809 499164 499444 503712 504717 509584 510362 511955 512753 519744 521481 523429 524194 524447 525395 525801 525884 526563 527624 527641 527825 528143 528544 528846 529505 544404 547779 548441 548633 549738 552354 552356 552814 553609 554952 555091 555982 558323 560225 564744 564745 564988 566766 567172 568098 570994 573389 574083 579344 587059 592355 593485 594245 595088 596637 598213 599193 605200 605742 609227 613676 617047 621745 625553 626437 637444 642389 664441 672817 706567 763437 770410 772479 777257 801560 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (3.79%) |
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 574083 525395 488260 460754 552354 598213 706567 672817 552356 605200 637444 642389 596637 617047 548441 548633 599193 444913 464721 480004 418714 426762 434335 450599 527641 528143 489207 495294 528846 470122 426696 499444 605742 527624 526563 547779 560225 558323 564988 544404 549738 554952 564745 570994 664441 552814 564744 594245 609227 626437 595088 613676 777257 772479 418554 433452 481968 456917 436440 437861 445383 450077 425319 442382 519744 524447 523429 527825 499164 521481 528544 529505 439052 496809 553609 440980 456229 467875 482869 511955 524194 492994 503712 555982 434307 435398 525884 593485 442855 451251 566766 567172 555091 573389 568098 621745 592355 625553 801560 770410 452764 478384 447712 452431 446578 478797 441050 484241 509584 495235 495501 512753 525801 484371 504717 510362 587059 763437 470188 579344 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (0.77%) |
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 418554 418714 425319 426696 426762 433452 434307 434335 435398 436440 437861 439052 440980 441050 442382 442855 444913 445383 446578 447712 450077 450599 451251 452431 452764 456229 456917 460754 464721 467875 470122 470188 478384 478797 480004 481968 482869 484241 484371 488260 489207 492994 495235 495294 495501 496809 499164 499444 503712 504717 509584 510362 511955 512753 519744 521481 523429 524194 524447 525395 525801 525884 526563 527624 527641 527825 528143 528544 528846 529505 544404 547779 548441 548633 549738 552354 552356 552814 553609 554952 555091 555982 558323 560225 564744 564745 564988 566766 567172 568098 570994 573389 574083 579344 587059 592355 593485 594245 595088 596637 598213 599193 605200 605742 609227 613676 617047 621745 625553 626437 637444 642389 664441 672817 706567 763437 770410 772479 777257 801560 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск домашн любительск orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск домашн любительск orgasm"
]
|
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.