Query Metrics
7
Database Queries
7
Different statements
175.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.17 ms (84.84%) |
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 382347 385948 387899 391583 396251 396275 399858 399865 400689 401998 405809 410057 411688 413484 415365 418490 423650 424622 428500 429250 441022 443205 443305 444001 446977 462208 464595 466130 466200 472132 474746 474862 491495 512973 516437 518338 521971 523806 537732 546654 551898 560195 561316 563464 564443 568581 569740 576292 584395 588264 596991 598042 598731 604227 607086 610576 617111 618469 619406 623291 623521 623842 623874 624835 628363 631710 632042 633474 640427 649081 657363 668540 676492 685718 692337 699583 701508 705808 705878 713262 713520 714183 717887 719067 719141 721109 721445 721798 721864 722751 724217 728730 729618 733844 741310 741539 742798 744511 753677 772095 775994 778614 790222 794906 800332 803244 807551 807918 809687 810689 810690 811340 811944 815592 816975 819588 819611 820588 821713 825119 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (8.84%) |
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 728730 744511 753677 705808 721798 775994 790222 803244 807918 405809 443305 399865 444001 676492 628363 462208 564443 474746 423650 521971 523806 382347 387899 399858 424622 418490 815592 819611 825119 821713 464595 472132 516437 551898 584395 699583 701508 705878 719141 692337 717887 721445 721864 569740 576292 588264 618469 624835 632042 607086 610576 619406 598731 623842 631710 778614 810689 811340 809687 810690 811944 772095 741310 724217 617111 640427 714183 794906 800332 807551 400689 396251 391583 491495 446977 560195 598042 441022 512973 396275 411688 410057 415365 413484 428500 429250 443205 820588 816975 819588 474862 518338 537732 546654 561316 713520 668540 719067 722751 649081 657363 685718 563464 568581 604227 633474 623291 623874 596991 733844 741539 729618 742798 623521 713262 721109 401998 466130 466200 385948 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.88%) |
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 382347 385948 387899 391583 396251 396275 399858 399865 400689 401998 405809 410057 411688 413484 415365 418490 423650 424622 428500 429250 441022 443205 443305 444001 446977 462208 464595 466130 466200 472132 474746 474862 491495 512973 516437 518338 521971 523806 537732 546654 551898 560195 561316 563464 564443 568581 569740 576292 584395 588264 596991 598042 598731 604227 607086 610576 617111 618469 619406 623291 623521 623842 623874 624835 628363 631710 632042 633474 640427 649081 657363 668540 676492 685718 692337 699583 701508 705808 705878 713262 713520 714183 717887 719067 719141 721109 721445 721798 721864 722751 724217 728730 729618 733844 741310 741539 742798 744511 753677 772095 775994 778614 790222 794906 800332 803244 807551 807918 809687 810689 810690 811340 811944 815592 816975 819588 819611 820588 821713 825119 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man hard"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин hard"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин hard"
]
|
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.