Query Metrics
7
Database Queries
7
Different statements
151.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.18 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 386178 390986 393585 401342 401426 401480 401482 401615 402219 403343 404368 406083 406085 411895 415199 415320 417003 417384 417647 417735 418494 418683 423455 423471 424347 427585 427786 429214 440911 442973 446036 446534 451320 454635 456128 457138 457512 458385 460769 461680 464211 465120 468339 470355 475600 476117 476128 477689 478043 479018 479590 485057 488697 492670 496859 497174 500620 504321 508197 516511 518472 520323 525462 531347 531656 533643 542212 551234 554077 559018 564891 566929 581188 582697 585971 587477 591747 592322 592644 604215 606595 615692 621125 635081 642244 661991 668713 670915 673122 682507 693509 699581 716613 719461 719776 719927 722809 732878 737561 744320 757867 760942 761600 765940 767011 770202 776784 781810 782539 783625 789455 795319 805146 805875 806514 806947 817608 818569 821399 822309 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (9.11%) |
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 508197 497174 670915 767011 446534 554077 699581 673122 760942 822309 635081 782539 757867 661991 693509 458385 591747 402219 592322 765940 496859 642244 604215 744320 776784 423455 737561 488697 817608 783625 795319 682507 401480 719461 606595 468339 500620 806514 806947 465120 417003 592644 761600 475600 585971 386178 551234 559018 542212 460769 406083 818569 716613 429214 477689 390986 446036 504321 464211 411895 461680 401426 722809 401342 415320 470355 566929 587477 520323 401615 417384 457512 516511 581188 427585 531347 564891 479590 404368 451320 417735 427786 415199 492670 485057 478043 401482 615692 479018 424347 417647 533643 531656 418494 418683 582697 456128 525462 442973 457138 476128 805146 518472 406085 440911 476117 732878 393585 454635 621125 781810 770202 423471 719776 805875 821399 403343 668713 719927 789455 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.93%) |
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 386178 390986 393585 401342 401426 401480 401482 401615 402219 403343 404368 406083 406085 411895 415199 415320 417003 417384 417647 417735 418494 418683 423455 423471 424347 427585 427786 429214 440911 442973 446036 446534 451320 454635 456128 457138 457512 458385 460769 461680 464211 465120 468339 470355 475600 476117 476128 477689 478043 479018 479590 485057 488697 492670 496859 497174 500620 504321 508197 516511 518472 520323 525462 531347 531656 533643 542212 551234 554077 559018 564891 566929 581188 582697 585971 587477 591747 592322 592644 604215 606595 615692 621125 635081 642244 661991 668713 670915 673122 682507 693509 699581 716613 719461 719776 719927 722809 732878 737561 744320 757867 760942 761600 765940 767011 770202 776784 781810 782539 783625 789455 795319 805146 805875 806514 806947 817608 818569 821399 822309 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep in sex"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep секс"
]
|
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.