Query Metrics
7
Database Queries
7
Different statements
164.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.49 ms (83.17%) |
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 330511 391926 393107 400470 401804 418969 423823 427655 430818 433937 443832 448636 452290 456493 462352 462586 464811 464837 465320 465923 468895 469187 470473 474242 474699 475837 481824 482231 513394 534670 536458 537264 555103 565233 570145 572625 577358 579227 589067 600274 600356 618908 620234 626293 627362 634975 635916 660435 686457 710541 712546 716303 719097 719957 720002 720126 723153 724194 728308 729299 730315 731381 732346 736062 736249 741541 762887 765554 765940 769044 769645 770408 774032 777732 778379 779224 781796 782182 784396 786945 787488 788597 789531 790100 790333 791543 791580 792100 794355 795189 795197 795538 797443 798344 798493 800489 800492 803776 805431 807912 812979 813663 813770 813771 814178 814333 815077 815688 815929 817238 817273 817546 817579 818368 820956 824876 826118 826457 827580 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (10.64%) |
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 465923 474699 464837 618908 777732 462352 391926 393107 464811 470473 513394 824876 826457 827580 813663 817579 824210 826118 468895 720002 565233 634975 786945 795189 790333 795197 774032 736062 762887 790100 798493 813770 789531 433937 813771 452290 570145 781796 731381 710541 716303 330511 427655 474242 536458 443832 400470 814178 817273 814333 815929 818368 820956 817238 815077 469187 475837 465320 482231 537264 577358 572625 719097 719957 723153 555103 600274 600356 626293 635916 627362 787488 795538 798344 805431 791580 797443 800492 784396 788597 812979 724194 765554 730315 741541 769645 620234 778379 779224 807912 462586 418969 430818 534670 401804 423823 815688 817546 448636 456493 481824 712546 720126 660435 686457 579227 589067 792100 803776 782182 800489 791543 794355 729299 736249 765940 769044 728308 732346 770408 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.90%) |
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 330511 391926 393107 400470 401804 418969 423823 427655 430818 433937 443832 448636 452290 456493 462352 462586 464811 464837 465320 465923 468895 469187 470473 474242 474699 475837 481824 482231 513394 534670 536458 537264 555103 565233 570145 572625 577358 579227 589067 600274 600356 618908 620234 626293 627362 634975 635916 660435 686457 710541 712546 716303 719097 719957 720002 720126 723153 724194 728308 729299 730315 731381 732346 736062 736249 741541 762887 765554 765940 769044 769645 770408 774032 777732 778379 779224 781796 782182 784396 786945 787488 788597 789531 790100 790333 791543 791580 792100 794355 795189 795197 795538 797443 798344 798493 800489 800492 803776 805431 807912 812979 813663 813770 813771 814178 814333 815077 815688 815929 817238 817273 817546 817579 818368 820956 824876 826118 826457 827580 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard mother"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard мам женщин"
]
|
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.