Query Metrics
7
Database Queries
7
Different statements
186.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.05 ms (87.08%) |
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 390397 406900 414134 417737 425643 426487 427180 433067 439516 442439 443487 444802 447877 448006 451024 452711 453126 457343 459378 461401 463016 467743 469042 470509 470663 472333 474909 476227 476230 478499 485675 487946 489431 489652 493231 495303 496281 499795 502315 504572 507095 509591 515304 515555 516220 517965 521756 524862 525892 527602 527970 528416 528618 528882 528894 530312 532428 533313 535657 535960 537278 547126 548233 548326 549335 551909 551922 559581 559760 561508 567549 568177 569547 572290 572840 574888 577640 579511 580978 581987 583675 584713 584714 585428 585693 596599 597887 598893 599227 601580 601990 603215 610595 613663 616347 618787 621434 622335 624480 626824 628394 650020 663724 663992 666690 668005 676154 678481 679200 683953 688203 692435 731345 744912 767495 771881 773453 787586 819240 828872 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (7.64%) |
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 626824 470663 668005 597887 535657 495303 548326 515304 516220 773453 663724 452711 414134 580978 406900 461401 574888 470509 787586 666690 676154 485675 547126 603215 425643 744912 528894 601580 528618 616347 537278 525892 548233 533313 489431 467743 551922 474909 561508 496281 527970 599227 439516 493231 549335 613663 521756 572290 585428 476227 610595 731345 507095 569547 459378 551909 567549 650020 581987 527602 487946 478499 528882 679200 469042 476230 532428 683953 444802 598893 688203 577640 504572 447877 442439 622335 502315 433067 443487 628394 515555 535960 559760 448006 427180 530312 678481 451024 517965 624480 417737 463016 472333 584714 568177 596599 528416 579511 618787 426487 583675 457343 509591 524862 767495 559581 585693 621434 771881 601990 572840 453126 499795 390397 692435 663992 819240 489652 584713 828872 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.76%) |
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 390397 406900 414134 417737 425643 426487 427180 433067 439516 442439 443487 444802 447877 448006 451024 452711 453126 457343 459378 461401 463016 467743 469042 470509 470663 472333 474909 476227 476230 478499 485675 487946 489431 489652 493231 495303 496281 499795 502315 504572 507095 509591 515304 515555 516220 517965 521756 524862 525892 527602 527970 528416 528618 528882 528894 530312 532428 533313 535657 535960 537278 547126 548233 548326 549335 551909 551922 559581 559760 561508 567549 568177 569547 572290 572840 574888 577640 579511 580978 581987 583675 584713 584714 585428 585693 596599 597887 598893 599227 601580 601990 603215 610595 613663 616347 618787 621434 622335 624480 626824 628394 650020 663724 663992 666690 668005 676154 678481 679200 683953 688203 692435 731345 744912 767495 771881 773453 787586 819240 828872 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in public"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.73%) |
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.