Query Metrics
7
Database Queries
7
Different statements
145.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.68 ms (83.50%) |
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 41516 51635 78786 91532 114730 186793 235834 382094 382258 382957 383487 386503 388220 390085 390292 391289 395809 399078 400703 401492 404000 407157 407187 407681 410428 411776 411919 417162 417311 418377 429549 431879 431882 432683 434219 436685 439456 440841 444196 444240 445046 446343 449938 450992 451472 452450 454680 456085 456166 456371 458319 458884 459300 459658 459850 459859 459939 461539 461958 462673 462964 463350 465503 466948 468064 468516 469060 469722 471579 477317 477477 477938 477959 479181 479918 481254 483615 484449 487526 489005 489021 491388 493967 494603 497216 500057 500910 504169 504331 506632 506786 509153 511835 512904 520067 522629 524382 524393 525571 526243 527582 527870 542069 543496 544025 545697 551370 552190 555283 558955 565657 576309 577663 578174 603876 609998 618208 628823 630955 770951 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (10.06%) |
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 382094 78786 390085 454680 382258 459850 382957 471579 461958 456166 552190 399078 407681 512904 91532 388220 477959 407157 235834 450992 440841 477477 479918 459300 462964 404000 468516 458884 527582 511835 444240 459859 487526 500910 451472 469060 479181 461539 489021 383487 391289 417162 431879 407187 462673 481254 477317 418377 410428 484449 527870 452450 522629 506786 577663 609998 630955 436685 459939 417311 431882 456085 446343 506632 565657 524382 524393 494603 628823 459658 618208 770951 456371 429549 458319 386503 439456 491388 497216 525571 434219 477938 463350 544025 520067 542069 411776 543496 51635 186793 469722 551370 483615 509153 114730 395809 576309 411919 468064 401492 526243 400703 390292 445046 466948 465503 489005 558955 603876 41516 444196 500057 545697 493967 555283 578174 432683 504169 504331 449938 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.91%) |
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 41516 51635 78786 91532 114730 186793 235834 382094 382258 382957 383487 386503 388220 390085 390292 391289 395809 399078 400703 401492 404000 407157 407187 407681 410428 411776 411919 417162 417311 418377 429549 431879 431882 432683 434219 436685 439456 440841 444196 444240 445046 446343 449938 450992 451472 452450 454680 456085 456166 456371 458319 458884 459300 459658 459850 459859 459939 461539 461958 462673 462964 463350 465503 466948 468064 468516 469060 469722 471579 477317 477477 477938 477959 479181 479918 481254 483615 484449 487526 489005 489021 491388 493967 494603 497216 500057 500910 504169 504331 506632 506786 509153 511835 512904 520067 522629 524382 524393 525571 526243 527582 527870 542069 543496 544025 545697 551370 552190 555283 558955 565657 576309 577663 578174 603876 609998 618208 628823 630955 770951 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жарить ее в вагину"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.01%) |
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.