Query Metrics
7
Database Queries
7
Different statements
198.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.67 ms (84.65%) |
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 388219 400936 410959 414339 418363 419861 420547 421352 422049 423940 425206 429768 433147 437470 451256 451935 452041 456437 469552 473172 473912 474649 476089 479004 500363 510395 515972 517842 519567 520770 522859 522901 529290 530010 530028 530491 530533 530784 530941 531088 531089 531136 531259 532754 532768 532839 533014 536588 540405 540577 541614 541833 541846 541884 542189 542956 545608 550194 561114 567581 571241 576690 582323 583960 584001 587013 590411 592440 592456 597204 599847 599863 599864 599888 599902 599961 599965 600019 600185 600289 600295 600296 600321 600355 601625 604868 617428 624155 629888 631178 632571 632636 632641 633124 636304 637434 639752 642002 642658 643027 646229 646771 646786 646849 646899 647860 649596 666852 676014 678493 679457 681691 683261 683831 698133 703833 775958 804464 814031 825812 ] |
||||||||||||||||||||||||||||||
|
20.57 ms (10.38%) |
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 561114 567581 571241 584001 592440 599864 601625 592456 624155 629888 599902 600295 604868 775958 423940 456437 420547 452041 510395 522859 522901 517842 519567 647860 599847 520770 541614 541833 515972 533014 500363 542956 698133 679457 388219 400936 410959 422049 421352 429768 814031 473912 479004 473172 532754 532768 530941 531089 536588 540577 530028 540405 474649 541884 576690 582323 541846 545608 550194 583960 678493 646771 666852 676014 683261 646229 646786 683831 600185 642002 642658 587013 590411 600321 639752 600355 632636 636304 643027 633124 637434 617428 631178 703833 804464 433147 437470 451935 532839 646849 649596 646899 597204 600289 632571 632641 451256 529290 542189 476089 469552 531088 531136 530784 531259 681691 600296 599863 599961 599888 599965 600019 418363 414339 419861 425206 825812 530010 530491 530533 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.36%) |
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 388219 400936 410959 414339 418363 419861 420547 421352 422049 423940 425206 429768 433147 437470 451256 451935 452041 456437 469552 473172 473912 474649 476089 479004 500363 510395 515972 517842 519567 520770 522859 522901 529290 530010 530028 530491 530533 530784 530941 531088 531089 531136 531259 532754 532768 532839 533014 536588 540405 540577 541614 541833 541846 541884 542189 542956 545608 550194 561114 567581 571241 576690 582323 583960 584001 587013 590411 592440 592456 597204 599847 599863 599864 599888 599902 599961 599965 600019 600185 600289 600295 600296 600321 600355 601625 604868 617428 624155 629888 631178 632571 632636 632641 633124 636304 637434 639752 642002 642658 643027 646229 646771 646786 646849 646899 647860 649596 666852 676014 678493 679457 681691 683261 683831 698133 703833 775958 804464 814031 825812 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal group"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал group"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал group"
]
|
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.