Query Metrics
7
Database Queries
7
Different statements
148.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.66 ms (81.15%) |
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 13265 389877 390587 396339 397568 400802 414104 416613 416616 416632 418101 419604 420394 425948 426284 428860 430365 432949 435563 436071 436639 437190 443448 447761 448199 448914 449161 449957 450707 451044 457486 458504 464497 466745 467563 468949 471092 471148 471682 475420 476059 477021 480206 483742 485472 485530 489263 497829 511856 511857 513221 513223 513569 518372 521682 524303 527545 528449 531586 536378 542097 542137 550536 550555 557106 559294 561961 565640 568074 568208 569593 571349 580159 582399 583290 584322 585788 586885 591427 594113 596038 601781 602268 618931 619949 621298 632920 642097 652388 654048 661034 663766 663776 667045 680472 680562 700975 706466 709754 718785 738448 739142 743185 744019 755671 757561 760478 773921 774712 777855 786278 789074 795386 795714 806685 808997 809001 811252 821075 822865 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (12.20%) |
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 527545 571349 661034 389877 821075 822865 485530 601781 777855 786278 806685 743185 789074 755671 738448 757561 760478 773921 739142 744019 795714 811252 13265 596038 418101 448199 464497 476059 451044 468949 475420 536378 511856 485472 569593 718785 416616 426284 483742 466745 584322 448914 400802 414104 416632 435563 416613 450707 467563 471092 513223 480206 561961 542097 700975 667045 550536 632920 585788 591427 808997 809001 428860 425948 436639 437190 521682 524303 531586 568074 594113 477021 511857 618931 642097 436071 513569 583290 652388 619949 586885 774712 706466 795386 443448 528449 471148 602268 489263 568208 621298 447761 430365 497829 390587 396339 397568 419604 432949 420394 457486 458504 449161 449957 471682 513221 518372 542137 580159 550555 559294 565640 557106 582399 663776 709754 654048 663766 680472 680562 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.83%) |
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 13265 389877 390587 396339 397568 400802 414104 416613 416616 416632 418101 419604 420394 425948 426284 428860 430365 432949 435563 436071 436639 437190 443448 447761 448199 448914 449161 449957 450707 451044 457486 458504 464497 466745 467563 468949 471092 471148 471682 475420 476059 477021 480206 483742 485472 485530 489263 497829 511856 511857 513221 513223 513569 518372 521682 524303 527545 528449 531586 536378 542097 542137 550536 550555 557106 559294 561961 565640 568074 568208 569593 571349 580159 582399 583290 584322 585788 586885 591427 594113 596038 601781 602268 618931 619949 621298 632920 642097 652388 654048 661034 663766 663776 667045 680472 680562 700975 706466 709754 718785 738448 739142 743185 744019 755671 757561 760478 773921 774712 777855 786278 789074 795386 795714 806685 808997 809001 811252 821075 822865 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful solo dildo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.