Query Metrics
7
Database Queries
7
Different statements
612.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.97 ms (35.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен fucks парен"
]
|
||||||||||||||||||||||||||||||
|
207.63 ms (33.90%) |
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 154112 382384 386074 399306 399412 400143 400181 400475 402141 405537 407379 408410 408998 411435 412656 418710 419413 421357 422283 425784 426359 428574 429586 431020 433699 434726 437516 438375 439745 440631 443934 444664 446566 447895 448519 449868 450835 451239 452303 454050 454419 457985 461059 461436 462230 462457 464299 464444 466059 466095 467255 467949 467957 469755 470190 471885 474138 474975 476239 476293 476350 479644 482439 482734 484867 487506 488114 489938 490769 493093 493155 494270 494304 500725 500877 501901 502671 504781 505822 505826 508593 511839 512331 512521 515877 516441 517010 519202 519929 523072 523805 524362 526006 526886 527014 528621 531997 532063 532825 541467 544771 546940 549719 552159 552270 554253 558226 559083 559579 562016 562985 571196 579329 587972 649156 748244 790799 814083 816250 819493 ] |
||||||||||||||||||||||||||||||
|
164.86 ms (26.91%) |
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 154112 382384 386074 399306 399412 400143 400181 400475 402141 405537 407379 408410 408998 411435 412656 418710 419413 421357 422283 425784 426359 428574 429586 431020 433699 434726 437516 438375 439745 440631 443934 444664 446566 447895 448519 449868 450835 451239 452303 454050 454419 457985 461059 461436 462230 462457 464299 464444 466059 466095 467255 467949 467957 469755 470190 471885 474138 474975 476239 476293 476350 479644 482439 482734 484867 487506 488114 489938 490769 493093 493155 494270 494304 500725 500877 501901 502671 504781 505822 505826 508593 511839 512331 512521 515877 516441 517010 519202 519929 523072 523805 524362 526006 526886 527014 528621 531997 532063 532825 541467 544771 546940 549719 552159 552270 554253 558226 559083 559579 562016 562985 571196 579329 587972 649156 748244 790799 814083 816250 819493 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (2.98%) |
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 431020 434726 482734 449868 457985 467957 471885 474138 447895 464299 466059 474975 476239 452303 454419 464444 467949 489938 494304 505826 515877 504781 524362 505822 508593 546940 554253 562985 552270 559579 649156 587972 790799 748244 407379 408998 422283 438375 479644 400143 402141 425784 437516 446566 461059 462457 466095 470190 400181 421357 426359 443934 448519 476293 476350 400475 439745 440631 461436 405537 429586 444664 451239 467255 469755 502671 519929 493155 512331 541467 487506 490769 501901 511839 526006 493093 500725 512521 517010 523805 526886 527014 528621 386074 154112 382384 399306 399412 412656 418710 428574 408410 411435 419413 433699 816250 814083 819493 482439 450835 454050 462230 488114 500877 532825 523072 531997 516441 494270 519202 532063 484867 549719 552159 559083 562016 579329 544771 558226 571196 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy fucks boy"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен fucks парен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.26%) |
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.