Query Metrics
7
Database Queries
7
Different statements
142.49 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"valentina nappi xxx"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.52 ms |
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 593220 551022 713573 643934 798083 550586 555892 676271 676793 775045 804154 551117 805398 810979 512980 453745 410687 722546 647641 671579 590858 635916 805586 810975 755453 382188 399408 673630 676372 685578 676799 643928 439207 11582 534019 624799 624802 624804 596330 632333 677319 662048 477744 693188 637749 385910 404690 439186 634477 612080 527040 624806 604627 814903 817141 815264 387507 816879 185332 33353 821186 817131 401071 97047 384282 817794 533467 47854 425579 31627 817127 821909 527999 685579 464257 822693 385344 430748 815490 590885 387039 431371 601707 471366 451262 620871 499598 ] |
||||||||||||||||||||||||||||||
| 4 | 2.04 ms |
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 11582 31627 33353 47854 97047 185332 382188 384282 385344 385910 387039 387507 399408 401071 404690 410687 425579 430748 431371 439186 439207 451262 453745 464257 471366 477744 499598 512980 527040 527999 533467 534019 550586 551022 551117 555892 590858 590885 593220 596330 601707 604627 612080 620871 624799 624802 624804 624806 632333 634477 635916 637749 643928 643934 647641 662048 671579 673630 676271 676372 676793 676799 677319 685578 685579 693188 713573 722546 755453 775045 798083 804154 805398 805586 810975 810979 814903 815264 815490 816879 817127 817131 817141 817794 821186 821909 822693 ] |
||||||||||||||||||||||||||||||
| 5 | 121.96 ms |
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 11582 31627 33353 47854 97047 185332 382188 384282 385344 385910 387039 387507 399408 401071 404690 410687 425579 430748 431371 439186 439207 451262 453745 464257 471366 477744 499598 512980 527040 527999 533467 534019 550586 551022 551117 555892 590858 590885 593220 596330 601707 604627 612080 620871 624799 624802 624804 624806 632333 634477 635916 637749 643928 643934 647641 662048 671579 673630 676271 676372 676793 676799 677319 685578 685579 693188 713573 722546 755453 775045 798083 804154 805398 805586 810975 810979 814903 815264 815490 816879 817127 817131 817141 817794 821186 821909 822693 ] |
||||||||||||||||||||||||||||||
| 6 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"valentinanappi xxx"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.24 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"valentinanappi xxx"
]
|
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.