Query Metrics
7
Database Queries
7
Different statements
159.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.13 ms (85.83%) |
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 382251 397714 400848 403272 421009 423585 427046 430815 444253 444939 447049 451281 452742 453973 459938 460080 461597 461625 462006 466569 470246 471090 471409 473040 476458 476620 477870 480112 480121 480240 480242 481626 497752 498832 503398 518150 521070 524576 527894 585782 588460 589077 589472 589485 589536 589876 589889 589899 589914 589989 590066 590078 590121 590609 595026 598311 598381 601218 601374 602836 604063 605333 608881 611230 612703 612816 614231 620958 624300 628431 629141 629665 634309 635230 638191 642308 642697 703547 708643 709181 713206 715711 716087 717844 720451 723874 724429 724432 730345 736055 741278 741323 741427 741545 743531 744697 755689 756273 756640 756990 758705 760612 763046 765245 771324 776154 780507 792062 792813 797656 799543 800113 802505 805000 806855 807163 811500 811630 812697 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (7.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 589077 589472 589536 590066 590078 601374 611230 612703 620958 624300 629141 585782 589989 594372 595026 601218 604063 608881 612816 642308 589876 589899 589914 590609 598311 614231 629665 635230 588460 589485 589889 590121 598381 602836 628431 634309 776154 780507 792813 799543 800113 805000 806855 741323 758705 760612 792062 797656 811500 812697 724429 724432 730345 736055 771324 723874 755689 756273 741278 743531 744697 756640 763046 765245 741427 741545 756990 605333 638191 642697 703547 708643 709181 713206 715711 716087 717844 720451 802505 807163 811630 427046 430815 481626 382251 471090 477870 480242 397714 400848 423585 452742 453973 461597 461625 462006 470246 476458 476620 480240 403272 444253 444939 473040 480112 480121 421009 447049 451281 459938 460080 466569 471409 527894 498832 521070 524576 497752 503398 518150 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.88%) |
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 382251 397714 400848 403272 421009 423585 427046 430815 444253 444939 447049 451281 452742 453973 459938 460080 461597 461625 462006 466569 470246 471090 471409 473040 476458 476620 477870 480112 480121 480240 480242 481626 497752 498832 503398 518150 521070 524576 527894 585782 588460 589077 589472 589485 589536 589876 589889 589899 589914 589989 590066 590078 590121 590609 595026 598311 598381 601218 601374 602836 604063 605333 608881 611230 612703 612816 614231 620958 624300 628431 629141 629665 634309 635230 638191 642308 642697 703547 708643 709181 713206 715711 716087 717844 720451 723874 724429 724432 730345 736055 741278 741323 741427 741545 743531 744697 755689 756273 756640 756990 758705 760612 763046 765245 771324 776154 780507 792062 792813 797656 799543 800113 802505 805000 806855 807163 811500 811630 812697 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"perfect cock"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"perfect cock"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"perfect cock"
]
|
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.