Query Metrics
7
Database Queries
7
Different statements
179.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.57 ms (84.85%) |
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 386761 389499 420474 430161 434072 434277 442619 442648 443668 449611 449622 449662 450824 457191 461402 464404 469180 472696 474778 481068 482739 490740 490813 497372 498477 500690 502211 506301 515408 516486 517695 519266 519570 522626 524472 524473 527249 529970 530251 532580 537322 542569 545856 547297 554357 556641 556789 557054 557557 558197 563263 566826 572543 572568 579425 580355 583848 584249 584693 586828 586919 589646 590254 592015 592685 592838 600854 601169 604704 604927 605119 605149 610615 611305 612079 629866 629903 630178 630281 634481 636540 648963 649939 652540 656206 656266 665651 668406 679471 687584 694179 707361 709240 726439 728440 729570 730504 731626 741219 743752 747249 751590 755173 756658 760166 760659 760681 760687 761411 765379 786454 788576 789016 789760 802114 804943 805259 807711 807716 808659 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (9.18%) |
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 547297 630281 630178 729570 760166 743752 434277 464404 589646 751590 449611 558197 788576 389499 482739 506301 519570 537322 502211 461402 580355 584249 584693 545856 679471 649939 652540 592838 601169 604704 611305 592015 612079 610615 731626 755173 808659 741219 726439 756658 760687 747249 760659 760681 765379 709240 472696 457191 442648 500690 490813 443668 524472 490740 542569 572568 648963 761411 730504 449662 515408 517695 420474 498477 563263 557054 668406 687584 707361 583848 586828 629903 634481 605119 605149 789016 804943 497372 519266 532580 579425 566826 590254 629866 604927 481068 527249 556641 665651 600854 469180 386761 434072 524473 789760 522626 516486 449622 450824 430161 442619 474778 529970 530251 556789 557557 694179 656206 656266 554357 572543 592685 586919 807711 807716 786454 805259 728440 636540 802114 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.83%) |
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 386761 389499 420474 430161 434072 434277 442619 442648 443668 449611 449622 449662 450824 457191 461402 464404 469180 472696 474778 481068 482739 490740 490813 497372 498477 500690 502211 506301 515408 516486 517695 519266 519570 522626 524472 524473 527249 529970 530251 532580 537322 542569 545856 547297 554357 556641 556789 557054 557557 558197 563263 566826 572543 572568 579425 580355 583848 584249 584693 586828 586919 589646 590254 592015 592685 592838 600854 601169 604704 604927 605119 605149 610615 611305 612079 629866 629903 630178 630281 634481 636540 648963 649939 652540 656206 656266 665651 668406 679471 687584 694179 707361 709240 726439 728440 729570 730504 731626 741219 743752 747249 751590 755173 756658 760166 760659 760681 760687 761411 765379 786454 788576 789016 789760 802114 804943 805259 807711 807716 808659 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf mom compilation"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mom подборк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf mom подборк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
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.