Query Metrics
7
Database Queries
7
Different statements
207.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.51 ms (86.16%) |
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 190958 261144 381950 383985 389117 391926 394212 397901 400483 404477 408319 411361 411808 418948 419554 420538 422108 422345 423775 424502 424547 427100 428497 432517 439499 439608 440257 440954 442785 442980 448921 453227 453938 454310 454536 455327 456288 456683 458781 461837 462031 462352 463625 464006 465040 465906 466163 466394 467026 468183 468647 469027 469145 469154 470866 470927 471743 473846 474070 474145 474414 474474 474964 476654 478806 478935 479953 479999 480007 483523 484689 485073 487022 489181 490887 491341 492303 493022 493098 493247 493743 497906 500436 501063 505748 507042 509022 509317 510912 512736 513423 515624 515633 515711 515722 516485 517080 517897 519413 519516 519678 520936 522961 523428 523847 523849 523852 526392 526527 527058 527449 527675 528142 532029 537249 549027 563098 579328 580940 588411 ] |
||||||||||||||||||||||||||||||
|
18.05 ms (8.71%) |
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 420538 422345 432517 440257 456683 462031 462352 465906 468183 381950 383985 391926 394212 397901 400483 404477 419554 422108 423775 470866 480007 418948 424502 439608 461837 474070 474474 476654 479953 479999 261144 389117 454310 454536 455327 470927 474964 411361 427100 456288 466163 466394 467026 478806 505748 509317 516485 517897 522961 523847 523849 528142 484689 489181 491341 493247 501063 523428 526392 492303 493022 493743 500436 507042 509022 513423 515722 517080 519678 527058 527449 527675 483523 487022 490887 497906 510912 512736 515624 515711 519413 520936 523852 526527 519516 532029 537249 515633 463625 469145 579328 549027 563098 580940 588411 442785 190958 411808 439499 408319 440954 442980 428497 424547 464006 448921 453938 468647 469154 474145 478935 485073 493098 453227 458781 465040 469027 471743 473846 474414 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.23%) |
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 190958 261144 381950 383985 389117 391926 394212 397901 400483 404477 408319 411361 411808 418948 419554 420538 422108 422345 423775 424502 424547 427100 428497 432517 439499 439608 440257 440954 442785 442980 448921 453227 453938 454310 454536 455327 456288 456683 458781 461837 462031 462352 463625 464006 465040 465906 466163 466394 467026 468183 468647 469027 469145 469154 470866 470927 471743 473846 474070 474145 474414 474474 474964 476654 478806 478935 479953 479999 480007 483523 484689 485073 487022 489181 490887 491341 492303 493022 493098 493247 493743 497906 500436 501063 505748 507042 509022 509317 510912 512736 513423 515624 515633 515711 515722 516485 517080 517897 519413 519516 519678 520936 522961 523428 523847 523849 523852 526392 526527 527058 527449 527675 528142 532029 537249 549027 563098 579328 580940 588411 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf юбк"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf юбк"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf in skirt"
]
|
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.