Query Metrics
7
Database Queries
7
Different statements
231.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.96 ms (88.62%) |
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 379600 400852 421914 428716 428814 428883 428884 431675 432843 432990 443092 443184 444288 445707 446455 447023 447340 447487 447751 447807 448211 452628 453436 453802 458061 459476 459705 466076 468574 474378 475948 477274 478875 479632 481449 482997 483044 486740 487654 489601 490097 490474 491488 491931 492168 494181 494584 495574 495584 500725 502118 503089 505911 507817 508245 509819 509972 510759 514118 514383 514781 516930 518207 518937 518961 519319 519337 520198 521353 521516 521905 522230 522689 522710 523584 523786 525966 526818 527064 527192 528112 528788 529249 535610 545659 549153 549822 551620 552296 558844 559080 559791 560063 560608 561692 563735 566089 566929 568123 571501 575785 575792 576036 597557 598602 599371 601894 601988 603482 605952 609252 609681 611572 620100 697892 722894 726882 770928 796507 799941 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (7.17%) |
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 495584 428814 500725 571501 379600 432990 443184 444288 514118 560608 561692 576036 566089 478875 428716 468574 522710 519319 527192 482997 535610 432843 521516 563735 566929 558844 575792 568123 603482 447751 447340 466076 459476 502118 518937 491931 483044 609252 522230 552296 446455 486740 520198 605952 528788 545659 559791 601894 609681 611572 443092 477274 474378 509819 521353 523786 525966 489601 514383 521905 522689 492168 549153 697892 599371 770928 726882 458061 421914 453436 453802 475948 503089 495574 510759 487654 490474 518207 529249 494584 494181 620100 575785 551620 560063 722894 559080 598602 601988 799941 428884 479632 481449 452628 447487 448211 447023 518961 527064 505911 514781 528112 526818 507817 523584 796507 549822 597557 400852 428883 445707 459705 519337 516930 447807 431675 490097 508245 491488 509972 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.31%) |
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 379600 400852 421914 428716 428814 428883 428884 431675 432843 432990 443092 443184 444288 445707 446455 447023 447340 447487 447751 447807 448211 452628 453436 453802 458061 459476 459705 466076 468574 474378 475948 477274 478875 479632 481449 482997 483044 486740 487654 489601 490097 490474 491488 491931 492168 494181 494584 495574 495584 500725 502118 503089 505911 507817 508245 509819 509972 510759 514118 514383 514781 516930 518207 518937 518961 519319 519337 520198 521353 521516 521905 522230 522689 522710 523584 523786 525966 526818 527064 527192 528112 528788 529249 535610 545659 549153 549822 551620 552296 558844 559080 559791 560063 560608 561692 563735 566089 566929 568123 571501 575785 575792 576036 597557 598602 599371 601894 601988 603482 605952 609252 609681 611572 620100 697892 722894 726882 770928 796507 799941 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sleeping girl"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск спящ девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.