Query Metrics
7
Database Queries
7
Different statements
197.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.37 ms (87.92%) |
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 80470 241603 381424 391364 392674 398001 399267 399352 399621 401359 406574 407538 408206 410848 411133 416593 421211 422418 424903 426364 426739 427418 427452 429575 437999 442392 442991 446310 448076 448237 448262 452751 454462 454537 457669 457778 458367 459308 461316 464904 466158 466495 466630 466646 467381 468855 468984 469083 469231 470068 470123 471457 471526 472335 472930 473132 475586 475641 476877 477197 477992 478326 478992 479470 484152 484754 485796 488525 489725 489825 491656 491768 491980 491984 493083 496153 497836 498776 498832 500057 501238 502962 504345 504812 504946 505850 508058 509459 512005 514447 517850 519176 521440 521595 523872 524271 524697 524779 525774 528274 541422 557557 584983 604978 607412 622472 717131 720609 729227 736797 741114 754176 761992 788815 794975 797749 797760 804452 808647 810531 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (7.17%) |
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 788815 794975 797749 810531 736797 761992 754176 729227 741114 604978 607412 622472 717131 720609 797760 804452 808647 381424 398001 399621 407538 411133 426739 446310 464904 466158 469231 475586 475641 477992 429575 466630 468855 469083 473132 401359 422418 427418 437999 452751 461316 470123 392674 399267 427452 454462 454537 457669 468984 472335 421211 448237 457778 466495 470068 472930 478992 479470 500057 501238 504345 504812 509459 512005 514447 523872 496153 498776 502962 517850 521440 484152 491980 493083 497836 498832 504946 521595 524271 528274 484754 488525 489725 489825 491656 505850 508058 519176 524697 524779 541422 491768 525774 557557 80470 241603 391364 399352 406574 416593 426364 408206 442991 442392 410848 424903 584983 448076 448262 471457 477197 485796 491984 458367 459308 466646 467381 471526 476877 478326 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.32%) |
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 80470 241603 381424 391364 392674 398001 399267 399352 399621 401359 406574 407538 408206 410848 411133 416593 421211 422418 424903 426364 426739 427418 427452 429575 437999 442392 442991 446310 448076 448237 448262 452751 454462 454537 457669 457778 458367 459308 461316 464904 466158 466495 466630 466646 467381 468855 468984 469083 469231 470068 470123 471457 471526 472335 472930 473132 475586 475641 476877 477197 477992 478326 478992 479470 484152 484754 485796 488525 489725 489825 491656 491768 491980 491984 493083 496153 497836 498776 498832 500057 501238 502962 504345 504812 504946 505850 508058 509459 512005 514447 517850 519176 521440 521595 523872 524271 524697 524779 525774 528274 541422 557557 584983 604978 607412 622472 717131 720609 729227 736797 741114 754176 761992 788815 794975 797749 797760 804452 808647 810531 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"видо порно"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вид порн"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.