Query Metrics
7
Database Queries
7
Different statements
162.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.86 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob with cumshot"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.66 ms |
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 794590 448749 413257 703432 80900 455244 383119 399893 820347 826683 826590 819309 819690 823749 825319 820006 819711 825355 533710 529691 537401 554464 710085 717089 718856 719153 662195 711723 665952 667235 685233 687403 634585 629623 606641 784466 792166 807849 782134 786096 810560 788091 793357 794587 801987 803436 808448 744424 747739 769902 749538 750224 752499 764585 724375 732663 749171 763223 768370 614740 797286 800063 803448 808258 810001 810993 401854 786763 400519 650098 683334 714749 613868 745360 826470 630984 475802 796024 517110 390375 436809 544491 564059 577976 667158 456425 433490 805991 753887 388333 400569 523598 668971 682226 592830 593189 779088 803444 757913 764319 734044 763120 764536 731294 739986 602367 800367 791528 393027 591015 791679 777472 741484 736748 773498 494890 686583 664468 602547 568728 ] |
||||||||||||||||||||||||||||||
| 4 | 3.47 ms |
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 80900 383119 388333 390375 393027 399893 400519 400569 401854 413257 433490 436809 448749 455244 456425 475802 494890 517110 523598 529691 533710 537401 544491 554464 564059 568728 577976 591015 592830 593189 602367 602547 606641 613868 614740 629623 630984 634585 650098 662195 664468 665952 667158 667235 668971 682226 683334 685233 686583 687403 703432 710085 711723 714749 717089 718856 719153 724375 731294 732663 734044 736748 739986 741484 744424 745360 747739 749171 749538 750224 752499 753887 757913 763120 763223 764319 764536 764585 768370 773498 777472 779088 782134 784466 786096 786763 788091 791528 791679 792166 793357 794587 794590 796024 797286 800063 800367 801987 803436 803444 803448 805991 807849 808258 808448 810001 810560 810993 819309 819690 819711 820006 820347 823749 825319 825355 826470 826590 826683 ] |
||||||||||||||||||||||||||||||
| 5 | 139.25 ms |
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 80900 383119 388333 390375 393027 399893 400519 400569 401854 413257 433490 436809 448749 455244 456425 475802 494890 517110 523598 529691 533710 537401 544491 554464 564059 568728 577976 591015 592830 593189 602367 602547 606641 613868 614740 629623 630984 634585 650098 662195 664468 665952 667158 667235 668971 682226 683334 685233 686583 687403 703432 710085 711723 714749 717089 718856 719153 724375 731294 732663 734044 736748 739986 741484 744424 745360 747739 749171 749538 750224 752499 753887 757913 763120 763223 764319 764536 764585 768370 773498 777472 779088 782134 784466 786096 786763 788091 791528 791679 792166 793357 794587 794590 796024 797286 800063 800367 801987 803436 803444 803448 805991 807849 808258 808448 810001 810560 810993 819309 819690 819711 820006 820347 823749 825319 825355 826470 826590 826683 ] |
||||||||||||||||||||||||||||||
| 6 | 1.72 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cumshot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cumshot"
]
|
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.