Query Metrics
7
Database Queries
7
Different statements
193.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.53 ms (87.13%) |
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 153618 382713 384416 390966 393865 398019 405507 429561 446286 460205 466733 468629 469061 478107 480553 481874 482207 485887 486252 510287 513728 518312 523352 527151 527249 532094 540363 557527 569415 570150 571508 574561 584872 588262 599589 599795 601234 629844 630233 682181 704716 721140 724227 730059 730085 732065 733614 733817 736154 737064 737072 738861 741303 743392 743986 744796 744925 745034 746772 747919 747927 752896 755002 756311 760613 768912 769993 771599 772713 777439 779705 784304 785662 789972 789982 792564 793538 794980 795144 797769 797781 797844 799386 800257 801334 803007 803289 803548 804591 804961 805440 806944 807411 807792 808127 809723 810642 813788 813789 814344 814626 815288 815352 815678 816941 817174 817539 817942 818550 819482 820120 820334 821007 821010 822585 823001 823051 823243 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (7.20%) |
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 797769 797844 800257 801334 803007 804961 805440 806944 807411 737064 744796 747927 730059 730085 733614 744925 746772 752896 755002 769993 771220 732065 741303 743986 745034 771599 771983 724227 733817 736154 737072 738861 747919 756311 760613 768912 772713 704716 777439 779705 785662 789972 789982 792564 793538 795144 797781 799386 803289 803548 804591 807792 808127 810642 390966 384416 599589 405507 468629 480553 446286 527151 518312 682181 571508 601234 784304 469061 393865 478107 481874 523352 513728 486252 510287 527249 466733 569415 429561 153618 398019 813789 821010 482207 460205 540363 485887 599795 630233 743392 721140 794980 382713 814626 532094 570150 584872 574561 557527 588262 629844 809723 813788 814344 815288 815352 815678 816941 817174 817539 817942 818550 819482 820120 820334 821007 822585 823001 823051 823243 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.96%) |
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 153618 382713 384416 390966 393865 398019 405507 429561 446286 460205 466733 468629 469061 478107 480553 481874 482207 485887 486252 510287 513728 518312 523352 527151 527249 532094 540363 557527 569415 570150 571508 574561 584872 588262 599589 599795 601234 629844 630233 682181 704716 721140 724227 730059 730085 732065 733614 733817 736154 737064 737072 738861 741303 743392 743986 744796 744925 745034 746772 747919 747927 752896 755002 756311 760613 768912 769993 771599 772713 777439 779705 784304 785662 789972 789982 792564 793538 794980 795144 797769 797781 797844 799386 800257 801334 803007 803289 803548 804591 804961 805440 806944 807411 807792 808127 809723 810642 813788 813789 814344 814626 815288 815352 815678 816941 817174 817539 817942 818550 819482 820120 820334 821007 821010 822585 823001 823051 823243 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tattoo mom"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные mom"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"татуированные mom"
]
|
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.