Query Metrics
7
Database Queries
7
Different statements
187.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.88 ms (83.60%) |
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 13118 187960 379559 382591 386378 391704 401294 401531 407799 407827 408009 415207 423350 433609 434425 434608 440817 440895 441207 443903 444437 445530 446630 447136 447364 448002 448515 453262 453265 453735 457585 457829 458571 458794 459778 461699 463851 464386 464596 464929 466196 466208 466227 466840 466877 466883 468434 468742 468837 468842 469568 470125 470232 470404 472639 472688 477878 478005 478455 479369 479821 482633 483114 485160 485311 485646 486192 486542 489311 492120 493518 493575 493684 494454 494715 499617 507884 508560 509642 515681 519047 520711 523843 531523 532055 534336 536299 563945 564731 576685 580712 697801 711149 715888 716329 717007 724252 724755 726962 728259 729226 730391 732989 733371 736398 740826 759556 759757 770331 788543 814898 815311 815409 815965 816046 816508 816544 816970 823293 828873 ] |
||||||||||||||||||||||||||||||
|
18.42 ms (9.82%) |
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 523843 494454 443903 466227 509642 458571 814898 828873 447364 732989 711149 724755 729226 815311 815409 816046 816970 816508 816544 815965 823293 447136 453262 563945 759757 401531 466208 415207 515681 724252 532055 407799 382591 408009 440817 444437 448002 468434 459778 466883 470404 478005 479821 485646 493684 446630 464929 482633 483114 485311 508560 472639 564731 580712 733371 740826 379559 434425 479369 391704 441207 13118 457585 478455 440895 453735 466196 499617 486192 489311 493575 423350 445530 470125 536299 717007 726962 728259 736398 759556 730391 770331 715888 458794 461699 468837 433609 494715 716329 466877 492120 457829 477878 486542 534336 531523 470232 576685 788543 187960 401294 464386 469568 472688 466840 468742 453265 463851 519047 520711 493518 485160 448515 464596 407827 434608 468842 507884 386378 697801 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (2.15%) |
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 13118 187960 379559 382591 386378 391704 401294 401531 407799 407827 408009 415207 423350 433609 434425 434608 440817 440895 441207 443903 444437 445530 446630 447136 447364 448002 448515 453262 453265 453735 457585 457829 458571 458794 459778 461699 463851 464386 464596 464929 466196 466208 466227 466840 466877 466883 468434 468742 468837 468842 469568 470125 470232 470404 472639 472688 477878 478005 478455 479369 479821 482633 483114 485160 485311 485646 486192 486542 489311 492120 493518 493575 493684 494454 494715 499617 507884 508560 509642 515681 519047 520711 523843 531523 532055 534336 536299 563945 564731 576685 580712 697801 711149 715888 716329 717007 724252 724755 726962 728259 729226 730391 732989 733371 736398 740826 759556 759757 770331 788543 814898 815311 815409 815965 816046 816508 816544 816970 823293 828873 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother big cock"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин большие cock"
]
|
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.