Query Metrics
7
Database Queries
7
Different statements
189.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.88 ms (85.90%) |
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 6806 107216 343227 381869 384098 385116 388069 389789 391044 391630 392959 393124 393558 407171 409692 421259 423498 424549 426467 427142 429508 430574 431718 433594 433697 437170 441965 443115 443749 444728 446137 456363 460974 461941 462891 466297 475969 477498 478524 479162 481259 481357 482573 483194 486261 489074 495206 499897 501068 503843 504397 505451 508861 519238 521233 522177 527214 531357 531884 532536 533415 533500 533536 534221 534466 536012 539788 540056 541597 543856 544359 545549 546820 546829 549004 549264 552070 552933 553996 555287 555355 563876 565630 567942 569743 569744 576081 576121 577088 584940 587303 614566 616400 624228 637486 638906 670315 696870 714666 716719 722464 722520 725507 729955 729957 735498 758261 759545 763578 790995 794472 796734 797724 800759 804483 814640 814685 816169 817063 820369 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (9.24%) |
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 614566 624228 637486 638906 804483 763578 716719 407171 481259 483194 429508 391630 814640 504397 552070 729957 759545 533415 531357 478524 546829 552933 544359 553996 576081 729955 758261 421259 384098 381869 389789 388069 423498 424549 816169 446137 456363 527214 536012 522177 532536 533500 540056 533536 534221 549004 541597 555287 577088 546820 565630 576121 545549 567942 616400 790995 725507 800759 393558 427142 433594 385116 466297 107216 343227 430574 431718 462891 460974 479162 443749 508861 519238 501068 393124 392959 426467 441965 444728 409692 820369 814685 817063 482573 475969 481357 486261 503843 505451 521233 534466 495206 531884 539788 489074 543856 549264 584940 563876 569744 555355 569743 670315 722520 696870 714666 722464 587303 796734 797724 735498 794472 6806 437170 443115 477498 391044 433697 461941 499897 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.36%) |
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 6806 107216 343227 381869 384098 385116 388069 389789 391044 391630 392959 393124 393558 407171 409692 421259 423498 424549 426467 427142 429508 430574 431718 433594 433697 437170 441965 443115 443749 444728 446137 456363 460974 461941 462891 466297 475969 477498 478524 479162 481259 481357 482573 483194 486261 489074 495206 499897 501068 503843 504397 505451 508861 519238 521233 522177 527214 531357 531884 532536 533415 533500 533536 534221 534466 536012 539788 540056 541597 543856 544359 545549 546820 546829 549004 549264 552070 552933 553996 555287 555355 563876 565630 567942 569743 569744 576081 576121 577088 584940 587303 614566 616400 624228 637486 638906 670315 696870 714666 716719 722464 722520 725507 729955 729957 735498 758261 759545 763578 790995 794472 796734 797724 800759 804483 814640 814685 816169 817063 820369 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination sex"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination секс"
]
|
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.