Query Metrics
7
Database Queries
7
Different statements
190.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.68 ms (86.00%) |
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 382404 386083 391423 401631 402731 413754 420485 420670 425748 427169 442925 443132 444997 448367 451611 453594 454239 455212 458014 458680 460531 460538 460656 460898 461106 461265 461669 461957 463099 466314 466676 469612 470393 472009 473244 473245 473246 474168 474169 479971 481195 481288 481316 484593 485412 485413 485492 485588 485715 485719 485917 485968 487603 487929 488525 491816 494577 496295 496305 496309 496316 498234 501099 504715 506231 507371 509022 509244 509512 510666 513239 520379 522263 528917 534512 542223 543584 544323 546366 548230 548232 548351 549220 549769 549778 550332 551933 551939 551949 552763 554615 555643 557536 562343 565027 565796 565828 569137 570126 574237 575424 576680 579879 581370 592460 603010 612914 616766 623502 624231 636555 644303 680653 680657 692636 692812 714524 715116 716244 819706 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (8.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 420485 458680 461265 485492 575424 581370 548351 570126 714524 469612 463099 401631 420670 461957 520379 485968 488525 461669 460656 496305 544323 592460 496309 616766 644303 549778 680657 443132 485719 543584 548230 716244 692812 552763 612914 491816 461106 473244 507371 496295 522263 549220 680653 692636 579879 472009 455212 460538 470393 460531 485412 509512 819706 557536 487603 555643 542223 551939 565828 546366 565027 623502 636555 386083 444997 460898 413754 481288 487929 504715 382404 451611 458014 479971 485715 509244 496316 528917 513239 501099 466314 473246 549769 551933 565796 569137 576680 715116 551949 427169 466676 454239 473245 481195 534512 485917 494577 510666 550332 548232 554615 562343 574237 603010 624231 453594 402731 474168 391423 474169 425748 481316 484593 485413 509022 485588 498234 506231 442925 448367 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.53%) |
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 382404 386083 391423 401631 402731 413754 420485 420670 425748 427169 442925 443132 444997 448367 451611 453594 454239 455212 458014 458680 460531 460538 460656 460898 461106 461265 461669 461957 463099 466314 466676 469612 470393 472009 473244 473245 473246 474168 474169 479971 481195 481288 481316 484593 485412 485413 485492 485588 485715 485719 485917 485968 487603 487929 488525 491816 494577 496295 496305 496309 496316 498234 501099 504715 506231 507371 509022 509244 509512 510666 513239 520379 522263 528917 534512 542223 543584 544323 546366 548230 548232 548351 549220 549769 549778 550332 551933 551939 551949 552763 554615 555643 557536 562343 565027 565796 565828 569137 570126 574237 575424 576680 579879 581370 592460 603010 612914 616766 623502 624231 636555 644303 680653 680657 692636 692812 714524 715116 716244 819706 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс farm"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex farm"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс farm"
]
|
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.