Query Metrics
7
Database Queries
7
Different statements
143.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.77 ms (82.85%) |
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 188561 279404 384463 391754 392005 409251 414157 417980 421856 425507 429895 429902 430374 432296 432936 441089 443243 444527 444794 448063 450268 450840 452803 452952 454009 457063 457638 458768 460446 461840 466252 466992 467118 468165 468514 470015 470064 472195 472806 473439 476191 476314 477147 477223 477506 482739 486240 488989 491103 491431 494809 495566 499382 502777 511314 513490 515350 516466 516937 517511 517697 519616 523358 528560 529293 536393 537789 547481 547927 549797 550578 554369 554543 554981 555031 555062 555385 555967 555977 555990 557966 560409 569298 569309 582774 583508 584980 587578 590357 590377 590720 592756 598870 599638 601175 602092 603716 604667 604781 605076 605266 605906 609959 614827 616094 619802 620330 624201 657775 669079 680484 742279 746126 752626 752704 759365 782807 791738 796804 796881 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (11.45%) |
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 603716 605266 796881 782807 796804 752704 759365 742279 746126 609959 616094 425507 472806 457638 466992 391754 477147 516466 432936 477223 495566 620330 384463 392005 188561 598870 583508 657775 417980 279404 547927 555977 494809 443243 752626 537789 491431 476191 482739 549797 590357 569309 519616 517697 555990 450268 452803 452952 680484 590377 602092 486240 536393 590720 624201 560409 450840 584980 499382 528560 516937 488989 582774 550578 599638 605906 601175 554981 429902 448063 458768 467118 476314 515350 477506 547481 569298 669079 619802 604667 604781 421856 444527 457063 461840 472195 430374 466252 555385 605076 473439 468514 460446 614827 511314 444794 441089 513490 491103 529293 470064 409251 555031 555062 432296 414157 454009 523358 791738 502777 517511 554369 592756 587578 554543 557966 468165 555967 429895 470015 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.44%) |
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 188561 279404 384463 391754 392005 409251 414157 417980 421856 425507 429895 429902 430374 432296 432936 441089 443243 444527 444794 448063 450268 450840 452803 452952 454009 457063 457638 458768 460446 461840 466252 466992 467118 468165 468514 470015 470064 472195 472806 473439 476191 476314 477147 477223 477506 482739 486240 488989 491103 491431 494809 495566 499382 502777 511314 513490 515350 516466 516937 517511 517697 519616 523358 528560 529293 536393 537789 547481 547927 549797 550578 554369 554543 554981 555031 555062 555385 555967 555977 555990 557966 560409 569298 569309 582774 583508 584980 587578 590357 590377 590720 592756 598870 599638 601175 602092 603716 604667 604781 605076 605266 605906 609959 614827 616094 619802 620330 624201 657775 669079 680484 742279 746126 752626 752704 759365 782807 791738 796804 796881 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature solo panties"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature соло трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.86%) |
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.