Query Metrics
7
Database Queries
7
Different statements
421.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
395.39 ms (93.90%) |
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 393245 400719 419987 422493 423531 423963 434401 434741 439488 444103 444915 445756 455370 455763 456260 456264 457805 458472 459159 460285 460575 462296 469121 469799 470539 470677 472038 475556 475587 476030 477370 478711 479292 479356 480111 481282 483671 486588 488989 488992 489942 492458 492648 494161 494801 495257 501072 501608 502843 502884 502989 512769 513473 513695 514160 519366 520339 522927 525934 525955 525984 527279 528133 535462 536412 540823 546788 549546 549800 555694 556007 556890 559738 562366 565020 568722 573515 576165 586381 590188 611414 613320 620234 620259 623355 626905 634968 657782 659225 687101 688146 691306 712546 712549 718771 723234 725476 738957 739556 740229 750724 750739 753515 758307 771366 774575 779213 779490 780085 783154 783162 790549 791456 791566 795983 797139 804982 805134 805136 810574 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (3.92%) |
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 469121 456260 458472 455763 457805 528133 501608 525934 535462 479292 419987 434401 472038 481282 519366 562366 565020 576165 691306 718771 723234 712546 626905 634968 613320 805136 779490 790549 750724 750739 739556 740229 725476 758307 774575 783154 393245 475587 470677 460285 462296 556007 439488 445756 456264 476030 486588 495257 512769 513695 525984 688146 540823 478711 568722 469799 488992 470539 494161 573515 780085 400719 514160 611414 791456 434741 502884 488989 477370 444103 492648 494801 738957 502843 590188 459159 659225 549800 475556 479356 502989 522927 492458 555694 444915 525955 483671 423531 712549 513473 455370 422493 520339 423963 460575 480111 536412 527279 501072 489942 546788 549546 559738 687101 657782 556890 620259 586381 623355 791566 795983 804982 805134 783162 810574 797139 771366 753515 620234 779213 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (0.69%) |
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 393245 400719 419987 422493 423531 423963 434401 434741 439488 444103 444915 445756 455370 455763 456260 456264 457805 458472 459159 460285 460575 462296 469121 469799 470539 470677 472038 475556 475587 476030 477370 478711 479292 479356 480111 481282 483671 486588 488989 488992 489942 492458 492648 494161 494801 495257 501072 501608 502843 502884 502989 512769 513473 513695 514160 519366 520339 522927 525934 525955 525984 527279 528133 535462 536412 540823 546788 549546 549800 555694 556007 556890 559738 562366 565020 568722 573515 576165 586381 590188 611414 613320 620234 620259 623355 626905 634968 657782 659225 687101 688146 691306 712546 712549 718771 723234 725476 738957 739556 740229 750724 750739 753515 758307 771366 774575 779213 779490 780085 783154 783162 790549 791456 791566 795983 797139 804982 805134 805136 810574 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife public"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск жен на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.33%) |
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.