Query Metrics
7
Database Queries
7
Different statements
174.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.08 ms (85.53%) |
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 80709 185143 192968 223551 263299 387470 390980 397217 397258 397860 398878 401007 402107 402342 402677 406800 412287 412639 420364 420480 421294 422380 423458 426503 426721 429179 429267 429565 432374 433072 434596 434891 435043 435818 437756 438356 443397 444048 444373 447235 449175 452045 452252 453075 453107 453439 453993 455819 456299 456655 457003 457923 458362 458732 459608 460465 461822 462087 463111 466865 467575 468501 469326 469618 470001 470446 471186 473999 474011 474036 474137 475179 475256 476274 476974 477296 477691 478238 479092 479645 480855 481333 482138 484193 485319 488282 491362 493160 495061 497078 497524 498459 498846 498921 501040 501568 502594 503354 503496 504188 506305 507630 508562 509009 520174 523967 524432 527187 527564 541878 543567 558515 563148 564773 568085 569104 571497 578010 601717 635251 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (9.03%) |
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 444373 426721 457003 458362 449175 452252 453993 456655 452045 453107 564773 571497 402107 471186 474011 480855 438356 457923 470001 470446 481333 420364 497078 498921 527187 498846 497524 503354 463111 635251 397258 420480 421294 453439 460465 192968 455819 434596 476974 479092 527564 412287 432374 401007 422380 503496 437756 456299 263299 80709 387470 397217 423458 412639 474137 485319 495061 501568 466865 475179 475256 476274 541878 563148 402342 429267 435043 469326 397860 429179 398878 406800 443397 426503 435818 508562 491362 493160 509009 523967 507630 504188 223551 429565 433072 469618 474036 477296 543567 568085 569104 390980 444048 473999 434891 461822 453075 501040 484193 488282 578010 478238 468501 524432 402677 479645 482138 467575 447235 459608 462087 477691 458732 520174 502594 601717 498459 558515 506305 185143 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.40%) |
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 80709 185143 192968 223551 263299 387470 390980 397217 397258 397860 398878 401007 402107 402342 402677 406800 412287 412639 420364 420480 421294 422380 423458 426503 426721 429179 429267 429565 432374 433072 434596 434891 435043 435818 437756 438356 443397 444048 444373 447235 449175 452045 452252 453075 453107 453439 453993 455819 456299 456655 457003 457923 458362 458732 459608 460465 461822 462087 463111 466865 467575 468501 469326 469618 470001 470446 471186 473999 474011 474036 474137 475179 475256 476274 476974 477296 477691 478238 479092 479645 480855 481333 482138 484193 485319 488282 491362 493160 495061 497078 497524 498459 498846 498921 501040 501568 502594 503354 503496 504188 506305 507630 508562 509009 520174 523967 524432 527187 527564 541878 543567 558515 563148 564773 568085 569104 571497 578010 601717 635251 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"баба с пись"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод вагин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.87%) |
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.