Query Metrics
7
Database Queries
7
Different statements
363.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.48 ms (57.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
134.47 ms (36.95%) |
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 8925 151018 210355 234306 325228 388555 391574 391735 391995 398543 398552 407809 420334 439752 440951 459837 460411 460923 466902 470017 479085 483649 483656 485763 485947 492977 493177 499778 504013 522003 523845 526747 530538 530567 531058 535744 539750 543656 546142 549740 554848 557244 558000 558288 559283 570883 570972 585296 589580 591064 591977 599710 618682 642390 680297 693254 718444 718524 721922 724476 726107 726511 728146 732963 733265 733473 734272 735882 735981 738795 740662 741764 742387 742780 742873 744414 745656 746173 746642 746739 749604 754278 755065 759766 766264 766608 766613 770242 794745 796125 796128 796808 800567 800717 800976 801977 804430 804435 806309 808125 819966 823737 823978 824087 824293 824442 825401 825438 825977 825978 826289 826370 826373 826379 826603 826687 826688 827399 827408 827690 ] |
||||||||||||||||||||||||||||||
|
11.44 ms (3.14%) |
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 420334 210355 391735 504013 558288 398543 693254 746173 759766 440951 485947 539750 599710 742873 794745 804435 234306 398552 824442 530538 549740 570972 591064 642390 585296 589580 800976 801977 733265 796125 766613 726511 770242 728146 742387 718524 796128 796808 459837 391995 460411 479085 526747 485763 724476 522003 499778 559283 492977 391574 407809 460923 557244 591977 741764 439752 470017 483649 483656 523845 493177 558000 680297 746739 530567 325228 8925 388555 823978 825401 825977 826373 826603 826687 826688 823737 824087 825978 826289 827408 827399 819966 824293 825438 826370 826379 827690 466902 531058 535744 543656 570883 718444 721922 546142 554848 804430 806309 733473 800567 800717 808125 734272 745656 732963 744414 754278 766264 742780 746642 755065 726107 735882 735981 738795 740662 749604 766608 618682 151018 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.65%) |
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 8925 151018 210355 234306 325228 388555 391574 391735 391995 398543 398552 407809 420334 439752 440951 459837 460411 460923 466902 470017 479085 483649 483656 485763 485947 492977 493177 499778 504013 522003 523845 526747 530538 530567 531058 535744 539750 543656 546142 549740 554848 557244 558000 558288 559283 570883 570972 585296 589580 591064 591977 599710 618682 642390 680297 693254 718444 718524 721922 724476 726107 726511 728146 732963 733265 733473 734272 735882 735981 738795 740662 741764 742387 742780 742873 744414 745656 746173 746642 746739 749604 754278 755065 759766 766264 766608 766613 770242 794745 796125 796128 796808 800567 800717 800976 801977 804430 804435 806309 808125 819966 823737 823978 824087 824293 824442 825401 825438 825977 825978 826289 826370 826373 826379 826603 826687 826688 827399 827408 827690 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск chubby mature"
]
|
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.