Query Metrics
7
Database Queries
7
Different statements
172.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.69 ms (84.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 386273 391982 396331 402217 412535 416470 422099 425168 425775 428711 428758 429888 430548 431597 436074 438067 440625 445221 445396 446298 447446 453809 454210 454754 458488 460758 461215 465970 466908 468592 469899 470816 471443 472316 472916 473507 475414 476082 476649 477100 478295 482799 483275 486432 487431 490050 493031 494492 495140 495163 497837 500238 503673 505614 510586 510797 511064 511238 511370 511576 514327 514375 515310 515620 515684 515747 517088 518511 519194 519321 519542 519563 520154 522037 524323 524535 524542 524545 526267 532251 534296 538972 543061 544455 547242 548056 552354 555717 556426 560660 567220 567798 568732 569030 572813 577822 585079 589509 590599 593125 593361 595847 597193 600913 601754 604342 605662 605988 607537 619703 621523 623646 624127 653302 660306 663212 667750 668688 682337 683083 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (9.77%) |
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 497837 396331 477100 460758 600913 436074 663212 447446 517088 514375 590599 605662 445221 538972 515684 470816 422099 593361 430548 471443 472316 510797 526267 495140 476082 567798 569030 556426 560660 667750 668688 624127 438067 429888 476649 495163 503673 505614 543061 567220 604342 589509 465970 428711 605988 532251 391982 431597 461215 682337 412535 386273 482799 466908 585079 475414 468592 473507 547242 595847 619703 428758 445396 519542 440625 660306 524323 519563 514327 524542 577822 469899 519321 515310 493031 555717 402217 511064 487431 593125 524545 552354 568732 623646 621523 500238 511576 483275 515747 518511 454210 490050 511370 524535 544455 683083 534296 548056 601754 522037 520154 597193 607537 425775 494492 416470 478295 446298 510586 511238 572813 458488 454754 515620 453809 653302 519194 425168 486432 472916 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.39%) |
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 386273 391982 396331 402217 412535 416470 422099 425168 425775 428711 428758 429888 430548 431597 436074 438067 440625 445221 445396 446298 447446 453809 454210 454754 458488 460758 461215 465970 466908 468592 469899 470816 471443 472316 472916 473507 475414 476082 476649 477100 478295 482799 483275 486432 487431 490050 493031 494492 495140 495163 497837 500238 503673 505614 510586 510797 511064 511238 511370 511576 514327 514375 515310 515620 515684 515747 517088 518511 519194 519321 519542 519563 520154 522037 524323 524535 524542 524545 526267 532251 534296 538972 543061 544455 547242 548056 552354 555717 556426 560660 567220 567798 568732 569030 572813 577822 585079 589509 590599 593125 593361 595847 597193 600913 601754 604342 605662 605988 607537 619703 621523 623646 624127 653302 660306 663212 667750 668688 682337 683083 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбирует в кроват…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац в кроват"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
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.