Query Metrics
7
Database Queries
7
Different statements
163.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.52 ms (83.34%) |
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 392066 416296 417109 424068 424299 425570 427716 432530 432538 433145 433541 433706 439465 440164 440923 441563 442442 442469 444060 445682 446086 449991 457049 465293 466178 469161 469177 470037 482115 485281 492222 498363 499207 501387 505150 506077 506198 506591 513323 523761 527832 528959 529934 537319 539559 541280 541325 541326 542142 542151 542345 546634 548153 559280 561290 561979 563325 563728 563834 568107 569016 569199 569993 574372 574664 576915 577087 577190 578528 579178 579530 580695 582029 583027 588458 593557 593840 594166 594265 594278 594293 594300 594491 595419 596956 598436 600045 600087 601194 603285 606152 606367 606644 611172 619334 623211 624158 634071 639873 644018 658470 666728 709533 712541 713885 715790 717535 729223 752609 757393 759785 761096 762191 766764 770263 787624 800497 804639 807262 813249 ] |
||||||||||||||||||||||||||||||
|
17.58 ms (10.73%) |
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 546634 561290 569199 569993 574372 542142 542345 577190 580695 561979 576915 593557 606152 606644 588458 644018 595419 600045 601194 800497 807262 757393 761096 804639 440164 442442 469177 424068 417109 441563 445682 492222 527832 506077 539559 541280 548153 579178 582029 709533 712541 606367 619334 598436 594166 594265 639873 787624 729223 715790 505150 392066 506198 444060 433706 433541 482115 529934 499207 541325 541326 658470 634071 594293 624158 594300 432530 449991 498363 623211 513323 563834 666728 470037 439465 440923 442469 446086 465293 506591 537319 568107 578528 542151 559280 569016 574664 579530 583027 713885 717535 563325 593840 611172 600087 770263 813249 766764 752609 762191 759785 416296 427716 433145 425570 432538 466178 424299 469161 501387 523761 485281 594491 594278 603285 528959 457049 577087 596956 563728 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.51%) |
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 392066 416296 417109 424068 424299 425570 427716 432530 432538 433145 433541 433706 439465 440164 440923 441563 442442 442469 444060 445682 446086 449991 457049 465293 466178 469161 469177 470037 482115 485281 492222 498363 499207 501387 505150 506077 506198 506591 513323 523761 527832 528959 529934 537319 539559 541280 541325 541326 542142 542151 542345 546634 548153 559280 561290 561979 563325 563728 563834 568107 569016 569199 569993 574372 574664 576915 577087 577190 578528 579178 579530 580695 582029 583027 588458 593557 593840 594166 594265 594278 594293 594300 594491 595419 596956 598436 600045 600087 601194 603285 606152 606367 606644 611172 619334 623211 624158 634071 639873 644018 658470 666728 709533 712541 713885 715790 717535 729223 752609 757393 759785 761096 762191 766764 770263 787624 800497 804639 807262 813249 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf teen amateur"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf teen любительск"
]
|
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.