Query Metrics
7
Database Queries
7
Different statements
150.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.35 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.58 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy girl hot"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.91 ms |
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 390723 432980 523954 508530 447425 444935 491326 499365 443883 459961 521910 538608 546772 543435 556935 557563 591277 626066 604045 481933 470359 461673 543618 458222 495740 498357 491673 528149 582633 570221 791048 468888 503389 503735 807558 625164 568371 552444 644276 427209 484553 510876 520930 553208 589563 783311 811738 426926 522203 488189 580223 526536 541418 593641 635074 562243 582227 443733 513901 719336 588722 644748 520851 581873 471365 528146 604153 426399 470342 524388 569492 502648 591394 521192 543061 588294 523335 595755 513480 577888 474364 627773 583553 609795 554526 544472 625440 ] |
||||||||||||||||||||||||||||||
| 4 | 2.17 ms |
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 390723 426399 426926 427209 432980 443733 443883 444935 447425 458222 459961 461673 468888 470342 470359 471365 474364 481933 484553 488189 491326 491673 495740 498357 499365 502648 503389 503735 508530 510876 513480 513901 520851 520930 521192 521910 522203 523335 523954 524388 526536 528146 528149 538608 541418 543061 543435 543618 544472 546772 552444 553208 554526 556935 557563 562243 568371 569492 570221 577888 580223 581873 582227 582633 583553 588294 588722 589563 591277 591394 593641 595755 604045 604153 609795 625164 625440 626066 627773 635074 644276 644748 719336 783311 791048 807558 811738 ] |
||||||||||||||||||||||||||||||
| 5 | 127.04 ms |
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 390723 426399 426926 427209 432980 443733 443883 444935 447425 458222 459961 461673 468888 470342 470359 471365 474364 481933 484553 488189 491326 491673 495740 498357 499365 502648 503389 503735 508530 510876 513480 513901 520851 520930 521192 521910 522203 523335 523954 524388 526536 528146 528149 538608 541418 543061 543435 543618 544472 546772 552444 553208 554526 556935 557563 562243 568371 569492 570221 577888 580223 581873 582227 582633 583553 588294 588722 589563 591277 591394 593641 595755 604045 604153 609795 625164 625440 626066 627773 635074 644276 644748 719336 783311 791048 807558 811738 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy девушк hot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.39 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy девушк hot"
]
|
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.