Query Metrics
7
Database Queries
7
Different statements
172.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.70 ms (85.10%) |
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 4250 391571 397304 401303 406566 408056 414319 419220 421848 426003 451456 457446 469568 471814 492523 502326 515506 516656 519243 533060 537664 538664 540262 561807 571035 591862 592312 596653 598018 600283 604905 604967 609841 615561 619857 625541 632008 632289 640526 644315 644974 649105 649586 651636 660431 663254 674452 682181 693210 700760 701470 708774 714562 716057 718560 720243 720717 724194 724366 726585 729644 734373 734440 734456 737079 744593 751585 751761 752736 754208 757388 758119 758213 758910 760915 765683 770897 771164 775956 777581 777728 779069 782562 786519 787289 788178 789469 789540 789997 790042 790371 797178 797505 797734 798495 798572 800527 801344 802651 803457 805736 807407 811490 813597 814613 815137 815197 815408 815606 816241 816887 817171 817422 818358 818368 821010 821899 823471 824121 824915 ] |
||||||||||||||||||||||||||||||
|
15.45 ms (8.96%) |
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 682181 807407 421848 502326 457446 451456 649586 609841 625541 770897 469568 408056 406566 471814 516656 492523 818368 817422 818358 824121 540262 533060 663254 720243 604905 632008 775956 782562 811490 724194 758910 754208 758213 632289 714562 787289 419220 788178 571035 397304 644974 813597 815137 821899 817171 519243 537664 538664 561807 649105 660431 674452 693210 716057 720717 651636 701470 718560 708774 598018 600283 644315 596653 604967 591862 592312 615561 640526 619857 777581 789997 790371 797734 798572 777728 779069 786519 789469 800527 729644 734373 734456 789540 797178 797505 801344 803457 805736 734440 758119 760915 726585 744593 751585 751761 724366 752736 771164 737079 757388 765683 700760 790042 798495 802651 4250 391571 401303 426003 414319 515506 814613 815197 816241 823471 824915 821010 815408 815606 816887 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.46%) |
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 4250 391571 397304 401303 406566 408056 414319 419220 421848 426003 451456 457446 469568 471814 492523 502326 515506 516656 519243 533060 537664 538664 540262 561807 571035 591862 592312 596653 598018 600283 604905 604967 609841 615561 619857 625541 632008 632289 640526 644315 644974 649105 649586 651636 660431 663254 674452 682181 693210 700760 701470 708774 714562 716057 718560 720243 720717 724194 724366 726585 729644 734373 734440 734456 737079 744593 751585 751761 752736 754208 757388 758119 758213 758910 760915 765683 770897 771164 775956 777581 777728 779069 782562 786519 787289 788178 789469 789540 789997 790042 790371 797178 797505 797734 798495 798572 800527 801344 802651 803457 805736 807407 811490 813597 814613 815137 815197 815408 815606 816241 816887 817171 817422 818358 818368 821010 821899 823471 824121 824915 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf mom"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf mom"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf mom"
]
|
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.