Query Metrics
7
Database Queries
7
Different statements
184.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.85 ms (87.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 8043 8497 46446 51420 146547 308684 314397 380426 382373 383596 384853 391328 395389 395498 396142 396315 397435 398022 398274 398412 400439 401114 401466 401559 402601 410255 413208 413289 416320 420023 420096 420855 421412 423615 425249 425884 430064 431182 431735 439837 440617 444226 447515 459560 459700 460215 461302 461670 462303 462518 465950 473861 474904 475503 477876 484434 484528 488150 491188 492153 492158 496519 497071 498101 502720 506217 509520 512259 513771 521363 521375 522412 524210 526595 533138 536937 542936 543662 553362 554267 554966 560469 562702 565378 567696 568821 590308 596347 598558 599086 614939 637757 651955 654376 682691 684679 709295 709306 713014 713062 722035 729373 734130 738877 739312 747550 763232 766131 773413 775297 783272 784684 791827 791842 793734 795554 795708 805027 807345 812872 ] |
||||||||||||||||||||||||||||||
|
13.32 ms (7.23%) |
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 46446 396315 420096 8043 382373 722035 568821 775297 462518 421412 444226 459700 461670 425249 536937 554966 380426 425884 401466 314397 496519 51420 484528 460215 565378 542936 684679 805027 795554 398412 465950 440617 492158 512259 522412 521363 391328 713062 599086 475503 738877 308684 498101 502720 654376 713014 709295 431735 431182 413208 560469 598558 473861 491188 447515 492153 524210 402601 146547 739312 791842 413289 474904 543662 682691 637757 784684 793734 763232 734130 729373 773413 614939 791827 812872 461302 398274 795708 459560 521375 410255 484434 430064 400439 567696 401114 533138 439837 488150 397435 709306 553362 398022 506217 497071 513771 395498 396142 420023 766131 383596 384853 420855 526595 554267 651955 747550 783272 462303 509520 423615 8497 596347 401559 416320 562702 590308 807345 477876 395389 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.73%) |
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 8043 8497 46446 51420 146547 308684 314397 380426 382373 383596 384853 391328 395389 395498 396142 396315 397435 398022 398274 398412 400439 401114 401466 401559 402601 410255 413208 413289 416320 420023 420096 420855 421412 423615 425249 425884 430064 431182 431735 439837 440617 444226 447515 459560 459700 460215 461302 461670 462303 462518 465950 473861 474904 475503 477876 484434 484528 488150 491188 492153 492158 496519 497071 498101 502720 506217 509520 512259 513771 521363 521375 522412 524210 526595 533138 536937 542936 543662 553362 554267 554966 560469 562702 565378 567696 568821 590308 596347 598558 599086 614939 637757 651955 654376 682691 684679 709295 709306 713014 713062 722035 729373 734130 738877 739312 747550 763232 766131 773413 775297 783272 784684 791827 791842 793734 795554 795708 805027 807345 812872 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blowjob sex"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая минет оральн секс секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
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.