Query Metrics
7
Database Queries
7
Different statements
183.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.55 ms (86.41%) |
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 150470 154127 154675 155257 382810 396784 398684 400802 401204 409060 410239 419167 419822 421582 423434 425294 426600 427722 434349 436054 441040 443250 448351 450434 450518 452637 454793 457650 462495 467563 467577 467633 467636 468670 468823 471330 473873 475226 485471 496125 505093 505387 508986 510800 512363 514863 522112 523250 528922 529617 536475 540911 550550 552819 553224 556872 556900 556907 556909 559783 564297 575366 576479 576848 577038 578003 580121 580130 581121 583227 583474 584046 591604 593230 594619 615065 619281 619322 627233 627498 634095 652758 670367 670372 671043 673578 679270 689074 695386 705005 706631 709674 709786 715244 721992 722395 736164 739119 742359 745918 758164 760381 760392 761752 777016 788863 792741 793151 794220 794229 794248 796833 796843 797003 800658 801615 801620 801639 803837 826278 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (8.59%) |
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 529617 467636 576479 540911 559783 564297 583227 695386 706631 709786 715244 553224 556907 580130 594619 615065 627233 794229 800658 801620 801639 777016 793151 797003 760381 803837 736164 739119 760392 761752 742359 745918 788863 792741 794220 794248 801615 398684 425294 155257 419822 421582 396784 473873 512363 508986 523250 556900 556909 468823 505387 552819 575366 577038 584046 550550 578003 581121 705005 556872 576848 619281 593230 619322 634095 591604 796843 796833 758164 510800 450434 528922 627498 410239 689074 471330 426600 452637 475226 536475 462495 580121 652758 496125 522112 154675 514863 382810 154127 150470 400802 401204 409060 423434 419167 427722 434349 441040 443250 436054 826278 467563 468670 457650 467577 485471 448351 450518 454793 505093 467633 583474 670367 671043 679270 709674 722395 670372 673578 721992 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.42%) |
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 150470 154127 154675 155257 382810 396784 398684 400802 401204 409060 410239 419167 419822 421582 423434 425294 426600 427722 434349 436054 441040 443250 448351 450434 450518 452637 454793 457650 462495 467563 467577 467633 467636 468670 468823 471330 473873 475226 485471 496125 505093 505387 508986 510800 512363 514863 522112 523250 528922 529617 536475 540911 550550 552819 553224 556872 556900 556907 556909 559783 564297 575366 576479 576848 577038 578003 580121 580130 581121 583227 583474 584046 591604 593230 594619 615065 619281 619322 627233 627498 634095 652758 670367 670372 671043 673578 679270 689074 695386 705005 706631 709674 709786 715244 721992 722395 736164 739119 742359 745918 758164 760381 760392 761752 777016 788863 792741 793151 794220 794229 794248 796833 796843 797003 800658 801615 801620 801639 803837 826278 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife fisting"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.