Query Metrics
7
Database Queries
7
Different statements
166.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.85 ms (84.45%) |
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 188669 400807 411767 439813 445668 451504 452936 453100 454225 454256 454267 454277 459827 459828 460340 462074 462076 462096 462307 462319 462695 463066 464965 465317 466982 466989 466996 467043 470779 472142 474826 474874 476343 477707 480480 480745 482304 483152 483360 484157 484624 484643 485060 485374 485711 485735 485749 485752 485762 485774 485777 486444 491418 496548 498019 498722 499112 502034 502467 504386 505688 507257 507659 511916 513333 514902 518842 518853 518858 518864 519151 519155 519752 522594 522760 524895 524900 525492 526212 526214 526264 526729 526843 527947 527953 529315 529341 531313 531316 538530 543924 549244 550647 554770 558286 559116 559569 560563 564292 571135 572347 573335 593347 593529 597867 604574 606349 610083 616711 640687 650614 663956 663992 666842 678778 678779 678782 678790 678791 807990 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (9.83%) |
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 188669 462076 480480 460340 470779 518842 519151 529341 485752 485762 485774 502467 483360 485374 519752 507257 507659 513333 518864 527953 466989 499112 445668 459828 462096 474826 466996 476343 526264 538530 524900 526729 527947 496548 502034 505688 514902 522594 525492 526214 485060 559116 550647 572347 543924 558286 559569 560563 650614 666842 678791 549244 571135 593529 593347 604574 606349 610083 807990 453100 462074 462695 400807 411767 451504 462307 464965 462319 472142 452936 454256 439813 454225 454267 474874 511916 522760 526843 484643 485749 485777 519155 491418 483152 484157 485711 454277 467043 482304 486444 524895 526212 480745 573335 554770 564292 663956 678778 663992 678782 678790 640687 597867 465317 463066 529315 484624 531313 498722 518853 616711 466982 459827 477707 485735 518858 498019 531316 504386 678779 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.68%) |
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 188669 400807 411767 439813 445668 451504 452936 453100 454225 454256 454267 454277 459827 459828 460340 462074 462076 462096 462307 462319 462695 463066 464965 465317 466982 466989 466996 467043 470779 472142 474826 474874 476343 477707 480480 480745 482304 483152 483360 484157 484624 484643 485060 485374 485711 485735 485749 485752 485762 485774 485777 486444 491418 496548 498019 498722 499112 502034 502467 504386 505688 507257 507659 511916 513333 514902 518842 518853 518858 518864 519151 519155 519752 522594 522760 524895 524900 525492 526212 526214 526264 526729 526843 527947 527953 529315 529341 531313 531316 538530 543924 549244 550647 554770 558286 559116 559569 560563 564292 571135 572347 573335 593347 593529 597867 604574 606349 610083 616711 640687 650614 663956 663992 666842 678778 678779 678782 678790 678791 807990 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby granny"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby granny"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby granny"
]
|
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.