Query Metrics
7
Database Queries
7
Different statements
187.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.90 ms (89.62%) |
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 383833 399971 407141 422293 438317 458158 459730 500099 505795 507459 529691 529920 531374 537401 540453 541116 542186 554464 556080 558806 559334 560317 571318 578716 588481 588492 588890 588893 593813 603326 603828 603945 606334 609081 616039 616095 620968 621669 627213 627854 629623 629957 630666 634566 634585 638168 642274 644169 648119 650095 662002 664575 664621 665952 666390 667235 669315 672881 674524 674607 676552 676673 677981 684433 684486 685233 687403 689524 690633 701957 702010 710085 711723 712205 712217 714410 715700 717089 718259 718315 719153 720547 723472 724749 725445 730280 756673 759913 775610 776984 779891 780080 783682 784461 784883 790949 792166 793352 796064 800852 802307 803732 804781 807849 812625 813991 814150 819309 819690 819711 820006 823749 824982 825053 825286 825319 825355 825557 826590 826683 ] |
||||||||||||||||||||||||||||||
|
10.72 ms (5.72%) |
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 609081 796064 802307 725445 756673 803732 783682 505795 383833 531374 674524 664621 603326 629957 780080 793352 730280 724749 759913 630666 458158 578716 438317 399971 407141 422293 814150 825053 826683 826590 813991 819309 819690 823749 825319 820006 824982 819711 825286 825355 825557 459730 500099 507459 529691 529920 537401 540453 554464 559334 571318 542186 541116 556080 558806 560317 650095 664575 666390 674607 676552 684433 684486 701957 710085 717089 719153 672881 690633 711723 712205 712217 714410 718259 718315 648119 662002 665952 667235 669315 676673 677981 685233 687403 689524 702010 715700 720547 723472 588481 593813 606334 616039 621669 634566 634585 644169 588893 620968 629623 642274 588492 603828 603945 627854 588890 616095 627213 638168 776984 779891 784461 784883 790949 792166 800852 804781 807849 812625 775610 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.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 383833 399971 407141 422293 438317 458158 459730 500099 505795 507459 529691 529920 531374 537401 540453 541116 542186 554464 556080 558806 559334 560317 571318 578716 588481 588492 588890 588893 593813 603326 603828 603945 606334 609081 616039 616095 620968 621669 627213 627854 629623 629957 630666 634566 634585 638168 642274 644169 648119 650095 662002 664575 664621 665952 666390 667235 669315 672881 674524 674607 676552 676673 677981 684433 684486 685233 687403 689524 690633 701957 702010 710085 711723 712205 712217 714410 715700 717089 718259 718315 719153 720547 723472 724749 725445 730280 756673 759913 775610 776984 779891 780080 783682 784461 784883 790949 792166 793352 796064 800852 802307 803732 804781 807849 812625 813991 814150 819309 819690 819711 820006 823749 824982 825053 825286 825319 825355 825557 826590 826683 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен cumshot"
]
|
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.