Query Metrics
7
Database Queries
7
Different statements
175.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.69 ms (85.28%) |
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 357595 388537 391754 392004 400480 414125 415294 421820 421856 423934 424248 424294 428282 428883 429863 429881 429889 429916 430353 431028 432179 435373 437635 437947 439033 439125 439138 439142 439325 439705 444180 444527 447052 447538 448489 448607 452187 452964 456240 465670 466475 467058 467893 469092 470971 473740 477246 480502 483558 486189 486856 490731 491952 492994 493172 493849 496474 498649 499288 502362 502800 502856 504509 513560 513629 516246 516579 517272 517425 523970 528143 528223 529249 533653 538977 541251 544404 544509 546976 547703 551256 555048 556335 556341 558261 566766 579031 586583 586962 590398 592573 597190 600087 601338 601519 607549 609071 652966 654078 661283 670997 679190 686106 695393 699487 700478 714665 716127 721203 745136 747328 758281 759340 785972 786178 786911 790199 807435 818025 827967 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (9.13%) |
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 431028 439033 528143 492994 498649 502856 504509 523970 579031 516246 424294 546976 547703 465670 429881 467058 439142 437947 448489 592573 428883 467893 430353 437635 452187 414125 447052 447538 477246 456240 496474 502362 679190 786178 439138 586962 558261 556341 555048 590398 423934 448607 415294 470971 429916 473740 391754 429863 439325 513629 541251 490731 432179 421820 491952 400480 424248 469092 533653 538977 544509 551256 566766 544404 721203 686106 586583 607549 609071 597190 600087 785972 807435 747328 759340 745136 758281 786911 357595 466475 388537 392004 439125 444180 517425 483558 493849 502800 499288 517272 529249 486189 493172 601338 421856 428282 444527 452964 429889 528223 435373 516579 486856 439705 513560 827967 695393 716127 790199 601519 818025 480502 556335 652966 654078 670997 699487 700478 714665 661283 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.61%) |
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 357595 388537 391754 392004 400480 414125 415294 421820 421856 423934 424248 424294 428282 428883 429863 429881 429889 429916 430353 431028 432179 435373 437635 437947 439033 439125 439138 439142 439325 439705 444180 444527 447052 447538 448489 448607 452187 452964 456240 465670 466475 467058 467893 469092 470971 473740 477246 480502 483558 486189 486856 490731 491952 492994 493172 493849 496474 498649 499288 502362 502800 502856 504509 513560 513629 516246 516579 517272 517425 523970 528143 528223 529249 533653 538977 541251 544404 544509 546976 547703 551256 555048 556335 556341 558261 566766 579031 586583 586962 590398 592573 597190 600087 601338 601519 607549 609071 652966 654078 661283 670997 679190 686106 695393 699487 700478 714665 716127 721203 745136 747328 758281 759340 785972 786178 786911 790199 807435 818025 827967 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбация русских анал"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац русск анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
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.