Query Metrics
7
Database Queries
7
Different statements
150.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.99 ms (83.16%) |
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 398447 398698 403381 418195 418221 420505 422089 424843 428890 432597 435277 435740 437625 442626 447016 450715 453234 453246 453979 454508 458383 461245 461759 461774 463029 463895 465066 470354 471973 472410 472601 477790 480993 487656 487657 489657 492946 493551 495246 495324 495868 496376 497234 497518 501667 503193 504152 505564 506094 506868 507077 511256 518988 525071 528529 534736 537449 538967 539252 539638 541333 544535 545183 546568 548880 553320 557322 557559 557955 561393 564223 574040 579220 579746 579868 581578 582722 584333 585163 588941 592093 592152 592153 594505 597887 597925 599233 599455 600539 600704 602482 602510 603955 606949 607657 613630 615287 615367 615963 616674 618533 621443 624933 627578 627841 628982 634736 635050 640941 641897 647813 660351 668459 672744 693949 707177 724183 764029 766734 768123 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (9.90%) |
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 471973 525071 548880 588941 592152 603955 599455 627578 403381 557322 668459 615287 615367 600539 615963 768123 420505 422089 437625 503193 539638 505564 627841 764029 506868 424843 453234 453246 534736 581578 597925 634736 600704 616674 707177 506094 497234 458383 463029 544535 579868 579220 541333 647813 660351 613630 618533 641897 492946 640941 724183 453979 418221 497518 553320 585163 602510 621443 504152 495868 477790 489657 672744 592093 480993 454508 538967 398447 435740 537449 557955 599233 635050 461774 418195 495246 398698 487657 450715 470354 472601 511256 539252 546568 564223 628982 766734 461245 507077 496376 461759 545183 557559 602482 487656 472410 447016 528529 574040 693949 607657 606949 495324 592153 594505 435277 493551 463895 561393 582722 624933 597887 432597 442626 579746 428890 465066 501667 518988 584333 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.71%) |
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 398447 398698 403381 418195 418221 420505 422089 424843 428890 432597 435277 435740 437625 442626 447016 450715 453234 453246 453979 454508 458383 461245 461759 461774 463029 463895 465066 470354 471973 472410 472601 477790 480993 487656 487657 489657 492946 493551 495246 495324 495868 496376 497234 497518 501667 503193 504152 505564 506094 506868 507077 511256 518988 525071 528529 534736 537449 538967 539252 539638 541333 544535 545183 546568 548880 553320 557322 557559 557955 561393 564223 574040 579220 579746 579868 581578 582722 584333 585163 588941 592093 592152 592153 594505 597887 597925 599233 599455 600539 600704 602482 602510 603955 606949 607657 613630 615287 615367 615963 616674 618533 621443 624933 627578 627841 628982 634736 635050 640941 641897 647813 660351 668459 672744 693949 707177 724183 764029 766734 768123 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex quickie"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс quickie"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс quickie"
]
|
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.