Query Metrics
7
Database Queries
7
Different statements
174.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.06 ms (84.89%) |
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 34201 156525 247954 383888 385104 386493 387409 397998 399694 400621 419616 429084 429711 446729 449079 452205 460609 465831 474891 480782 498593 517698 527158 530895 531181 535985 539154 547265 550003 556641 563419 565155 565986 573468 574644 583553 587787 587935 591628 596518 601030 604915 610235 614089 620208 632289 640682 663519 665943 676252 680960 684916 688887 693256 708226 713576 726328 735413 740569 752194 753656 759580 759907 760133 763024 763081 765808 765860 769580 772998 774728 774742 774918 775494 775545 779346 780614 784946 786160 788947 789966 789984 790407 797287 797369 797664 799282 799359 800126 801345 801760 803842 805678 805689 805768 806160 806204 806984 807219 807522 807553 811085 811813 811887 813667 814333 815912 816083 816508 816558 817842 817879 818448 818502 819042 821250 821495 824179 824994 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (9.07%) |
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 587787 789984 790407 780614 805689 786160 803842 752194 753656 735413 740569 759907 769580 640682 789966 801345 805768 385104 688887 799359 387409 247954 583553 480782 460609 386493 449079 531181 565986 563419 573468 591628 587935 620208 610235 775494 806160 807219 765860 399694 446729 429711 465831 517698 498593 814333 527158 556641 596518 601030 604915 779346 807522 807553 632289 775545 397998 474891 400621 429084 34201 708226 419616 383888 156525 452205 763081 813667 817879 818448 819042 816083 816558 817842 821495 822897 815912 816508 824179 824994 818502 821250 535985 530895 539154 547265 550003 565155 574644 663519 665943 680960 684916 693256 676252 713576 614089 774728 774742 774918 797664 799282 805678 806984 811887 784946 788947 797287 759580 760133 763024 797369 800126 801760 806204 811085 811813 772998 726328 765808 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (2.04%) |
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 34201 156525 247954 383888 385104 386493 387409 397998 399694 400621 419616 429084 429711 446729 449079 452205 460609 465831 474891 480782 498593 517698 527158 530895 531181 535985 539154 547265 550003 556641 563419 565155 565986 573468 574644 583553 587787 587935 591628 596518 601030 604915 610235 614089 620208 632289 640682 663519 665943 676252 680960 684916 688887 693256 708226 713576 726328 735413 740569 752194 753656 759580 759907 760133 763024 763081 765808 765860 769580 772998 774728 774742 774918 775494 775545 779346 780614 784946 786160 788947 789966 789984 790407 797287 797369 797664 799282 799359 800126 801345 801760 803842 805678 805689 805768 806160 806204 806984 807219 807522 807553 811085 811813 811887 813667 814333 815912 816083 816508 816558 817842 817879 818448 818502 819042 821250 821495 824179 824994 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфу душе"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф ван"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф ван"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.96%) |
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.