Query Metrics
7
Database Queries
7
Different statements
163.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.34 ms (83.76%) |
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 124361 205794 387296 388426 388784 390653 396711 397992 398467 406288 407722 411737 411756 411769 411998 413454 416047 443189 445669 446853 446867 448620 448623 448631 450181 452378 452415 452856 453127 453143 454408 459764 460254 460331 466790 474397 474410 474871 476338 476966 479690 479769 483137 485923 487913 491628 500472 505562 507128 508162 512046 515083 516076 516138 518838 520275 525495 534001 538566 549238 549242 550650 551924 554499 557168 566814 580088 599735 621400 623477 624474 624790 636557 663375 664961 665115 665195 665278 665359 665364 665391 665476 665499 665867 665895 666754 667669 681640 712809 729100 731170 733497 738239 739709 742241 742695 744232 746658 746735 754133 758293 758441 766660 774328 779198 780670 781646 781657 782203 782256 782268 788556 788721 789215 789407 802315 803373 816771 817393 825241 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (9.36%) |
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 817393 485923 538566 663375 665115 665195 665499 681640 665391 665895 599735 621400 788556 788721 789215 779198 780670 781657 729100 789407 739709 754133 733497 746658 738239 758293 623477 636557 782256 448631 474397 500472 390653 411998 450181 452415 452378 491628 507128 665476 666754 667669 712809 774328 411737 580088 731170 742695 781646 124361 443189 508162 453127 452856 476966 505562 512046 549238 802315 397992 411756 487913 474410 411769 388426 406288 525495 516138 624474 803373 746735 766660 387296 479690 566814 782268 744232 413454 398467 416047 407722 474871 459764 453143 454408 520275 534001 479769 483137 551924 557168 476338 205794 516076 816771 742241 396711 445669 446853 460331 518838 758441 624790 446867 448620 388784 554499 466790 825241 460254 448623 515083 549242 550650 665867 664961 665359 665364 665278 782203 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.18%) |
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 124361 205794 387296 388426 388784 390653 396711 397992 398467 406288 407722 411737 411756 411769 411998 413454 416047 443189 445669 446853 446867 448620 448623 448631 450181 452378 452415 452856 453127 453143 454408 459764 460254 460331 466790 474397 474410 474871 476338 476966 479690 479769 483137 485923 487913 491628 500472 505562 507128 508162 512046 515083 516076 516138 518838 520275 525495 534001 538566 549238 549242 550650 551924 554499 557168 566814 580088 599735 621400 623477 624474 624790 636557 663375 664961 665115 665195 665278 665359 665364 665391 665476 665499 665867 665895 666754 667669 681640 712809 729100 731170 733497 738239 739709 742241 742695 744232 746658 746735 754133 758293 758441 766660 774328 779198 780670 781646 781657 782203 782256 782268 788556 788721 789215 789407 802315 803373 816771 817393 825241 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.