Query Metrics
7
Database Queries
7
Different statements
150.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (80.57%) |
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 123029 390813 395686 397413 408532 413499 419132 420472 421238 422671 425473 427174 429943 443503 443593 443644 445641 445833 451772 454954 461008 463519 469042 470288 470531 472343 472345 478491 480024 481134 484870 484924 485475 485481 491406 491678 492519 492598 492608 493284 494620 498899 504595 510126 512909 516433 518049 519701 521454 523082 523099 525102 526188 527633 528074 528440 529185 529222 530061 530776 530779 536004 541866 543480 549063 551948 561023 564348 569047 572544 573914 574155 574162 574179 574857 575600 580715 581025 585154 586628 587477 589761 594144 594920 597142 597532 599826 600035 600501 604103 605941 614344 614434 614693 621543 621648 623849 632020 632356 638326 638967 674758 682460 684214 689634 698972 698981 705791 711642 743292 753467 758024 775235 804277 816183 817402 817507 818682 822024 822296 ] |
||||||||||||||||||||||||||||||
|
18.96 ms (12.59%) |
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 758024 472343 523099 454954 481134 597532 614434 445833 419132 492598 422671 523082 521454 498899 518049 527633 529222 492519 551948 682460 684214 674758 621648 632356 587477 605941 472345 818682 743292 600035 638967 408532 395686 397413 425473 443593 443644 413499 451772 469042 491406 528440 530779 528074 529185 519701 530776 574162 543480 561023 581025 585154 597142 614693 621543 614344 638326 594144 594920 604103 698981 421238 485475 575600 705791 586628 390813 429943 485481 493284 480024 526188 494620 492608 574179 574155 569047 689634 572544 573914 589761 463519 525102 817402 541866 816183 711642 623849 599826 420472 443503 491678 804277 817507 470288 632020 822024 530061 445641 484924 484870 822296 461008 753467 512909 549063 564348 698972 574857 504595 123029 600501 775235 470531 478491 516433 427174 580715 510126 536004 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.86%) |
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 123029 390813 395686 397413 408532 413499 419132 420472 421238 422671 425473 427174 429943 443503 443593 443644 445641 445833 451772 454954 461008 463519 469042 470288 470531 472343 472345 478491 480024 481134 484870 484924 485475 485481 491406 491678 492519 492598 492608 493284 494620 498899 504595 510126 512909 516433 518049 519701 521454 523082 523099 525102 526188 527633 528074 528440 529185 529222 530061 530776 530779 536004 541866 543480 549063 551948 561023 564348 569047 572544 573914 574155 574162 574179 574857 575600 580715 581025 585154 586628 587477 589761 594144 594920 597142 597532 599826 600035 600501 604103 605941 614344 614434 614693 621543 621648 623849 632020 632356 638326 638967 674758 682460 684214 689634 698972 698981 705791 711642 743292 753467 758024 775235 804277 816183 817402 817507 818682 822024 822296 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen-car"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen вмашин"
]
|
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.