Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "fuck daughter"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fuck daughter' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  519038
  418953
  477346
  536214
  442946
  456600
  431376
  500578
  400249
  454871
  540791
  518349
  464324
  444844
  506619
  518559
  563929
  516796
  404742
  412288
  564826
  599659
  495198
  519632
  529212
  545501
  471639
  519931
  486198
  452178
  456915
  395666
  482350
  425523
  494345
  489082
  482555
  447706
  486540
  799936
  430570
  513375
  569835
  421907
  477079
  486594
  523030
  444003
  565050
  491963
  514824
  491978
  550571
  550230
  591585
  502995
  623818
  602569
  509666
  420635
  429409
  518960
  424780
  517008
  458719
  460673
  466963
  484519
  675006
  474035
  623616
  603878
  605953
  524281
  520008
  513148
  602734
  534645
  485313
  517000
  560511
  499882
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (519038, 418953, 477346, 536214, 442946, 456600, 431376, 500578, 400249, 454871, 540791, 518349, 464324, 444844, 506619, 518559, 563929, 516796, 404742, 412288, 564826, 599659, 495198, 519632, 529212, 545501, 471639, 519931, 486198, 452178, 456915, 395666, 482350, 425523, 494345, 489082, 482555, 447706, 486540, 799936, 430570, 513375, 569835, 421907, 477079, 486594, 523030, 444003, 565050, 491963, 514824, 491978, 550571, 550230, 591585, 502995, 623818, 602569, 509666, 420635, 429409, 518960, 424780, 517008, 458719, 460673, 466963, 484519, 675006, 474035, 623616, 603878, 605953, 524281, 520008, 513148, 602734, 534645, 485313, 517000, 560511, 499882);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  395666
  400249
  404742
  412288
  418953
  420635
  421907
  424780
  425523
  429409
  430570
  431376
  442946
  444003
  444844
  447706
  452178
  454871
  456600
  456915
  458719
  460673
  464324
  466963
  471639
  474035
  477079
  477346
  482350
  482555
  484519
  485313
  486198
  486540
  486594
  489082
  491963
  491978
  494345
  495198
  499882
  500578
  502995
  506619
  509666
  513148
  513375
  514824
  516796
  517000
  517008
  518349
  518559
  518960
  519038
  519632
  519931
  520008
  523030
  524281
  529212
  534645
  536214
  540791
  545501
  550230
  550571
  560511
  563929
  564826
  565050
  569835
  591585
  599659
  602569
  602734
  603878
  605953
  623616
  623818
  675006
  799936
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (395666, 400249, 404742, 412288, 418953, 420635, 421907, 424780, 425523, 429409, 430570, 431376, 442946, 444003, 444844, 447706, 452178, 454871, 456600, 456915, 458719, 460673, 464324, 466963, 471639, 474035, 477079, 477346, 482350, 482555, 484519, 485313, 486198, 486540, 486594, 489082, 491963, 491978, 494345, 495198, 499882, 500578, 502995, 506619, 509666, 513148, 513375, 514824, 516796, 517000, 517008, 518349, 518559, 518960, 519038, 519632, 519931, 520008, 523030, 524281, 529212, 534645, 536214, 540791, 545501, 550230, 550571, 560511, 563929, 564826, 565050, 569835, 591585, 599659, 602569, 602734, 603878, 605953, 623616, 623818, 675006, 799936);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  395666
  400249
  404742
  412288
  418953
  420635
  421907
  424780
  425523
  429409
  430570
  431376
  442946
  444003
  444844
  447706
  452178
  454871
  456600
  456915
  458719
  460673
  464324
  466963
  471639
  474035
  477079
  477346
  482350
  482555
  484519
  485313
  486198
  486540
  486594
  489082
  491963
  491978
  494345
  495198
  499882
  500578
  502995
  506619
  509666
  513148
  513375
  514824
  516796
  517000
  517008
  518349
  518559
  518960
  519038
  519632
  519931
  520008
  523030
  524281
  529212
  534645
  536214
  540791
  545501
  550230
  550571
  560511
  563929
  564826
  565050
  569835
  591585
  599659
  602569
  602734
  603878
  605953
  623616
  623818
  675006
  799936
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (395666, 400249, 404742, 412288, 418953, 420635, 421907, 424780, 425523, 429409, 430570, 431376, 442946, 444003, 444844, 447706, 452178, 454871, 456600, 456915, 458719, 460673, 464324, 466963, 471639, 474035, 477079, 477346, 482350, 482555, 484519, 485313, 486198, 486540, 486594, 489082, 491963, 491978, 494345, 495198, 499882, 500578, 502995, 506619, 509666, 513148, 513375, 514824, 516796, 517000, 517008, 518349, 518559, 518960, 519038, 519632, 519931, 520008, 523030, 524281, 529212, 534645, 536214, 540791, 545501, 550230, 550571, 560511, 563929, 564826, 565050, 569835, 591585, 599659, 602569, 602734, 603878, 605953, 623616, 623818, 675006, 799936);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "секс daughter"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс daughter';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "секс daughter"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс daughter';