Query Metrics
7
Database Queries
7
Different statements
175.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.21 ms (84.65%) |
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 393055 400497 405850 407524 415342 415834 421835 421892 421895 421897 422141 425999 427364 428124 431759 433359 439526 439560 439570 439635 439710 439758 440780 440956 440980 443085 448970 452179 455514 456057 456287 457226 457466 457769 459956 461805 463305 464240 466059 466109 466317 470389 470585 470611 470654 471613 472955 472958 473950 474014 474188 478365 489940 491114 491943 493191 493300 495302 500493 502712 502715 505022 505622 506438 507217 507616 510425 511033 515494 515736 518611 519354 520599 520911 522748 522953 523869 528143 528607 529153 529338 529811 537377 554399 556470 561273 564701 565937 567408 567505 567643 575243 580113 582342 582997 587416 594549 597863 599738 601444 602604 602803 606069 606576 618982 622044 627095 676591 724311 730091 732733 732905 756714 784427 793175 796881 797241 802413 812781 812795 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (10.35%) |
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 554399 565937 567408 599738 606576 622044 597863 606069 601444 602803 793175 796881 812795 732905 802413 730091 756714 618982 627095 784427 415342 456057 471613 439635 440980 457226 457769 464240 466109 474188 421835 421897 422141 439526 440956 455514 470585 474014 415834 427364 439570 448970 456287 459956 505622 522953 523869 528143 489940 493191 493300 502715 519354 520599 507217 515736 537377 491114 491943 506438 507616 528607 529153 676591 393055 518611 520911 405850 425999 443085 428124 440780 466059 470389 505022 495302 529338 529811 500493 502712 511033 522748 567643 580113 556470 567505 575243 561273 564701 582997 582342 587416 594549 602604 724311 812781 732733 797241 407524 431759 466317 478365 421892 439758 472958 473950 400497 421895 433359 439560 439710 463305 452179 461805 472955 457466 470611 470654 515494 510425 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.28%) |
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 393055 400497 405850 407524 415342 415834 421835 421892 421895 421897 422141 425999 427364 428124 431759 433359 439526 439560 439570 439635 439710 439758 440780 440956 440980 443085 448970 452179 455514 456057 456287 457226 457466 457769 459956 461805 463305 464240 466059 466109 466317 470389 470585 470611 470654 471613 472955 472958 473950 474014 474188 478365 489940 491114 491943 493191 493300 495302 500493 502712 502715 505022 505622 506438 507217 507616 510425 511033 515494 515736 518611 519354 520599 520911 522748 522953 523869 528143 528607 529153 529338 529811 537377 554399 556470 561273 564701 565937 567408 567505 567643 575243 580113 582342 582997 587416 594549 597863 599738 601444 602604 602803 606069 606576 618982 622044 627095 676591 724311 730091 732733 732905 756714 784427 793175 796881 797241 802413 812781 812795 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf home"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf home"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf home"
]
|
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.