Query Metrics
7
Database Queries
7
Different statements
154.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.06 ms (85.04%) |
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 12983 51972 233737 282237 357595 382432 389132 390875 391182 391659 392004 392570 397923 398253 398646 398695 402762 411105 421915 421954 422989 424123 424179 424248 433359 433388 436138 439749 440601 445226 446179 447052 448378 454998 456591 457221 457417 457452 458063 461619 465581 465807 465986 466284 469092 469367 476928 478365 479583 480687 481824 482627 483624 483626 483642 483869 483901 490529 493172 493173 493179 494158 495758 496729 502885 505266 507543 508721 510884 512010 513194 517272 517425 518506 519585 520616 520861 521137 523743 523838 523867 527041 528489 533734 537267 537959 544509 544510 544988 545183 549836 555992 558875 568960 579049 583355 591144 604674 656291 663166 671197 680391 685810 731096 734330 734970 741578 742636 751120 766785 768359 779665 788356 794932 800487 819749 823740 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (8.87%) |
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 478365 421954 454998 433359 457452 447052 445226 508721 495758 483624 424248 482627 490529 469092 494158 544509 544510 568960 545183 583355 549836 604674 591144 751120 741578 476928 357595 457221 466284 479583 392004 436138 456591 398695 402762 411105 446179 448378 480687 507543 513194 517425 519585 523867 537267 512010 521137 483869 493179 496729 517272 523743 523838 528489 493172 505266 518506 392570 465807 433388 483626 555992 389132 12983 731096 742636 510884 734330 51972 558875 440601 397923 457417 458063 465581 469367 421915 493173 520861 527041 422989 390875 233737 424179 483901 424123 398253 391659 465986 483642 461619 481824 533734 663166 788356 790440 282237 382432 391182 579049 805492 768359 800487 398646 439749 502885 819749 823740 685810 656291 794309 794932 734970 766785 779665 520616 537959 544988 671197 680391 ] |
||||||||||||||||||||||||||||||
|
3.00 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 12983 51972 233737 282237 357595 382432 389132 390875 391182 391659 392004 392570 397923 398253 398646 398695 402762 411105 421915 421954 422989 424123 424179 424248 433359 433388 436138 439749 440601 445226 446179 447052 448378 454998 456591 457221 457417 457452 458063 461619 465581 465807 465986 466284 469092 469367 476928 478365 479583 480687 481824 482627 483624 483626 483642 483869 483901 490529 493172 493173 493179 494158 495758 496729 502885 505266 507543 508721 510884 512010 513194 517272 517425 518506 519585 520616 520861 521137 523743 523838 523867 527041 528489 533734 537267 537959 544509 544510 544988 545183 549836 555992 558875 568960 579049 583355 591144 604674 656291 663166 671197 680391 685810 731096 734330 734970 741578 742636 751120 766785 768359 779665 788356 794932 800487 819749 823740 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian doggy anal"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск рак анал"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.87%) |
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.