Query Metrics
7
Database Queries
7
Different statements
177.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.12 ms (79.01%) |
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 420880 424237 426979 431963 432962 436481 437585 438776 438879 440655 442196 442234 442747 443029 447275 447709 447909 448434 450461 450534 450635 451149 451850 455343 455470 455514 461634 461861 463151 463195 466992 469137 469637 471517 474247 475232 476937 477014 478337 482190 482257 482997 484022 484252 488196 488201 488286 489614 489798 494298 495302 495324 497236 499333 504116 506258 506517 507948 510572 511639 511772 515651 517261 517600 517602 517881 519768 521172 521916 522293 522392 522453 522526 524274 526154 526356 535416 536154 536664 539300 541101 544016 546419 548704 551109 551450 551640 555667 559367 560041 560412 561306 566100 568392 571656 572211 572214 572323 574592 576742 580997 584290 588745 591287 593769 595029 601988 604746 612092 613599 617402 618952 630472 643939 667417 668005 680944 681209 697026 788806 ] |
||||||||||||||||||||||||||||||
|
17.85 ms (10.06%) |
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 584290 517881 469637 517600 495324 536154 539300 524274 535416 463151 572211 680944 681209 555667 572214 630472 617402 612092 788806 437585 431963 466992 455343 450461 450635 521172 484022 506517 510572 522526 420880 484252 451850 461861 482190 499333 522293 526154 494298 511772 526356 507948 541101 546419 560041 571656 572323 551450 566100 568392 576742 580997 551109 551640 559367 560412 561306 697026 668005 593769 613599 618952 595029 591287 601988 475232 438879 442234 447909 463195 476937 482257 436481 448434 455470 455514 515651 522453 488286 511639 482997 489798 506258 519768 521916 442747 447275 548704 574592 478337 488201 489614 488196 604746 474247 497236 426979 438776 443029 440655 471517 477014 461634 517602 495302 504116 517261 522392 544016 667417 588745 643939 432962 447709 424237 450534 451149 442196 536664 469137 ] |
||||||||||||||||||||||||||||||
|
10.98 ms (6.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.90%) |
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 420880 424237 426979 431963 432962 436481 437585 438776 438879 440655 442196 442234 442747 443029 447275 447709 447909 448434 450461 450534 450635 451149 451850 455343 455470 455514 461634 461861 463151 463195 466992 469137 469637 471517 474247 475232 476937 477014 478337 482190 482257 482997 484022 484252 488196 488201 488286 489614 489798 494298 495302 495324 497236 499333 504116 506258 506517 507948 510572 511639 511772 515651 517261 517600 517602 517881 519768 521172 521916 522293 522392 522453 522526 524274 526154 526356 535416 536154 536664 539300 541101 544016 546419 548704 551109 551450 551640 555667 559367 560041 560412 561306 566100 568392 571656 572211 572214 572323 574592 576742 580997 584290 588745 591287 593769 595029 601988 604746 612092 613599 617402 618952 630472 643939 667417 668005 680944 681209 697026 788806 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur stranger"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск stranger"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск stranger"
]
|
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.