Query Metrics
7
Database Queries
7
Different statements
168.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.69 ms (86.32%) |
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 188610 233365 323041 388700 388767 390205 391517 391938 391967 392603 394190 394420 400697 400722 400988 401807 409935 411322 411757 421895 422400 422989 424240 424269 424274 424435 434360 436948 440339 443692 443715 443772 443827 451521 452308 454177 454275 454513 456000 460730 460900 462305 462714 465388 466262 466270 466310 467263 467284 467523 468167 470275 470715 470717 470774 473328 473949 474074 474200 474681 474792 475621 475903 475927 476258 476377 477904 478350 479967 480886 486107 486357 487185 489224 494559 495224 495254 496822 502729 502805 505773 506432 506731 507003 509210 514585 516916 517711 518846 522759 523876 546011 552837 555118 560380 563401 563456 564661 572203 580640 589022 609238 620233 620240 620241 662432 669507 703448 712542 712563 716703 727760 729205 740593 761607 778654 784700 791330 804927 813532 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (8.12%) |
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 424269 456000 479967 784700 391938 506432 452308 400722 392603 394190 563401 703448 546011 778654 443715 409935 454275 388700 390205 475927 443827 470275 411322 462305 813532 467523 466262 474681 514585 475621 580640 473328 477904 424240 509210 486107 486357 609238 323041 476377 473949 572203 424435 424274 470715 516916 478350 620233 727760 467263 436948 421895 465388 466270 468167 454177 422989 443692 487185 496822 518846 495254 451521 454513 589022 552837 480886 507003 662432 522759 804927 564661 712542 712563 716703 411757 233365 560380 462714 474200 494559 505773 400988 460730 422400 476258 502729 443772 506731 394420 563456 467284 669507 791330 440339 391967 502805 466310 517711 391517 740593 620241 729205 761607 388767 470774 523876 474792 460900 495224 400697 188610 489224 555118 434360 470717 401807 620240 474074 475903 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.44%) |
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 188610 233365 323041 388700 388767 390205 391517 391938 391967 392603 394190 394420 400697 400722 400988 401807 409935 411322 411757 421895 422400 422989 424240 424269 424274 424435 434360 436948 440339 443692 443715 443772 443827 451521 452308 454177 454275 454513 456000 460730 460900 462305 462714 465388 466262 466270 466310 467263 467284 467523 468167 470275 470715 470717 470774 473328 473949 474074 474200 474681 474792 475621 475903 475927 476258 476377 477904 478350 479967 480886 486107 486357 487185 489224 494559 495224 495254 496822 502729 502805 505773 506432 506731 507003 509210 514585 516916 517711 518846 522759 523876 546011 552837 555118 560380 563401 563456 564661 572203 580640 589022 609238 620233 620240 620241 662432 669507 703448 712542 712563 716703 727760 729205 740593 761607 778654 784700 791330 804927 813532 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет русской женщины…"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс русск женщин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.96%) |
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.