Query Metrics
7
Database Queries
7
Different statements
178.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.21 ms (84.05%) |
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 318315 396042 396075 396975 398354 400681 401979 402207 402950 407683 412332 418112 421580 423609 425396 426571 428305 428756 428883 436481 437863 437999 446232 446300 447106 447321 448349 452300 453361 453668 454076 454535 459740 461495 461876 463179 464837 465172 465320 465449 468093 468388 468398 468434 469736 469760 470227 472324 474737 476089 476775 477456 478073 478779 479836 483413 492396 498239 499830 504630 506115 507701 511067 512066 513219 515333 515554 516704 516812 519722 519772 521792 531296 536440 537207 537686 544019 545366 546254 558126 558566 558592 559906 565450 566405 569867 571726 572798 573444 576560 577385 577576 591206 596134 601728 609848 610540 612831 618360 620230 624682 626399 635916 651269 656932 662899 665742 669207 672277 683028 687431 720260 726314 740854 742348 745001 776310 778541 789468 810616 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (9.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 396075 398354 401979 423609 468434 465320 468398 476775 531296 536440 519722 506115 566405 577576 665742 672277 687431 576560 591206 624682 610540 776310 789468 742348 468093 318315 447321 519772 469736 454076 558566 571726 537686 425396 546254 662899 596134 726314 745001 778541 469760 537207 492396 515333 544019 577385 810616 436481 402950 683028 618360 740854 609848 446300 620230 428883 452300 511067 418112 437863 446232 656932 669207 468388 426571 479836 515554 483413 498239 453668 507701 516812 516704 565450 572798 573444 559906 569867 651269 412332 461495 470227 447106 461876 478779 626399 521792 477456 428756 499830 448349 465172 635916 437999 463179 474737 428305 478073 513219 476089 454535 464837 558592 545366 601728 396042 402207 407683 400681 459740 472324 453361 396975 558126 720260 612831 465449 421580 504630 512066 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.94%) |
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 318315 396042 396075 396975 398354 400681 401979 402207 402950 407683 412332 418112 421580 423609 425396 426571 428305 428756 428883 436481 437863 437999 446232 446300 447106 447321 448349 452300 453361 453668 454076 454535 459740 461495 461876 463179 464837 465172 465320 465449 468093 468388 468398 468434 469736 469760 470227 472324 474737 476089 476775 477456 478073 478779 479836 483413 492396 498239 499830 504630 506115 507701 511067 512066 513219 515333 515554 516704 516812 519722 519772 521792 531296 536440 537207 537686 544019 545366 546254 558126 558566 558592 559906 565450 566405 569867 571726 572798 573444 576560 577385 577576 591206 596134 601728 609848 610540 612831 618360 620230 624682 626399 635916 651269 656932 662899 665742 669207 672277 683028 687431 720260 726314 740854 742348 745001 776310 778541 789468 810616 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public anal hard"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц анал hard"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц анал hard"
]
|
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.