Query Metrics
7
Database Queries
7
Different statements
190.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.65 ms (86.37%) |
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 14599 37183 101841 119671 185011 366283 381875 382183 385908 386545 386840 390832 393087 396575 402547 408508 417884 430290 430380 433516 433883 457494 461755 463845 466067 467324 496846 498821 499177 509221 512683 516760 517181 530696 533308 535816 536915 537837 543035 543205 545359 554072 558304 559746 560954 563279 584488 586463 587266 604480 605067 606718 610144 610549 623844 626357 630465 635236 664453 665204 666728 676638 680030 680754 681511 681637 681692 686776 689161 689440 703110 705683 705702 718803 720388 720889 722833 724283 729883 729937 737171 739146 739802 740616 745037 747355 759160 759842 763152 764097 764175 765810 772272 774243 777761 778779 781781 788729 789514 790021 790815 790985 792172 794120 794560 794769 800541 801524 804597 807579 809956 811826 817365 818281 821162 822189 822559 824787 824900 826232 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (8.21%) |
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 536915 537837 498821 554072 664453 689161 689440 630465 610549 610144 623844 790815 800541 809956 772272 794120 763152 764175 778779 382183 402547 516760 530696 681637 676638 584488 37183 430290 433883 586463 467324 499177 509221 386545 386840 185011 417884 821162 822189 822559 824787 818281 824900 517181 533308 535816 543205 559746 545359 705683 722833 665204 666728 563279 606718 605067 792172 801524 781781 789514 788729 729937 739146 745037 759160 739802 747355 703110 718803 777761 790021 790985 119671 366283 101841 390832 466067 587266 811826 385908 393087 381875 14599 396575 408508 430380 433516 817365 826232 457494 463845 512683 496846 461755 560954 543035 558304 681692 680030 680754 681511 686776 705702 720388 720889 626357 635236 804597 807579 794560 794769 729883 737171 740616 764097 774243 724283 759842 765810 604480 ] |
||||||||||||||||||||||||||||||
|
2.78 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 14599 37183 101841 119671 185011 366283 381875 382183 385908 386545 386840 390832 393087 396575 402547 408508 417884 430290 430380 433516 433883 457494 461755 463845 466067 467324 496846 498821 499177 509221 512683 516760 517181 530696 533308 535816 536915 537837 543035 543205 545359 554072 558304 559746 560954 563279 584488 586463 587266 604480 605067 606718 610144 610549 623844 626357 630465 635236 664453 665204 666728 676638 680030 680754 681511 681637 681692 686776 689161 689440 703110 705683 705702 718803 720388 720889 722833 724283 729883 729937 737171 739146 739802 740616 745037 747355 759160 759842 763152 764097 764175 765810 772272 774243 777761 778779 781781 788729 789514 790021 790815 790985 792172 794120 794560 794769 800541 801524 804597 807579 809956 811826 817365 818281 821162 822189 822559 824787 824900 826232 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy black"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy black"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy black"
]
|
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.