Query Metrics
7
Database Queries
7
Different statements
195.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.49 ms (86.33%) |
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 48547 78760 145635 292790 335455 353299 381748 382691 382799 386283 386688 387477 391773 392493 393151 393694 395330 400685 401387 401632 402576 403685 406021 415757 418138 420425 421956 429862 435537 435583 441610 447040 458333 464390 470912 478728 479368 486223 498765 500094 509430 510856 511274 511683 511798 513815 515838 544752 551734 553344 555017 555938 556340 560261 560286 564858 567681 577609 585207 586711 589199 594090 605278 607072 614281 614875 617145 621865 623951 626072 626104 628755 652681 659168 682914 689121 693011 701557 702525 714487 717801 720152 722395 722923 723196 724573 725767 729333 729351 746215 746546 750602 753971 761564 762240 763776 764086 764246 775715 775846 778926 779546 781164 782086 786851 787679 788433 789911 791504 791764 792338 796381 796532 797744 798533 803161 803857 804857 811449 818173 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (7.74%) |
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 746215 764086 804857 762240 701557 717801 723196 787679 796381 803161 48547 335455 381748 818173 382799 401632 403685 513815 382691 553344 509430 486223 479368 458333 478728 515838 386283 145635 393151 392493 292790 78760 387477 402576 415757 420425 500094 551734 577609 659168 689121 702525 722923 693011 720152 589199 607072 617145 623951 628755 586711 779546 791764 786851 788433 796532 798533 811449 729351 761564 789911 792338 803857 753971 764246 725767 729333 746546 724573 763776 614281 775715 778926 782086 797744 353299 391773 395330 400685 386688 401387 652681 393694 435537 441610 421956 447040 464390 498765 510856 511274 511683 511798 470912 560261 555017 556340 567681 544752 564858 714487 722395 682914 555938 560286 594090 621865 585207 605278 614875 626072 775846 781164 750602 626104 791504 406021 418138 429862 435583 ] |
||||||||||||||||||||||||||||||
|
4.26 ms (2.19%) |
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 48547 78760 145635 292790 335455 353299 381748 382691 382799 386283 386688 387477 391773 392493 393151 393694 395330 400685 401387 401632 402576 403685 406021 415757 418138 420425 421956 429862 435537 435583 441610 447040 458333 464390 470912 478728 479368 486223 498765 500094 509430 510856 511274 511683 511798 513815 515838 544752 551734 553344 555017 555938 556340 560261 560286 564858 567681 577609 585207 586711 589199 594090 605278 607072 614281 614875 617145 621865 623951 626072 626104 628755 652681 659168 682914 689121 693011 701557 702525 714487 717801 720152 722395 722923 723196 724573 725767 729333 729351 746215 746546 750602 753971 761564 762240 763776 764086 764246 775715 775846 778926 779546 781164 782086 786851 787679 788433 789911 791504 791764 792338 796381 796532 797744 798533 803161 803857 804857 811449 818173 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette wife"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
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.