Query Metrics
7
Database Queries
7
Different statements
172.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.97 ms (85.63%) |
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 74434 145280 153922 161969 197736 212982 213429 232995 233112 233193 233344 233512 233570 233862 311237 365910 365962 365993 382420 382937 385408 388767 391554 391654 391705 392030 392095 392208 392671 394194 395925 395955 397629 400708 401055 401575 402306 402896 402955 402960 419543 419546 443691 453784 459514 465393 466338 470174 470621 470670 470674 470690 471072 477970 482953 485945 486209 487246 490890 493154 503499 508382 508869 510684 513811 520881 521147 523019 526114 526482 532827 534621 536324 537233 543738 545535 550475 551937 569891 578348 581931 583099 586443 601846 603964 604121 609210 614962 617641 617654 619065 620243 622831 665217 696324 718775 721488 721497 721572 731546 741460 741464 748509 754106 754946 755757 766541 777205 777564 781650 781674 781744 782230 789294 795706 816997 819010 825863 827951 827972 ] |
||||||||||||||||||||||||||||||
|
15.24 ms (8.82%) |
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 493154 419546 617654 161969 365993 510684 782230 392208 520881 816997 741464 459514 382937 401055 232995 233344 382420 609210 545535 471072 402306 490890 391554 617641 400708 543738 604121 526482 827972 721488 721497 766541 781674 755757 731546 385408 145280 477970 453784 534621 395925 470174 827951 486209 521147 392095 212982 391654 466338 233112 394194 470690 601846 550475 482953 620243 523019 392671 532827 665217 721572 777205 795706 470621 470670 153922 213429 402955 419543 470674 508869 487246 583099 603964 74434 391705 233570 233193 401575 537233 578348 696324 748509 388767 397629 402960 503499 233512 311237 365962 619065 551937 513811 233862 392030 465393 485945 819010 825863 536324 569891 614962 586443 789294 741460 754946 754106 718775 777564 781650 781744 526114 197736 395955 622831 508382 581931 365910 402896 443691 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.77%) |
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 74434 145280 153922 161969 197736 212982 213429 232995 233112 233193 233344 233512 233570 233862 311237 365910 365962 365993 382420 382937 385408 388767 391554 391654 391705 392030 392095 392208 392671 394194 395925 395955 397629 400708 401055 401575 402306 402896 402955 402960 419543 419546 443691 453784 459514 465393 466338 470174 470621 470670 470674 470690 471072 477970 482953 485945 486209 487246 490890 493154 503499 508382 508869 510684 513811 520881 521147 523019 526114 526482 532827 534621 536324 537233 543738 545535 550475 551937 569891 578348 581931 583099 586443 601846 603964 604121 609210 614962 617641 617654 619065 620243 622831 665217 696324 718775 721488 721497 721572 731546 741460 741464 748509 754106 754946 755757 766541 777205 777564 781650 781674 781744 782230 789294 795706 816997 819010 825863 827951 827972 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"руских женщин"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск женщин"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.75%) |
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.