Query Metrics
7
Database Queries
7
Different statements
179.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.92 ms (82.21%) |
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 390642 392820 399473 404471 404483 407018 407208 415948 417978 418740 422187 422515 426096 427327 428133 428382 433733 442946 443003 443363 446132 446731 449859 450429 450808 451940 453534 454228 454636 455198 455312 461394 461719 462088 463942 467532 469073 469766 473572 474138 474495 477895 479958 482539 483593 486637 488051 488100 488295 489073 489468 489542 491478 492269 492604 493164 493954 493997 495664 495705 495769 497006 500210 503699 504163 510157 510472 510951 511152 514417 514939 515846 516325 517934 518003 518280 519500 520803 522210 523520 523678 523977 524006 524045 525841 527077 531073 532331 534561 544455 549855 550864 551262 557499 558474 561369 562941 566459 567277 568450 574833 576082 582035 591304 596309 598658 602803 605372 618008 623617 624936 645270 654534 654739 664306 664794 671208 792609 801292 814939 ] |
||||||||||||||||||||||||||||||
|
22.35 ms (12.42%) |
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 624936 598658 602803 801292 443363 454228 461394 467532 479958 407018 426096 455198 461719 462088 463942 399473 418740 422187 428133 428382 503699 514939 523520 524006 486637 514417 515846 517934 527077 483593 488100 488295 493997 495769 510472 523678 525841 489073 493954 497006 519500 524045 568450 520803 392820 404471 407208 443003 814939 450808 453534 474138 446132 446731 454636 449859 473572 516325 522210 523977 482539 551262 557499 562941 550864 664306 671208 654739 645270 664794 566459 591304 623617 792609 477895 433733 427327 474495 455312 415948 534561 488051 500210 489542 511152 518280 495705 422515 531073 532331 510157 561369 576082 574833 567277 582035 404483 390642 491478 493164 495664 518003 504163 417978 469073 549855 558474 654534 596309 605372 618008 450429 442946 492604 510951 489468 469766 451940 492269 544455 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.74%) |
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 390642 392820 399473 404471 404483 407018 407208 415948 417978 418740 422187 422515 426096 427327 428133 428382 433733 442946 443003 443363 446132 446731 449859 450429 450808 451940 453534 454228 454636 455198 455312 461394 461719 462088 463942 467532 469073 469766 473572 474138 474495 477895 479958 482539 483593 486637 488051 488100 488295 489073 489468 489542 491478 492269 492604 493164 493954 493997 495664 495705 495769 497006 500210 503699 504163 510157 510472 510951 511152 514417 514939 515846 516325 517934 518003 518280 519500 520803 522210 523520 523678 523977 524006 524045 525841 527077 531073 532331 534561 544455 549855 550864 551262 557499 558474 561369 562941 566459 567277 568450 574833 576082 582035 591304 596309 598658 602803 605372 618008 623617 624936 645270 654534 654739 664306 664794 671208 792609 801292 814939 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подружк туалет"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"подругу в туалете"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
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.