Query Metrics
7
Database Queries
7
Different statements
182.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.77 ms (87.75%) |
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 233053 387121 403243 404600 407182 417997 423148 423155 423468 423476 424254 424744 426227 432235 440830 442852 446107 456589 461233 471164 476697 477097 485671 490665 494686 494816 510780 529802 529842 537371 541379 547992 552368 554748 555077 555092 555411 580133 584693 586175 593151 600820 603406 605560 610436 611493 616740 616798 617362 623461 625157 627180 630802 633708 634617 676436 677848 687485 693032 696070 697720 706405 707404 709346 712643 714906 721831 724798 725478 726385 728243 728619 728832 731125 731441 735581 741819 746566 756240 756296 759607 759762 759906 762989 763060 763370 763561 764040 764266 765145 769243 769349 769877 770494 775004 788634 796009 796051 796207 796481 801654 803960 805152 806712 807844 809767 810030 811019 811280 813919 814293 814979 817718 821284 823943 824115 824847 825267 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (7.00%) |
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 756296 765145 768323 769877 746566 763699 769243 769349 724798 728832 731125 731441 763370 605560 709346 806712 810030 423468 456589 471164 485671 600820 610436 741819 423148 461233 442852 403243 440830 510780 424744 770494 796009 407182 417997 494686 552368 584693 697720 554748 630802 593151 775004 805152 623461 811280 477097 541379 796051 233053 426227 821284 814979 494816 529802 529842 580133 677848 676436 693032 696070 706405 687485 555092 616740 616798 634617 586175 627180 801654 762989 809767 728619 763060 763561 764266 728243 625157 633708 423476 813919 814293 725478 735581 759906 537371 490665 796207 423155 796481 726385 756240 807844 404600 432235 603406 446107 476697 555077 824115 817718 424254 803960 811019 759762 759607 387121 825267 823943 824847 547992 555411 712643 707404 714906 721831 617362 611493 764040 788634 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.70%) |
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 233053 387121 403243 404600 407182 417997 423148 423155 423468 423476 424254 424744 426227 432235 440830 442852 446107 456589 461233 471164 476697 477097 485671 490665 494686 494816 510780 529802 529842 537371 541379 547992 552368 554748 555077 555092 555411 580133 584693 586175 593151 600820 603406 605560 610436 611493 616740 616798 617362 623461 625157 627180 630802 633708 634617 676436 677848 687485 693032 696070 697720 706405 707404 709346 712643 714906 721831 724798 725478 726385 728243 728619 728832 731125 731441 735581 741819 746566 756240 756296 759607 759762 759906 762989 763060 763370 763561 764040 764266 765145 769243 769349 769877 770494 775004 788634 796009 796051 796207 796481 801654 803960 805152 806712 807844 809767 810030 811019 811280 813919 814293 814979 817718 821284 823943 824115 824847 825267 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf blowjob cum"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.65%) |
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.