Query Metrics
7
Database Queries
7
Different statements
164.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.20 ms (82.92%) |
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 73289 73293 187919 293121 382637 383091 383117 383561 384762 387815 388024 388204 390366 393135 397080 397882 397942 405760 410676 415774 421548 424281 425556 429888 431105 433250 439565 439797 439815 441765 444519 451832 452284 455901 458523 459535 466564 470174 470923 471125 473779 475308 480379 487413 489729 489777 493411 495566 499359 500734 503499 509218 511254 511345 512749 512928 512975 516332 517928 520767 522681 523883 532380 541225 541851 543496 545253 546817 547423 547433 547583 551810 555054 556044 556426 562859 564224 578207 579341 579517 579582 582277 583665 584301 584712 601935 602249 603830 604280 605746 606937 607230 610035 616152 620113 624196 628708 637187 646432 668688 677971 678969 719022 723591 735448 755930 760738 761053 778643 788193 791547 794842 794887 800333 800457 800511 805784 817155 817336 819053 ] |
||||||||||||||||||||||||||||||
|
18.30 ms (11.14%) |
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 455901 431105 480379 523883 509218 512749 678969 429888 487413 562859 489777 383091 547423 616152 439815 603830 390366 424281 547583 545253 551810 624196 606937 628708 397080 495566 517928 439797 475308 520767 522681 500734 471125 556426 579582 541851 668688 602249 466564 601935 439565 388204 817336 817155 794887 800511 646432 584712 607230 459535 584301 579341 555054 605746 546817 578207 583665 473779 452284 512975 516332 511254 532380 489729 493411 604280 410676 800457 819053 788193 760738 778643 383117 470174 564224 610035 451832 421548 556044 755930 637187 543496 458523 512928 620113 187919 723591 677971 791547 800333 805784 735448 761053 393135 293121 387815 503499 415774 425556 405760 499359 541225 579517 383561 388024 794842 433250 582277 511345 384762 73289 397942 547433 719022 397882 470923 382637 73293 441765 444519 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.56%) |
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 73289 73293 187919 293121 382637 383091 383117 383561 384762 387815 388024 388204 390366 393135 397080 397882 397942 405760 410676 415774 421548 424281 425556 429888 431105 433250 439565 439797 439815 441765 444519 451832 452284 455901 458523 459535 466564 470174 470923 471125 473779 475308 480379 487413 489729 489777 493411 495566 499359 500734 503499 509218 511254 511345 512749 512928 512975 516332 517928 520767 522681 523883 532380 541225 541851 543496 545253 546817 547423 547433 547583 551810 555054 556044 556426 562859 564224 578207 579341 579517 579582 582277 583665 584301 584712 601935 602249 603830 604280 605746 606937 607230 610035 616152 620113 624196 628708 637187 646432 668688 677971 678969 719022 723591 735448 755930 760738 761053 778643 788193 791547 794842 794887 800333 800457 800511 805784 817155 817336 819053 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщина анус"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин анус"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.89%) |
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.