Query Metrics
7
Database Queries
7
Different statements
166.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.69 ms (83.85%) |
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 186948 381795 382045 383367 383665 384124 390045 390830 391075 396711 397227 406018 407684 407780 407819 411236 415346 428102 443761 443772 448708 451469 452008 452045 452157 454247 454886 457515 458924 460186 460757 460923 460925 464278 464649 465457 466001 466189 466244 470768 473249 474073 477717 479026 479047 483136 484460 484621 485690 485731 485747 487321 490407 493120 505628 505675 508736 519140 522627 523874 527873 530537 531325 534240 534303 534334 541618 544503 554463 566940 567342 587184 589655 617440 633115 663903 667199 667294 667314 667851 678978 695196 704987 707418 709241 710127 712335 717700 717797 724252 725227 727425 727769 727970 728385 731754 732361 733097 733128 734725 734728 735460 738901 746060 746122 748222 759810 775615 781914 781922 785607 789536 797259 799196 801703 804583 806084 814933 818478 819011 ] |
||||||||||||||||||||||||||||||
|
17.68 ms (10.62%) |
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 785607 383367 382045 818478 704987 709241 587184 746122 485690 466189 186948 390045 407780 407819 814933 454886 460923 566940 567342 806084 789536 724252 727769 728385 781914 448708 457515 470768 454247 479047 451469 460757 384124 466244 443761 443772 523874 508736 484621 474073 819011 667294 695196 717700 663903 712335 633115 589655 797259 725227 727425 759810 733097 746060 733128 734728 617440 804583 381795 396711 407684 531325 534240 541618 710127 717797 775615 732361 727970 735460 748222 734725 738901 781922 390830 479026 452008 527873 473249 534334 406018 801703 731754 483136 799196 522627 490407 415346 452045 530537 544503 554463 667199 428102 452157 460186 485731 458924 464649 505628 505675 534303 460925 477717 493120 678978 465457 466001 519140 484460 487321 485747 383665 391075 397227 411236 464278 667851 667314 707418 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.48%) |
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 186948 381795 382045 383367 383665 384124 390045 390830 391075 396711 397227 406018 407684 407780 407819 411236 415346 428102 443761 443772 448708 451469 452008 452045 452157 454247 454886 457515 458924 460186 460757 460923 460925 464278 464649 465457 466001 466189 466244 470768 473249 474073 477717 479026 479047 483136 484460 484621 485690 485731 485747 487321 490407 493120 505628 505675 508736 519140 522627 523874 527873 530537 531325 534240 534303 534334 541618 544503 554463 566940 567342 587184 589655 617440 633115 663903 667199 667294 667314 667851 678978 695196 704987 707418 709241 710127 712335 717700 717797 724252 725227 727425 727769 727970 728385 731754 732361 733097 733128 734725 734728 735460 738901 746060 746122 748222 759810 775615 781914 781922 785607 789536 797259 799196 801703 804583 806084 814933 818478 819011 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy mature"
]
|
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.