Query Metrics
7
Database Queries
7
Different statements
178.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.46 ms (85.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 389098 389895 392754 397916 398559 400845 411370 419524 419529 421863 421884 422200 424114 424123 439697 439701 439730 439757 439780 439781 439795 439808 439816 440614 440693 442912 443139 454274 454501 457460 461619 465581 465963 466140 466189 466233 466250 466265 467457 469367 469390 470203 470213 470286 470683 471405 471643 474627 474695 475103 477725 478379 481628 481824 484626 484645 486346 490424 490430 490438 491114 491906 493173 495224 495811 509043 509204 514585 515923 517272 520616 520861 523838 523841 523902 526494 526527 527041 528343 534709 535436 536443 541575 543768 544493 544494 544988 545209 552286 555075 555098 555101 555992 559065 563098 563161 565715 573801 576537 589590 605725 615516 663337 712553 712580 718524 734970 764963 766523 788782 794773 795296 795706 801294 807326 817293 818051 819749 820197 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (9.65%) |
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 517272 523838 523902 526527 389895 466189 439816 563161 544494 411370 469390 466140 466233 467457 471405 392754 397916 398559 439808 466265 439697 443139 490438 490424 491906 535436 419524 470286 474627 465963 544493 563098 573801 589590 422200 481628 440614 440693 454274 470203 470213 439757 439795 477725 439780 442912 466250 509204 509043 515923 526494 536443 484645 490430 555992 541575 764963 788782 817293 555098 555101 712580 555075 565715 615516 712553 718524 419529 421884 478379 465581 469367 421863 493173 520861 523841 527041 528343 552286 807326 389098 457460 484626 491114 559065 545209 400845 439781 439701 439730 454501 486346 424123 495811 818051 819749 820197 794309 734970 794773 424114 461619 470683 471643 481824 766523 534709 475103 605725 474695 495224 514585 520616 543768 576537 544988 663337 801294 795296 795706 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.31%) |
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 389098 389895 392754 397916 398559 400845 411370 419524 419529 421863 421884 422200 424114 424123 439697 439701 439730 439757 439780 439781 439795 439808 439816 440614 440693 442912 443139 454274 454501 457460 461619 465581 465963 466140 466189 466233 466250 466265 467457 469367 469390 470203 470213 470286 470683 471405 471643 474627 474695 475103 477725 478379 481628 481824 484626 484645 486346 490424 490430 490438 491114 491906 493173 495224 495811 509043 509204 514585 515923 517272 520616 520861 523838 523841 523902 526494 526527 527041 528343 534709 535436 536443 541575 543768 544493 544494 544988 545209 552286 555075 555098 555101 555992 559065 563098 563161 565715 573801 576537 589590 605725 615516 663337 712553 712580 718524 734970 764963 766523 788782 794773 795296 795706 801294 807326 817293 818051 819749 820197 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal mature"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал mature"
]
|
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.