Query Metrics
7
Database Queries
7
Different statements
162.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.69 ms (85.23%) |
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 124345 131512 187186 337889 383400 389973 397605 397678 406896 411715 421855 426125 426674 428255 428317 431488 435412 437972 438044 439175 440274 440534 441102 442372 443669 443956 444248 446813 447581 448148 449412 450198 452739 453234 454034 455335 456019 457023 457694 457923 458472 460293 461410 461594 461827 461993 463376 465294 465924 467617 469304 469638 470263 470503 470708 472396 473252 473601 474045 474404 475970 476334 477350 477711 477828 477986 478325 478387 478579 479273 479958 481495 481646 482135 483179 483989 484995 485821 486959 488196 490499 495122 495258 496995 498288 498865 500249 500462 501001 501676 504333 505271 505960 507508 510759 513924 517625 519681 520119 520500 523514 527176 527300 528133 528756 541139 551580 553915 556556 562592 563400 569579 578009 590307 602443 724853 731111 746213 788304 797126 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.69%) |
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 443669 457923 458472 469304 477986 437972 460293 461993 467617 507508 483989 498865 520119 495122 495258 505960 797126 520500 389973 483179 461594 501001 472396 473601 481646 444248 563400 590307 482135 500462 517625 562592 724853 465924 504333 484995 746213 443956 461827 474045 421855 426674 440534 448148 510759 496995 488196 602443 479958 124345 383400 187186 337889 397605 397678 406896 431488 440274 442372 428255 411715 441102 446813 450198 453234 463376 477711 447581 452739 454034 456019 457023 477828 478579 485821 501676 478325 481495 486959 553915 541139 551580 556556 569579 788304 731111 439175 478387 461410 470263 477350 438044 476334 131512 426125 428317 435412 457694 465294 469638 470503 470708 473252 528133 498288 500249 528756 513924 523514 527300 490499 519681 527176 455335 449412 474404 578009 475970 479273 505271 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.95%) |
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 124345 131512 187186 337889 383400 389973 397605 397678 406896 411715 421855 426125 426674 428255 428317 431488 435412 437972 438044 439175 440274 440534 441102 442372 443669 443956 444248 446813 447581 448148 449412 450198 452739 453234 454034 455335 456019 457023 457694 457923 458472 460293 461410 461594 461827 461993 463376 465294 465924 467617 469304 469638 470263 470503 470708 472396 473252 473601 474045 474404 475970 476334 477350 477711 477828 477986 478325 478387 478579 479273 479958 481495 481646 482135 483179 483989 484995 485821 486959 488196 490499 495122 495258 496995 498288 498865 500249 500462 501001 501676 504333 505271 505960 507508 510759 513924 517625 519681 520119 520500 523514 527176 527300 528133 528756 541139 551580 553915 556556 562592 563400 569579 578009 590307 602443 724853 731111 746213 788304 797126 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мужа трахает любовник"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс любовник"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен секс любовник"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.