Query Metrics
7
Database Queries
7
Different statements
168.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.42 ms (84.43%) |
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 7170 388007 397503 419300 423568 429768 429909 431385 433319 433339 433498 433601 437504 445323 446257 447466 447640 448813 449115 451866 452612 452727 453368 458907 463798 464427 464651 465205 472464 476828 478993 483220 486589 488234 488235 489489 490577 491248 495397 495401 497269 497545 500748 503105 511067 517780 517855 520215 523793 524675 527507 527523 527580 528947 528950 528966 528990 529003 532705 537307 539157 540241 549092 558912 567777 568509 574149 574727 576980 579580 580123 597170 600490 603057 609909 613515 618761 620292 624194 626403 637537 644363 648503 651957 652544 652898 652939 653209 662899 671085 671374 681691 692357 694498 694553 697828 697987 700011 707089 710794 712366 719651 720450 723980 727052 728362 729957 738689 739139 744938 750334 750760 761801 766992 772901 774495 800352 805164 814347 818992 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (10.21%) |
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 529003 527507 527523 527580 528990 558912 720450 712366 429768 476828 448813 537307 600490 453368 458907 463798 574727 579580 489489 580123 495397 433339 472464 524675 549092 568509 648503 609909 618761 750760 644363 465205 488235 451866 433601 423568 491248 446257 517855 503105 464651 567777 452612 520215 497269 528950 486589 637537 528947 464427 433319 419300 431385 433498 814347 447466 447640 511067 445323 437504 597170 7170 388007 397503 818992 488234 697828 707089 662899 694498 700011 624194 626403 774495 723980 729957 800352 738689 772901 728362 750334 766992 697987 497545 528966 540241 651957 652939 694553 652898 805164 739139 517780 483220 532705 539157 671374 692357 620292 744938 613515 478993 452727 490577 429909 576980 495401 500748 449115 574149 652544 681691 710794 523793 671085 719651 653209 603057 727052 761801 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.27%) |
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 7170 388007 397503 419300 423568 429768 429909 431385 433319 433339 433498 433601 437504 445323 446257 447466 447640 448813 449115 451866 452612 452727 453368 458907 463798 464427 464651 465205 472464 476828 478993 483220 486589 488234 488235 489489 490577 491248 495397 495401 497269 497545 500748 503105 511067 517780 517855 520215 523793 524675 527507 527523 527580 528947 528950 528966 528990 529003 532705 537307 539157 540241 549092 558912 567777 568509 574149 574727 576980 579580 580123 597170 600490 603057 609909 613515 618761 620292 624194 626403 637537 644363 648503 651957 652544 652898 652939 653209 662899 671085 671374 681691 692357 694498 694553 697828 697987 700011 707089 710794 712366 719651 720450 723980 727052 728362 729957 738689 739139 744938 750334 750760 761801 766992 772901 774495 800352 805164 814347 818992 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen girls compilation"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen девушк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen девушк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.