Query Metrics
7
Database Queries
7
Different statements
170.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.11 ms (85.67%) |
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 384593 399017 399332 408326 417821 418803 419764 429338 442832 445057 446518 447645 447659 448709 451708 453352 457145 459378 463141 464280 464320 467200 468579 468588 468773 470514 472830 473073 473955 477678 477732 477906 484878 486275 486704 487123 489551 491458 491475 496272 506328 507362 511724 517044 522919 524664 525686 527495 538216 547518 548536 549090 549332 553128 554425 554639 557983 558026 558308 559024 560183 561660 562128 562148 562198 563278 564136 565420 565956 566272 570481 574959 575425 576279 577328 577377 577399 578070 578178 578492 578851 579321 581649 583671 584706 593122 596635 598490 598703 599418 599501 600084 600246 601065 603931 604425 608765 609886 610201 612099 621120 623120 637436 657363 659501 671670 682912 683955 688049 692050 693182 696976 712025 715860 720491 729065 743086 746155 775797 822360 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (8.91%) |
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 683955 558026 576279 583671 429338 442832 446518 451708 459378 457145 468579 473073 507362 557983 577377 419764 477906 468588 473955 464320 464280 468773 470514 522919 524664 486275 486704 491475 506328 511724 517044 484878 525686 527495 538216 418803 408326 577399 563278 657363 579321 609886 489551 554639 549090 575425 549332 558308 560183 577328 578178 562198 574959 578070 581649 659501 692050 682912 548536 559024 562148 565420 565956 570481 578492 578851 584706 593122 598490 600246 603931 599418 637436 596635 599501 598703 601065 621120 746155 623120 566272 554425 564136 600084 612099 399017 417821 561660 688049 671670 729065 743086 696976 712025 715860 608765 562128 775797 453352 491458 384593 399332 445057 822360 447645 448709 472830 477678 447659 496272 487123 547518 693182 553128 604425 610201 720491 463141 467200 477732 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.35%) |
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 384593 399017 399332 408326 417821 418803 419764 429338 442832 445057 446518 447645 447659 448709 451708 453352 457145 459378 463141 464280 464320 467200 468579 468588 468773 470514 472830 473073 473955 477678 477732 477906 484878 486275 486704 487123 489551 491458 491475 496272 506328 507362 511724 517044 522919 524664 525686 527495 538216 547518 548536 549090 549332 553128 554425 554639 557983 558026 558308 559024 560183 561660 562128 562148 562198 563278 564136 565420 565956 566272 570481 574959 575425 576279 577328 577377 577399 578070 578178 578492 578851 579321 581649 583671 584706 593122 596635 598490 598703 599418 599501 600084 600246 601065 603931 604425 608765 609886 610201 612099 621120 623120 637436 657363 659501 671670 682912 683955 688049 692050 693182 696976 712025 715860 720491 729065 743086 746155 775797 822360 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small dick man"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая член мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.51 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.