Query Metrics
7
Database Queries
7
Different statements
189.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.45 ms (85.59%) |
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 189743 325228 390851 391155 391427 398534 411165 411682 421524 428405 442634 443470 443676 445670 449937 450104 450118 450122 450125 450126 450127 450128 450129 450130 450133 450134 450135 450136 450140 450141 450143 450146 450150 450151 450152 450155 450156 450160 450166 450187 450193 453128 456832 458126 461815 461835 462084 462095 462099 464658 466802 466908 466961 468096 469333 469384 469387 469388 470035 472418 472421 472596 472642 472649 473332 483358 485765 485795 489172 498219 498287 498310 498317 498438 534594 537855 538064 539548 539581 539622 546130 546290 546562 546563 546570 549206 549216 554796 554847 563065 598104 628694 629813 634868 710433 715554 727796 729169 731409 742716 744234 745447 747196 748372 755209 788962 789269 804022 804127 807882 808157 817417 823458 826341 826556 826886 826888 826986 827097 827179 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (9.27%) |
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 391427 826341 823458 539548 826556 826986 546562 731409 539581 747196 788962 748372 826888 729169 755209 325228 826886 546563 628694 458126 539622 745447 546570 807882 804127 634868 827179 549206 629813 391155 450126 742716 189743 472649 827097 727796 461835 390851 710433 428405 450155 817417 450193 546290 461815 450133 450128 489172 450146 450141 498317 808157 450136 450125 450118 466802 498287 469387 470035 445670 450134 450143 450122 744234 398534 443676 450104 411165 464658 450150 450160 411682 537855 469333 450152 450166 450151 450156 472642 473332 789269 472596 546130 450129 549216 462099 468096 449937 485795 466961 450140 450127 498310 498438 804022 598104 554796 453128 421524 450130 450135 469384 498219 485765 472418 469388 456832 466908 563065 450187 443470 472421 442634 462095 483358 534594 554847 715554 538064 462084 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.64%) |
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 189743 325228 390851 391155 391427 398534 411165 411682 421524 428405 442634 443470 443676 445670 449937 450104 450118 450122 450125 450126 450127 450128 450129 450130 450133 450134 450135 450136 450140 450141 450143 450146 450150 450151 450152 450155 450156 450160 450166 450187 450193 453128 456832 458126 461815 461835 462084 462095 462099 464658 466802 466908 466961 468096 469333 469384 469387 469388 470035 472418 472421 472596 472642 472649 473332 483358 485765 485795 489172 498219 498287 498310 498317 498438 534594 537855 538064 539548 539581 539622 546130 546290 546562 546563 546570 549206 549216 554796 554847 563065 598104 628694 629813 634868 710433 715554 727796 729169 731409 742716 744234 745447 747196 748372 755209 788962 789269 804022 804127 807882 808157 817417 823458 826341 826556 826886 826888 826986 827097 827179 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny amateurs sex"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny любительск секс"
]
|
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.