Query Metrics
7
Database Queries
7
Different statements
164.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.69 ms (84.56%) |
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 402793 409085 409701 418697 419644 425724 432589 432631 453181 454091 454686 455693 457507 458170 468298 468956 472375 473454 474172 475329 480251 502323 507252 510926 511125 511856 516464 524836 526017 526163 527384 529611 530411 532220 534665 546324 547268 550106 550339 551930 557636 559171 568927 571164 584453 594831 597896 605605 609246 609686 614199 622952 623311 628067 632545 649459 656279 672727 680497 695602 700808 702854 708625 710164 714888 715151 715179 717473 718105 718117 719309 720178 720205 720521 721707 732003 775100 776667 776977 778333 787875 788678 793431 795756 800817 801709 802865 803599 804800 807237 810271 811721 814430 817105 817215 817638 818286 818891 818970 818982 819142 819170 819299 819377 819398 819473 820135 820376 823277 823918 823972 824707 825335 825369 825393 825445 825916 826711 826807 827559 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (9.61%) |
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 778333 788678 795756 800817 802865 807237 811721 418697 432589 454091 475329 468956 534665 511856 550339 584453 628067 787875 793431 732003 402793 425724 511125 468298 473454 516464 810271 804800 454686 455693 524836 419644 432631 409085 474172 803599 801709 409701 453181 458170 457507 472375 510926 814430 817638 819398 825916 826711 825335 817215 818891 819142 819377 824707 825369 825393 826807 817105 818286 818970 818982 819170 819473 820376 823277 825445 819299 820135 823972 823918 827559 480251 507252 532220 502323 526163 530411 526017 527384 529611 546324 550106 547268 557636 559171 571164 551930 680497 708625 719309 656279 672727 695602 702854 710164 714888 715179 720178 720205 720521 649459 700808 715151 717473 718105 718117 721707 568927 597896 605605 594831 609686 623311 609246 614199 622952 632545 775100 776667 776977 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.46%) |
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 402793 409085 409701 418697 419644 425724 432589 432631 453181 454091 454686 455693 457507 458170 468298 468956 472375 473454 474172 475329 480251 502323 507252 510926 511125 511856 516464 524836 526017 526163 527384 529611 530411 532220 534665 546324 547268 550106 550339 551930 557636 559171 568927 571164 584453 594831 597896 605605 609246 609686 614199 622952 623311 628067 632545 649459 656279 672727 680497 695602 700808 702854 708625 710164 714888 715151 715179 717473 718105 718117 719309 720178 720205 720521 721707 732003 775100 776667 776977 778333 787875 788678 793431 795756 800817 801709 802865 803599 804800 807237 810271 811721 814430 817105 817215 817638 818286 818891 818970 818982 819142 819170 819299 819377 819398 819473 820135 820376 823277 823918 823972 824707 825335 825369 825393 825445 825916 826711 826807 827559 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina webcam"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.92%) |
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.