Query Metrics
7
Database Queries
7
Different statements
358.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.38 ms (59.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepsister русск"
]
|
||||||||||||||||||||||||||||||
|
123.62 ms (34.53%) |
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 341041 391591 426932 429776 432520 433755 437779 456749 457513 458322 458879 459715 461684 465772 468864 470228 476874 483442 485604 494587 494596 504055 505172 507410 508626 512596 518797 520090 546916 558638 561166 568809 579977 585138 587893 598006 603984 609383 616526 616946 619051 619557 621291 627005 636127 651762 673896 675582 682403 685441 687383 696076 696395 700905 705164 705574 707587 709561 712420 717046 727328 728455 729702 730607 731494 735246 735854 740803 741235 741841 742006 743638 745280 745670 749878 751149 751276 760617 766188 767389 768360 769072 769263 770626 772056 772827 777256 777979 778267 778965 779075 779303 779802 780029 780520 781204 782319 785810 786260 787373 787534 788071 789930 791736 793018 793892 795521 799727 799828 807284 807349 809576 809974 810880 811660 812447 813326 813369 816182 ] |
||||||||||||||||||||||||||||||
|
14.17 ms (3.96%) |
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 809576 470228 458879 485604 391591 483442 494587 568809 673896 558638 587893 603984 627005 456749 461684 433755 476874 426932 429776 432520 437779 457513 458322 459715 465772 341041 468864 507410 518797 508626 520090 504055 505172 585138 816182 828561 494596 512596 579977 705164 709561 682403 685441 696076 696395 707587 717046 651762 675582 687383 700905 705574 546916 561166 598006 619557 636127 621291 616946 609383 616526 619051 777256 779075 780029 780520 786260 793892 813326 813369 777979 778965 779802 785810 787534 788071 799828 807284 809974 810880 811660 812447 729702 741235 741841 767389 769072 772827 787373 789930 791736 793018 795521 799727 807349 730607 742006 745670 749878 751276 727328 728455 735854 766188 740803 743638 745280 768360 769263 770626 731494 735246 751149 760617 772056 712420 778267 779303 781204 782319 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.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 341041 391591 426932 429776 432520 433755 437779 456749 457513 458322 458879 459715 461684 465772 468864 470228 476874 483442 485604 494587 494596 504055 505172 507410 508626 512596 518797 520090 546916 558638 561166 568809 579977 585138 587893 598006 603984 609383 616526 616946 619051 619557 621291 627005 636127 651762 673896 675582 682403 685441 687383 696076 696395 700905 705164 705574 707587 709561 712420 717046 727328 728455 729702 730607 731494 735246 735854 740803 741235 741841 742006 743638 745280 745670 749878 751149 751276 760617 766188 767389 768360 769072 769263 770626 772056 772827 777256 777979 778267 778965 779075 779303 779802 780029 780520 781204 782319 785810 786260 787373 787534 788071 789930 791736 793018 793892 795521 799727 799828 807284 807349 809576 809974 810880 811660 812447 813326 813369 816182 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepsister russian"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepsister русск"
]
|
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.