Query Metrics
7
Database Queries
7
Different statements
166.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.41 ms (83.78%) |
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 390931 392303 393027 397771 428216 434016 449273 450699 457653 462997 467659 485247 491581 499832 501118 507459 515198 526577 541116 558806 559334 567617 575113 576445 588890 595107 605283 606604 610484 619620 623238 626325 629549 646270 662512 666080 667993 672881 676673 684433 702960 703252 703279 703986 706597 707538 710331 712217 717123 717155 718394 719251 720547 722706 723656 724749 724839 726123 726976 728908 728959 729069 730318 731007 734117 734604 735391 735654 736685 741199 744432 746187 748000 748002 748010 748693 750792 753172 753360 753368 755549 757605 757712 762577 762656 765596 767294 767335 767961 770084 771943 779698 779891 780125 782134 784466 786147 792788 794403 794585 801424 801932 801993 802272 802307 802599 803173 803862 803884 803943 804356 805259 808448 810066 811123 813318 816654 817711 824848 825053 ] |
||||||||||||||||||||||||||||||
|
16.93 ms (10.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 757712 748693 767294 730318 734604 748002 757605 629549 706597 802272 803884 428216 728908 804356 392303 811123 825053 507459 559334 541116 558806 667993 684433 672881 712217 719251 676673 720547 588890 779891 784466 801424 801932 813318 782134 802307 734117 753172 771943 803862 803943 808448 810066 728959 735391 746187 748000 748010 753368 765596 729069 744432 755549 770084 762577 767335 703986 710331 779698 792788 434016 397771 646270 666080 718394 457653 526577 450699 723656 816654 515198 499832 501118 702960 707538 717155 662512 567617 595107 610484 605283 619620 626325 794585 803173 731007 801993 802599 724839 726976 735654 762656 767961 724749 736685 726123 741199 753360 703252 703279 717123 780125 786147 794403 467659 449273 485247 576445 575113 722706 606604 623238 805259 750792 390931 462997 491581 393027 817711 824848 ] |
||||||||||||||||||||||||||||||
|
3.39 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 390931 392303 393027 397771 428216 434016 449273 450699 457653 462997 467659 485247 491581 499832 501118 507459 515198 526577 541116 558806 559334 567617 575113 576445 588890 595107 605283 606604 610484 619620 623238 626325 629549 646270 662512 666080 667993 672881 676673 684433 702960 703252 703279 703986 706597 707538 710331 712217 717123 717155 718394 719251 720547 722706 723656 724749 724839 726123 726976 728908 728959 729069 730318 731007 734117 734604 735391 735654 736685 741199 744432 746187 748000 748002 748010 748693 750792 753172 753360 753368 755549 757605 757712 762577 762656 765596 767294 767335 767961 770084 771943 779698 779891 780125 782134 784466 786147 792788 794403 794585 801424 801932 801993 802272 802307 802599 803173 803862 803884 803943 804356 805259 808448 810066 811123 813318 816654 817711 824848 825053 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot pussy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot pussy"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot pussy"
]
|
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.