Query Metrics
7
Database Queries
7
Different statements
170.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.25 ms (84.47%) |
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 131512 187974 191715 234306 240982 302756 369353 384447 385682 387649 389424 398247 398348 401216 407803 412793 415582 423351 425275 426466 427658 443747 444063 445578 445739 448537 450305 452657 454396 454555 455579 456822 457847 458333 458394 458462 460503 461368 461601 462398 465441 466432 466847 469297 469494 469903 476995 479535 483497 486756 491610 493135 503830 504216 504981 505333 511312 511962 518538 522020 522752 526694 529285 530124 531461 535206 545405 554772 555065 555135 555138 559005 563648 567081 567399 569166 579074 596512 596517 601183 605581 607631 620252 623978 624883 649227 654270 663244 678221 679455 684977 692854 716765 719192 719896 725089 742348 742714 765516 771211 775770 776954 778616 779359 781189 785353 785921 787632 793811 795158 795934 798581 801145 806973 808080 808858 809410 813459 819019 819699 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (9.90%) |
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 545405 684977 776954 389424 387649 423351 491610 555065 555135 187974 596512 623978 493135 778616 469494 456822 765516 425275 785921 771211 742714 787632 819699 579074 445578 716765 624883 407803 719192 663244 798581 601183 483497 555138 620252 401216 131512 384447 302756 503830 458394 448537 461368 719896 462398 522020 412793 567081 443747 444063 454555 511962 240982 654270 415582 450305 535206 454396 504216 234306 398247 461601 505333 526694 607631 605581 801145 781189 785353 793811 809410 398348 426466 466432 452657 476995 567399 445739 795158 692854 458462 427658 457847 529285 569166 479535 511312 504981 649227 191715 808080 725089 466847 531461 819019 486756 460503 385682 775770 518538 530124 469297 559005 554772 679455 678221 808858 806973 795934 813459 779359 469903 458333 455579 465441 369353 522752 563648 596517 742348 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.79%) |
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 131512 187974 191715 234306 240982 302756 369353 384447 385682 387649 389424 398247 398348 401216 407803 412793 415582 423351 425275 426466 427658 443747 444063 445578 445739 448537 450305 452657 454396 454555 455579 456822 457847 458333 458394 458462 460503 461368 461601 462398 465441 466432 466847 469297 469494 469903 476995 479535 483497 486756 491610 493135 503830 504216 504981 505333 511312 511962 518538 522020 522752 526694 529285 530124 531461 535206 545405 554772 555065 555135 555138 559005 563648 567081 567399 569166 579074 596512 596517 601183 605581 607631 620252 623978 624883 649227 654270 663244 678221 679455 684977 692854 716765 719192 719896 725089 742348 742714 765516 771211 775770 776954 778616 779359 781189 785353 785921 787632 793811 795158 795934 798581 801145 806973 808080 808858 809410 813459 819019 819699 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde wife blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая жен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая жен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.81%) |
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.