Query Metrics
7
Database Queries
7
Different statements
185.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.47 ms (86.14%) |
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 415287 433066 447931 452862 469311 470400 493214 499964 506066 509575 510064 512711 518763 526089 526794 533331 533335 536444 536473 543135 549718 552687 555334 563271 563791 566337 567619 568908 576992 584095 591917 593676 603847 604196 612060 613286 616852 618755 621186 627362 636147 636224 659052 668580 671889 680440 699291 699409 707314 709382 710589 714868 718613 725252 725592 726960 726994 727731 727774 728992 729678 730148 733465 736113 736547 737185 738322 740115 740879 742827 742866 744061 748003 750902 751524 756551 756986 757276 758766 759697 759958 759960 760249 760973 761119 761531 761599 761716 763547 766668 768783 770499 770522 775202 775761 776204 777220 777499 783376 788856 790887 791366 791846 794599 794858 795136 795632 795894 796203 796343 796344 797396 798725 798734 800712 800891 801672 802053 805455 810274 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (7.93%) |
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 621186 536473 543135 709382 591917 618755 725592 733465 751524 759697 710589 775761 555334 469311 499964 526794 576992 738322 707314 568908 699409 563791 604196 725252 744061 533331 584095 699291 718613 636147 796344 750902 736113 748003 470400 512711 659052 549718 777220 777499 798725 798734 810274 757276 761531 761599 791366 794858 796343 797396 756986 760249 766668 726994 727731 759960 727774 761716 770522 603847 616852 783376 790887 791846 800891 533335 567619 668580 563271 636224 794599 795894 801672 768783 805455 728992 736547 742827 742866 730148 536444 415287 775202 758766 770499 788856 795136 802053 756551 800712 761119 566337 433066 493214 680440 613286 729678 447931 714868 796203 518763 506066 510064 526089 552687 627362 740115 759958 763547 760973 726960 452862 509575 671889 593676 612060 776204 795632 740879 737185 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.91%) |
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 415287 433066 447931 452862 469311 470400 493214 499964 506066 509575 510064 512711 518763 526089 526794 533331 533335 536444 536473 543135 549718 552687 555334 563271 563791 566337 567619 568908 576992 584095 591917 593676 603847 604196 612060 613286 616852 618755 621186 627362 636147 636224 659052 668580 671889 680440 699291 699409 707314 709382 710589 714868 718613 725252 725592 726960 726994 727731 727774 728992 729678 730148 733465 736113 736547 737185 738322 740115 740879 742827 742866 744061 748003 750902 751524 756551 756986 757276 758766 759697 759958 759960 760249 760973 761119 761531 761599 761716 763547 766668 768783 770499 770522 775202 775761 776204 777220 777499 783376 788856 790887 791366 791846 794599 794858 795136 795632 795894 796203 796343 796344 797396 798725 798734 800712 800891 801672 802053 805455 810274 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончает внутрь мамы"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кремпа сперм мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.