Query Metrics
7
Database Queries
7
Different statements
116.95 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.88 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen car sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 10.39 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 543480 638326 491406 581025 485475 408532 395686 519701 530776 443593 413499 528074 561023 614693 397413 530779 621543 594920 421238 451772 528440 574162 585154 597142 604103 698981 705791 594144 390813 492608 494620 569047 589761 429943 573914 586628 493284 485481 574155 689634 572544 480024 574179 463519 525102 541866 817402 526188 491678 599826 420472 443503 623849 711642 804277 816183 817507 470288 632020 530061 445641 484924 822024 484870 822296 753467 512909 698972 574857 504595 564348 549063 123029 470531 478491 516433 600501 775235 427174 510126 580715 461624 536004 472712 602614 396168 587933 ] |
||||||||||||||||||||||||||||||
| 4 | 2.53 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 123029 390813 395686 396168 397413 408532 413499 420472 421238 427174 429943 443503 443593 445641 451772 461624 463519 470288 470531 472712 478491 480024 484870 484924 485475 485481 491406 491678 492608 493284 494620 504595 510126 512909 516433 519701 525102 526188 528074 528440 530061 530776 530779 536004 541866 543480 549063 561023 564348 569047 572544 573914 574155 574162 574179 574857 580715 581025 585154 586628 587933 589761 594144 594920 597142 599826 600501 602614 604103 614693 621543 623849 632020 638326 689634 698972 698981 705791 711642 753467 775235 804277 816183 817402 817507 822024 822296 ] |
||||||||||||||||||||||||||||||
| 5 | 97.11 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 123029 390813 395686 396168 397413 408532 413499 420472 421238 427174 429943 443503 443593 445641 451772 461624 463519 470288 470531 472712 478491 480024 484870 484924 485475 485481 491406 491678 492608 493284 494620 504595 510126 512909 516433 519701 525102 526188 528074 528440 530061 530776 530779 536004 541866 543480 549063 561023 564348 569047 572544 573914 574155 574162 574179 574857 580715 581025 585154 586628 587933 589761 594144 594920 597142 599826 600501 602614 604103 614693 621543 623849 632020 638326 689634 698972 698981 705791 711642 753467 775235 804277 816183 817402 817507 822024 822296 ] |
||||||||||||||||||||||||||||||
| 6 | 1.45 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen вмашин секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.84 ms |
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.