Query Metrics
7
Database Queries
7
Different statements
151.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.78 ms (82.56%) |
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 210052 383498 387661 388584 404731 411962 414173 414184 416120 426518 438296 442626 443881 445480 447225 453085 454967 456683 459584 462352 464006 466813 472859 477156 480650 481718 486441 487999 489697 494299 495898 497034 497599 501066 501539 502884 504666 505773 514597 517373 517374 518545 520732 522217 524513 527139 527281 530610 537292 541567 544072 546571 551527 551710 551831 554649 554657 555233 555447 555461 555594 557378 557521 557628 558711 558903 561333 561509 566696 567086 568392 568481 568719 573105 573149 573365 576698 577349 581182 581929 582235 582243 583984 591202 592738 593812 603307 604424 604849 606069 606235 606259 606812 607369 614156 614395 616915 619823 619830 624939 626915 635689 636481 660051 660112 667471 676205 689736 699255 705724 732113 732155 733540 740954 763569 784226 795302 798874 800142 828853 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (10.81%) |
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 530610 504666 558903 568719 546571 568481 581182 551831 554657 557378 561509 567086 604849 606259 635689 606235 604424 456683 459584 462352 480650 454967 501539 487999 497034 520732 383498 828853 481718 544072 660112 699255 784226 800142 733540 732155 438296 676205 740954 486441 494299 518545 591202 477156 619830 443881 551710 555461 660051 667471 624939 732113 705724 795302 514597 505773 442626 426518 464006 447225 527139 472859 541567 582235 568392 583984 555594 573105 689736 557521 582243 606812 616915 606069 607369 517374 577349 524513 411962 551527 573149 537292 387661 522217 555447 561333 614395 603307 798874 763569 497599 453085 489697 501066 527281 558711 554649 566696 576698 555233 581929 557628 592738 619823 593812 626915 414184 502884 517373 573365 404731 466813 445480 614156 636481 210052 388584 416120 414173 495898 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.04%) |
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 210052 383498 387661 388584 404731 411962 414173 414184 416120 426518 438296 442626 443881 445480 447225 453085 454967 456683 459584 462352 464006 466813 472859 477156 480650 481718 486441 487999 489697 494299 495898 497034 497599 501066 501539 502884 504666 505773 514597 517373 517374 518545 520732 522217 524513 527139 527281 530610 537292 541567 544072 546571 551527 551710 551831 554649 554657 555233 555447 555461 555594 557378 557521 557628 558711 558903 561333 561509 566696 567086 568392 568481 568719 573105 573149 573365 576698 577349 581182 581929 582235 582243 583984 591202 592738 593812 603307 604424 604849 606069 606235 606259 606812 607369 614156 614395 616915 619823 619830 624939 626915 635689 636481 660051 660112 667471 676205 689736 699255 705724 732113 732155 733540 740954 763569 784226 795302 798874 800142 828853 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"forest milf"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лес природ milf"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лес природ milf"
]
|
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.