Query Metrics
7
Database Queries
7
Different statements
163.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.84 ms (82.40%) |
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 390818 391945 391984 395596 395676 395819 395842 395845 401615 401935 404459 404644 404698 405070 405830 406371 415147 417835 421974 423633 424410 424461 425977 427115 427508 428706 430002 434367 434371 437797 443695 444733 447094 448819 449872 451265 451473 452950 454531 457463 457480 458011 458523 460188 462008 464971 465209 466721 467118 467121 467614 467889 468061 468946 470286 470565 472611 473366 473439 474034 474463 477116 478437 479668 479779 480212 481285 483338 486542 486834 489423 491440 491769 493083 493221 493411 496063 502089 502283 504093 505394 510898 511391 513149 518587 522153 522608 522868 522918 523565 526504 547426 555204 555263 555264 555340 555360 560958 568991 569302 571441 574237 574387 576633 576703 590948 592388 604489 610047 615012 618483 629428 671739 700975 703902 756406 786525 802723 803492 818426 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (11.63%) |
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 818426 457463 465209 466721 477116 468946 473366 478437 457480 458011 467121 470565 518587 502089 511391 526504 468061 472611 480212 489423 555263 555264 568991 560958 574387 576633 547426 555360 571441 574237 700975 671739 555204 576703 604489 610047 590948 592388 618483 803492 391984 395819 404644 427115 460188 467889 474463 395845 395596 458523 427508 569302 467118 464971 425977 451473 493411 629428 428706 522153 504093 395842 390818 401615 437797 486834 448819 451265 454531 491769 447094 474034 479779 486542 522918 479668 555340 703902 786525 756406 802723 424410 449872 462008 391945 443695 401935 434367 405070 405830 424461 434371 481285 415147 417835 430002 444733 522608 483338 496063 513149 505394 491440 522868 404698 467614 473439 493221 421974 470286 406371 452950 493083 510898 615012 502283 523565 395676 404459 423633 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.47%) |
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 390818 391945 391984 395596 395676 395819 395842 395845 401615 401935 404459 404644 404698 405070 405830 406371 415147 417835 421974 423633 424410 424461 425977 427115 427508 428706 430002 434367 434371 437797 443695 444733 447094 448819 449872 451265 451473 452950 454531 457463 457480 458011 458523 460188 462008 464971 465209 466721 467118 467121 467614 467889 468061 468946 470286 470565 472611 473366 473439 474034 474463 477116 478437 479668 479779 480212 481285 483338 486542 486834 489423 491440 491769 493083 493221 493411 496063 502089 502283 504093 505394 510898 511391 513149 518587 522153 522608 522868 522918 523565 526504 547426 555204 555263 555264 555340 555360 560958 568991 569302 571441 574237 574387 576633 576703 590948 592388 604489 610047 615012 618483 629428 671739 700975 703902 756406 786525 802723 803492 818426 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf hairy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf волосатая"
]
|
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.