Query Metrics
7
Database Queries
7
Different statements
186.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.00 ms (85.13%) |
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 385486 387016 390381 401902 403495 404644 412394 416151 417838 418844 420540 422637 424190 424310 425214 428839 434786 436844 445571 445987 446036 446040 447230 448751 449174 449196 455019 456646 457391 457542 457909 460211 462835 462996 463367 468077 470316 471359 473849 473867 473971 476329 477886 482906 483590 485284 485450 485462 486594 487393 488881 490566 492101 492112 492582 493156 501776 502645 503901 506704 506813 507826 508138 508153 508222 508620 510652 510721 511183 511849 514312 516512 517267 518046 518099 522031 522961 523523 524507 527175 529315 529471 536391 552511 556661 569096 575536 597589 616890 621443 633540 700631 724328 725565 726489 726510 726513 726517 726566 726589 726879 728774 730722 732400 736137 741190 748354 761134 770239 782626 784247 791505 795758 796135 796272 805852 809936 810983 810984 813408 ] |
||||||||||||||||||||||||||||||
|
17.74 ms (9.50%) |
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 621443 782626 784247 795758 813408 725565 726489 726510 726513 726517 791505 810983 810984 726566 761134 770239 724328 726879 730722 736137 732400 728774 741190 748354 633540 700631 796135 796272 805852 404644 420540 428839 434786 448751 457391 457542 477886 385486 387016 417838 436844 446040 449196 462835 471359 473849 476329 390381 403495 412394 418844 445571 446036 447230 457909 462996 470316 473867 473971 401902 422637 449174 455019 456646 463367 416151 445987 460211 468077 503901 508138 508153 510652 522961 485450 492101 492582 493156 507826 508222 510721 514312 516512 518046 522031 523523 483590 488881 490566 492112 502645 506704 506813 511849 518099 536391 482906 485284 487393 501776 508620 511183 524507 527175 529471 552511 597589 486594 424310 485462 517267 575536 556661 569096 616890 809936 726589 424190 425214 529315 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.71%) |
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 385486 387016 390381 401902 403495 404644 412394 416151 417838 418844 420540 422637 424190 424310 425214 428839 434786 436844 445571 445987 446036 446040 447230 448751 449174 449196 455019 456646 457391 457542 457909 460211 462835 462996 463367 468077 470316 471359 473849 473867 473971 476329 477886 482906 483590 485284 485450 485462 486594 487393 488881 490566 492101 492112 492582 493156 501776 502645 503901 506704 506813 507826 508138 508153 508222 508620 510652 510721 511183 511849 514312 516512 517267 518046 518099 522031 522961 523523 524507 527175 529315 529471 536391 552511 556661 569096 575536 597589 616890 621443 633540 700631 724328 725565 726489 726510 726513 726517 726566 726589 726879 728774 730722 732400 736137 741190 748354 761134 770239 782626 784247 791505 795758 796135 796272 805852 809936 810983 810984 813408 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny boy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny парен"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny парен"
]
|
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.