Query Metrics
7
Database Queries
7
Different statements
148.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.97 ms (82.67%) |
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 14216 52083 74014 105023 181184 282494 365861 366004 382443 382734 388066 389517 390592 390771 392032 393615 394138 397436 399568 401858 419210 424024 437617 443129 443680 444119 446216 447570 451613 453629 453647 455113 456023 456327 460125 461979 462033 462334 462736 466115 466179 470784 474050 476388 477202 479987 482085 490008 490479 494235 504690 509246 509500 521878 531012 531285 533758 534147 543654 543717 544186 545994 551888 560339 564650 579049 579580 595473 595515 597218 598461 598543 598811 600073 600197 609194 610835 621725 642095 645895 664514 675355 675876 680676 683272 683291 687426 687846 689170 689217 696330 704169 717654 718643 719418 731952 735115 739436 742161 745637 747407 760514 762672 764057 764060 766354 767972 768703 770278 778543 778876 783887 788101 790259 795108 800487 804872 804888 810192 811141 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (10.60%) |
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 579049 551888 560339 675876 719418 680676 687846 696330 687426 689217 621725 598543 778876 783887 790259 804872 735115 745637 764057 764060 800487 74014 393615 394138 476388 437617 366004 447570 455113 466179 490479 509246 509500 382443 579580 544186 543717 645895 664514 675355 689170 683272 545994 598461 610835 595515 600197 778543 739436 766354 762672 747407 718643 392032 397436 401858 443129 451613 105023 52083 462334 466115 390592 424024 456023 474050 382734 444119 462033 453647 521878 494235 534147 14216 419210 564650 595473 742161 760514 788101 390771 470784 453629 479987 462736 531012 531285 533758 704169 597218 811141 804888 768703 767972 609194 642095 717654 389517 461979 795108 460125 181184 477202 543654 598811 770278 810192 443680 282494 388066 731952 446216 456327 490008 504690 365861 600073 399568 482085 683291 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (2.02%) |
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 14216 52083 74014 105023 181184 282494 365861 366004 382443 382734 388066 389517 390592 390771 392032 393615 394138 397436 399568 401858 419210 424024 437617 443129 443680 444119 446216 447570 451613 453629 453647 455113 456023 456327 460125 461979 462033 462334 462736 466115 466179 470784 474050 476388 477202 479987 482085 490008 490479 494235 504690 509246 509500 521878 531012 531285 533758 534147 543654 543717 544186 545994 551888 560339 564650 579049 579580 595473 595515 597218 598461 598543 598811 600073 600197 609194 610835 621725 642095 645895 664514 675355 675876 680676 683272 683291 687426 687846 689170 689217 696330 704169 717654 718643 719418 731952 735115 739436 742161 745637 747407 760514 762672 764057 764060 766354 767972 768703 770278 778543 778876 783887 788101 790259 795108 800487 804872 804888 810192 811141 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teens sex"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teens секс"
]
|
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.