Query Metrics
7
Database Queries
7
Different statements
164.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.75 ms (81.75%) |
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 7213 13118 177261 182118 213573 326289 382591 384769 388436 389273 399632 400861 401114 401148 402386 404491 404568 407266 410390 411182 411684 411841 411971 415151 418270 421857 424426 426526 426816 433505 434425 440894 442377 449893 452862 453137 454095 457221 459778 462021 462273 462352 464835 465664 470147 470404 472639 476379 477116 478005 478454 479787 480415 486610 488543 489311 493225 496997 500674 505271 506405 508560 510803 511141 512459 512964 515511 518218 518934 519046 519726 521819 523902 525634 534991 542472 549825 558914 562967 591615 604981 606752 623273 624895 646655 650066 657178 666736 668153 710362 710594 715027 719022 720154 721888 723735 725556 726219 729153 731274 731333 733371 734969 738718 740826 742797 747500 749322 761587 762104 769917 777734 798453 801298 805231 815905 817318 822421 823466 824094 ] |
||||||||||||||||||||||||||||||
|
17.67 ms (10.72%) |
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 822421 399632 384769 177261 506405 604981 488543 478454 542472 668153 710362 650066 657178 720154 721888 646655 715027 623273 801298 805231 725556 731274 731333 761587 726219 729153 749322 762104 738718 747500 769917 426526 496997 411182 389273 213573 382591 388436 459778 470404 478005 508560 472639 562967 733371 798453 740826 777734 326289 434425 13118 489311 817318 815905 824094 823466 719022 591615 606752 742797 734969 182118 411971 476379 400861 411684 440894 426816 470147 515511 512459 558914 457221 401148 415151 465664 480415 505271 519726 521819 500674 518218 486610 518934 523902 534991 666736 624895 452862 510803 519046 525634 549825 401114 404568 433505 511141 493225 723735 7213 402386 404491 407266 477116 449893 710594 411841 479787 410390 418270 421857 424426 464835 442377 453137 454095 462273 512964 462352 462021 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.52%) |
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 7213 13118 177261 182118 213573 326289 382591 384769 388436 389273 399632 400861 401114 401148 402386 404491 404568 407266 410390 411182 411684 411841 411971 415151 418270 421857 424426 426526 426816 433505 434425 440894 442377 449893 452862 453137 454095 457221 459778 462021 462273 462352 464835 465664 470147 470404 472639 476379 477116 478005 478454 479787 480415 486610 488543 489311 493225 496997 500674 505271 506405 508560 510803 511141 512459 512964 515511 518218 518934 519046 519726 521819 523902 525634 534991 542472 549825 558914 562967 591615 604981 606752 623273 624895 646655 650066 657178 666736 668153 710362 710594 715027 719022 720154 721888 723735 725556 726219 729153 731274 731333 733371 734969 738718 740826 742797 747500 749322 761587 762104 769917 777734 798453 801298 805231 815905 817318 822421 823466 824094 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big mother anal"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие мам женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.08%) |
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.