Query Metrics
7
Database Queries
7
Different statements
380.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.81 ms (55.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock old мужчин"
]
|
||||||||||||||||||||||||||||||
|
144.55 ms (38.02%) |
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 31627 106162 235834 385228 385745 386304 386767 395651 395686 396891 398916 399255 399689 401306 401714 401985 404059 404366 404950 405100 411433 411769 413288 414091 414498 417476 417655 417920 422997 423412 425714 426406 433694 442370 445062 445933 447246 447448 452488 456414 456484 458915 462035 462803 463766 466395 466920 467767 468013 469673 470324 472471 472962 474719 475020 475069 475588 476944 478853 479560 486909 489130 491503 491670 494382 496356 497671 503953 508109 510022 515165 519227 523487 523903 526503 529194 542469 544471 549762 557274 558283 558335 558417 559707 566348 569689 570073 575819 581652 581660 581700 581706 582333 584537 591600 594807 597561 599327 603957 605515 625036 652187 657777 663948 672766 717368 720462 721502 721551 723103 741114 744300 744711 753570 788963 792822 802846 810775 810831 815855 ] |
||||||||||||||||||||||||||||||
|
17.76 ms (4.67%) |
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 414091 475069 529194 515165 569689 570073 557274 810775 491503 717368 721502 788963 753570 385228 395651 396891 399255 401306 445062 425714 815855 452488 467767 508109 582333 542469 544471 549762 559707 652187 672766 657777 663948 720462 558283 581652 581700 599327 594807 597561 605515 810831 792822 802846 741114 744300 744711 603957 625036 723103 414498 462035 466920 469673 106162 398916 413288 417655 31627 399689 447246 458915 468013 235834 401714 411769 474719 475020 523487 494382 386767 417920 385745 386304 395686 401985 404366 433694 422997 426406 442370 417476 445933 456484 456414 476944 575819 558417 566348 584537 721551 558335 581660 581706 591600 404059 463766 479560 411433 423412 472962 404950 405100 462803 478853 466395 470324 472471 447448 475588 526503 486909 491670 489130 496356 503953 510022 523903 497671 519227 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (0.67%) |
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 31627 106162 235834 385228 385745 386304 386767 395651 395686 396891 398916 399255 399689 401306 401714 401985 404059 404366 404950 405100 411433 411769 413288 414091 414498 417476 417655 417920 422997 423412 425714 426406 433694 442370 445062 445933 447246 447448 452488 456414 456484 458915 462035 462803 463766 466395 466920 467767 468013 469673 470324 472471 472962 474719 475020 475069 475588 476944 478853 479560 486909 489130 491503 491670 494382 496356 497671 503953 508109 510022 515165 519227 523487 523903 526503 529194 542469 544471 549762 557274 558283 558335 558417 559707 566348 569689 570073 575819 581652 581660 581700 581706 582333 584537 591600 594807 597561 599327 603957 605515 625036 652187 657777 663948 672766 717368 720462 721502 721551 723103 741114 744300 744711 753570 788963 792822 802846 810775 810831 815855 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock old man"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.