Query Metrics
7
Database Queries
7
Different statements
152.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.88 ms (84.12%) |
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 24218 24224 24356 24855 61969 95982 156525 185855 188335 197358 247330 247538 327121 367800 381757 382511 384340 385933 389918 391121 391475 391483 395439 396323 396418 397199 397811 400196 400507 403419 408351 412078 414946 415342 415543 416018 420333 421844 422185 424048 424125 425640 425865 438614 439437 442629 442915 444126 444709 449079 453107 454533 454537 457686 459239 459963 461788 462291 465542 467628 469096 470400 473921 477691 480398 485265 485870 489381 490030 495228 499587 507547 508746 515631 517004 519422 526527 526767 528215 531984 532444 537107 542211 553155 560380 563233 563642 564337 571298 573303 576537 579991 603054 610197 625219 637318 666196 680778 686009 714911 720410 726219 726519 728255 729292 731389 736378 738382 740289 746705 752619 781648 784305 788599 799352 799359 802019 803306 808533 810045 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (9.90%) |
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 462291 467628 515631 499587 563233 528215 560380 461788 625219 442629 403419 414946 726519 517004 610197 485265 24224 421844 680778 736378 420333 726219 424125 576537 746705 459963 731389 391483 439437 395439 729292 416018 714911 384340 799352 728255 382511 537107 573303 400507 24855 24356 415342 465542 247330 396323 803306 391121 457686 396418 367800 389918 485870 526527 799359 738382 197358 425865 438614 247538 477691 469096 781648 156525 185855 397811 784305 810045 391475 532444 459239 603054 752619 408351 412078 397199 526767 637318 802019 61969 444126 519422 808533 489381 686009 720410 188335 454537 24218 531984 542211 385933 95982 564337 422185 442915 470400 579991 788599 327121 507547 740289 480398 425640 495228 381757 571298 424048 473921 508746 444709 454533 453107 666196 415543 490030 400196 553155 449079 563642 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.67%) |
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 24218 24224 24356 24855 61969 95982 156525 185855 188335 197358 247330 247538 327121 367800 381757 382511 384340 385933 389918 391121 391475 391483 395439 396323 396418 397199 397811 400196 400507 403419 408351 412078 414946 415342 415543 416018 420333 421844 422185 424048 424125 425640 425865 438614 439437 442629 442915 444126 444709 449079 453107 454533 454537 457686 459239 459963 461788 462291 465542 467628 469096 470400 473921 477691 480398 485265 485870 489381 490030 495228 499587 507547 508746 515631 517004 519422 526527 526767 528215 531984 532444 537107 542211 553155 560380 563233 563642 564337 571298 573303 576537 579991 603054 610197 625219 637318 666196 680778 686009 714911 720410 726219 726519 728255 729292 731389 736378 738382 740289 746705 752619 781648 784305 788599 799352 799359 802019 803306 808533 810045 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom mother"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.