Query Metrics
7
Database Queries
7
Different statements
199.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.47 ms (86.28%) |
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 4463 73115 188093 188282 233193 233269 233570 233996 250695 275727 361315 365962 382239 382405 382569 388364 388716 388739 391652 391956 391959 391968 392030 392600 392671 394639 395625 397214 398557 398802 398929 401830 404899 405810 407550 407783 408249 409390 411249 411762 415782 428148 439686 440927 441910 442118 442813 445634 452154 458204 466902 467397 471405 471654 474969 476234 476604 477994 480302 481918 483152 484364 485709 486810 489105 491899 494796 497007 502741 507541 516107 523018 523620 528461 549225 549731 549841 555016 562963 563190 563195 563207 571016 578734 586569 591197 591314 593372 603023 605359 614479 663897 663908 664833 665284 665468 665875 665889 667630 667762 693308 731030 731122 731140 731217 731218 737598 738341 739553 741021 742368 742637 744414 745321 746642 747188 748593 770896 797109 797785 ] |
||||||||||||||||||||||||||||||
|
17.98 ms (9.00%) |
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 471405 477994 491899 408249 480302 563195 664833 665889 663908 665468 742368 391959 404899 397214 474969 494796 563190 693308 742637 233269 388364 571016 591197 603023 731030 731217 739553 549225 549841 555016 507541 382405 233570 392030 392671 233193 233996 365962 593372 391968 394639 395625 382239 405810 407783 415782 441910 452154 486810 497007 528461 476234 549731 578734 667630 663897 665284 665875 562963 586569 797785 747188 770896 409390 467397 471654 440927 428148 516107 489105 523018 388716 388739 398557 4463 391652 275727 407550 466902 737598 741021 731140 738341 744414 746642 250695 188282 411249 605359 458204 398802 391956 382569 483152 485709 445634 484364 442813 442118 481918 439686 591314 614479 476604 502741 398929 523620 667762 797109 745321 748593 731122 731218 73115 188093 401830 563207 411762 392600 361315 ] |
||||||||||||||||||||||||||||||
|
2.56 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 4463 73115 188093 188282 233193 233269 233570 233996 250695 275727 361315 365962 382239 382405 382569 388364 388716 388739 391652 391956 391959 391968 392030 392600 392671 394639 395625 397214 398557 398802 398929 401830 404899 405810 407550 407783 408249 409390 411249 411762 415782 428148 439686 440927 441910 442118 442813 445634 452154 458204 466902 467397 471405 471654 474969 476234 476604 477994 480302 481918 483152 484364 485709 486810 489105 491899 494796 497007 502741 507541 516107 523018 523620 528461 549225 549731 549841 555016 562963 563190 563195 563207 571016 578734 586569 591197 591314 593372 603023 605359 614479 663897 663908 664833 665284 665468 665875 665889 667630 667762 693308 731030 731122 731140 731217 731218 737598 738341 739553 741021 742368 742637 744414 745321 746642 747188 748593 770896 797109 797785 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature bitch"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.