Query Metrics
7
Database Queries
7
Different statements
263.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.64 ms (91.22%) |
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 25650 66611 188552 326017 327638 366354 381795 382289 389458 391253 391967 394329 395905 398655 401226 402125 404342 407146 407685 407791 415636 417292 417850 418900 421835 421836 421851 421868 421871 422203 424093 425572 426515 439635 439720 440894 442010 444679 444917 450220 452620 453155 453230 453242 455357 455428 457167 458730 459946 460258 461989 462136 462140 468804 468890 469034 470474 470939 472153 477985 478372 482563 483022 484397 485712 490001 494809 497005 499295 500046 501519 505622 511314 512215 513032 527773 529326 533874 533877 533889 533897 544834 555995 557998 558883 559960 561495 563111 568596 574433 584192 586617 591033 591067 591512 602601 609227 668645 668660 709257 714380 714487 724996 726538 730186 731788 735932 736137 775473 795849 796105 803428 810986 820373 820381 823917 824408 824461 827921 828231 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (5.26%) |
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 591033 394329 327638 407791 415636 440894 442010 462136 452620 533897 497005 499295 563111 668660 714487 584192 602601 609227 775473 796105 724996 726538 736137 803428 421836 455357 402125 421851 455428 450220 472153 494809 533874 824461 828231 827921 422203 470474 485712 477985 824408 366354 391253 426515 417850 453230 459946 468804 458730 533877 529326 558883 555995 668645 709257 559960 591067 810986 389458 439635 421835 424093 326017 401226 461989 462140 468890 439720 505622 444679 478372 395905 381795 66611 823917 795849 568596 820381 533889 188552 482563 557998 586617 382289 501519 484397 457167 511314 391967 418900 421871 470939 398655 407146 417292 425572 453155 453242 460258 500046 513032 512215 561495 714380 544834 574433 591512 404342 421868 444917 469034 483022 490001 731788 407685 25650 820373 527773 730186 735932 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.01%) |
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 25650 66611 188552 326017 327638 366354 381795 382289 389458 391253 391967 394329 395905 398655 401226 402125 404342 407146 407685 407791 415636 417292 417850 418900 421835 421836 421851 421868 421871 422203 424093 425572 426515 439635 439720 440894 442010 444679 444917 450220 452620 453155 453230 453242 455357 455428 457167 458730 459946 460258 461989 462136 462140 468804 468890 469034 470474 470939 472153 477985 478372 482563 483022 484397 485712 490001 494809 497005 499295 500046 501519 505622 511314 512215 513032 527773 529326 533874 533877 533889 533897 544834 555995 557998 558883 559960 561495 563111 568596 574433 584192 586617 591033 591067 591512 602601 609227 668645 668660 709257 714380 714487 724996 726538 730186 731788 735932 736137 775473 795849 796105 803428 810986 820373 820381 823917 824408 824461 827921 828231 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature кухн"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature кухн"
]
|
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.