array(44) {
[0]=>
string(66) "SELECT * FROM nb_user WHERE id = '19' and status = 1 and del = -1 "
[1]=>
string(716) "SELECT p.*,
pl.id as langId,
pl.pageId,
pl.mid,
pl.lang,
pl.name as title,
pl.shortDescription,
pl.content,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.mailingListJson
FROM nb_page p
INNER JOIN nb_page_lang pl ON (pl.pageId = p.id AND pl.lang = 'ba' )
WHERE p.status = 1 AND p.del = -1 AND p.countryId = 1 AND pl.permalink = 'project-rock' "
[2]=>
string(825) "SELECT p.*,
SUBSTRING(SUBSTRING_INDEX(p.path, '/', 2), 2) as mainProductGroupId,
pgl.id as productGroupLangId,
pgl.productGroupId,
pgl.mid,
pgl.lang,
pgl.name,
pgl.description,
pgl.shortDescription,
pgl.permalink,
pgl.tagovi,
pgl.metaTitle,
pgl.metaDescription,
pgl.shortName
FROM nb_product_group p
INNER JOIN nb_product_group_lang pgl ON (pgl.productGroupId = p.id AND pgl.lang = 'ba')
WHERE pgl.permalink = 'project-rock' AND p.del = -1
AND p.status = 1 "
[3]=>
string(860) "SELECT c.*,
ncl.id as categoryId,
ncl.mid,
ncl.lang,
ncl.name,
ncl.subtitle,
ncl.description,
ncl.shortDescription,
ncl.tagovi,
ncl.permalink,
ncl.link,
ncl.metaTitle,
ncl.metaDescription,
ncl.menuModuleId,
ncl.menuId
FROM nb_news_category c
INNER JOIN nb_news_category_lang ncl ON ncl.categoryId = c.id AND ncl.lang = 'ba'
WHERE ncl.permalink = 'project-rock' AND c.del = -1 AND c.parentid = 0 AND c.status = 1
"
[4]=>
string(382) "SELECT
lt.value,
l.name as labelaName
FROM
nb_site_labela_translate lt
JOIN nb_site_labela l ON lt.labelaId = l.id
JOIN nb_site_language lan ON lan.id = lt.languageId
WHERE lan.code = 'ba'
"
[5]=>
string(179) "SELECT c.name, cl.value
FROM nb_config c
INNER JOIN nb_config_country cl ON cl.configId = c.id AND cl.country = 'BIH'
"
[6]=>
string(913) "SELECT p.*,
pl.id as langId,
pl.pageId,
pl.mid,
pl.lang,
pl.name as title,
pl.shortDescription,
pl.content,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.mailingListJson
FROM nb_page p
INNER JOIN nb_page_lang pl ON (pl.pageId = p.id AND pl.lang = 'ba')
WHERE p.uniqueCode IN ('cart','favorites','product_list','article_listing','terms_and_conditions','login','login_facebook','login_google','register','lost_password','profile','logout' ) AND p.status = 1 AND p.del = -1
AND p.countryId = 1 "
[7]=>
string(716) "SELECT p.*,
pl.id as langId,
pl.pageId,
pl.mid,
pl.lang,
pl.name as title,
pl.shortDescription,
pl.content,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.mailingListJson
FROM nb_page p
INNER JOIN nb_page_lang pl ON (pl.pageId = p.id AND pl.lang = 'ba' )
WHERE p.status = 1 AND p.del = -1 AND p.countryId = 1 AND pl.permalink = 'project-rock' "
[8]=>
string(864) "SELECT p.*,
SUBSTRING(SUBSTRING_INDEX(p.path, '/', 2), 2) as mainProductGroupId,
pgl.id as productGroupLangId,
pgl.productGroupId,
pgl.mid,
pgl.lang,
pgl.name,
pgl.description,
pgl.shortDescription,
pgl.permalink,
pgl.tagovi,
pgl.metaTitle,
pgl.metaDescription,
pgl.shortName,
pgl.pluralName
FROM nb_product_group p
INNER JOIN nb_product_group_lang pgl ON (pgl.productGroupId = p.id AND pgl.lang = 'ba')
WHERE pgl.permalink = 'project-rock' AND p.del = -1
AND p.status = 1 "
[9]=>
string(825) "SELECT c.*,
ncl.id as categoryId,
ncl.mid,
ncl.lang,
ncl.name,
ncl.subtitle,
ncl.description,
ncl.shortDescription,
ncl.tagovi,
ncl.permalink,
ncl.link,
ncl.metaTitle,
ncl.metaDescription,
ncl.menuModuleId,
ncl.menuId
FROM nb_news_category c
INNER JOIN nb_news_category_lang ncl ON ncl.categoryId = c.id AND ncl.lang = 'ba'
WHERE ncl.permalink = 'project-rock' AND c.del = -1
"
[10]=>
string(890) "SELECT mt.*,
mtl.id as metaDataLangId,
mtl.metaDataId,
mtl.mid,
mtl.lang,
mtl.name,
mtl.link,
mtl.typePage,
mtl.shortDescription,
mtl.description,
mtl.image,
mtl.imageMobile
FROM nb_meta_data mt
LEFT JOIN nb_meta_data_lang mtl ON (mtl.metaDataId = mt.id AND (mtl.lang = 'ba' OR (mtl.id = mtl.mid and mtl.id NOT IN (SELECT mtl1.mid from nb_meta_data_lang mtl1 WHERE mtl1.mid = mtl.mid and mtl1.lang = 'ba'))))
WHERE mt.typeObject = 'news_category' AND mt.objectId = '39' AND mt.status = 1 AND mt.del = -1
GROUP BY mt.type
"
[11]=>
string(221) "SELECT upmpc.id,
upmpc.name,
upmpc.value
FROM nb_user_public_my_product_config upmpc
WHERE countryId = '1' AND lang = 'ba'
"
[12]=>
string(221) "SELECT upmpc.id,
upmpc.name,
upmpc.value
FROM nb_user_public_my_product_config upmpc
WHERE countryId = '1' AND lang = 'ba'
"
[13]=>
string(825) "SELECT c.*,
ncl.id as categoryId,
ncl.mid,
ncl.lang,
ncl.name,
ncl.subtitle,
ncl.description,
ncl.shortDescription,
ncl.tagovi,
ncl.permalink,
ncl.link,
ncl.metaTitle,
ncl.metaDescription,
ncl.menuModuleId,
ncl.menuId
FROM nb_news_category c
INNER JOIN nb_news_category_lang ncl ON ncl.categoryId = c.id AND ncl.lang = 'ba'
WHERE ncl.permalink = 'project-rock' AND c.del = -1
"
[14]=>
string(162) "SELECT *
FROM nb_news_category
WHERE id IN (39) AND del = -1 AND status = 1 AND checkPrivilegesForUserPublic = 1
"
[15]=>
string(888) "SELECT c.*,
cl.id as categoryLangId,
cl.categoryId,
cl.mid,
cl.lang,
cl.name,
cl.subtitle,
cl.description,
cl.shortDescription,
cl.permalink,
cl.link,
cl.tagovi,
cl.metaTitle,
cl.metaDescription,
cl.menuModuleId,
cl.menuId
FROM nb_news_category c
INNER JOIN nb_news_category_lang cl ON (cl.categoryId = c.id AND cl.lang = 'ba' )
WHERE (c.status = '1' ) AND (c.del = '-1' ) AND (c.parentid >-1 AND c.parentid IN(39) ) ORDER BY c.sort ASC, c.dateCreate DESC "
[16]=>
string(1138) "SELECT c.*,
cl.id as categoryLangId,
cl.categoryId,
cl.mid,
cl.lang,
cl.name,
cl.subtitle,
cl.description,
cl.shortDescription,
cl.permalink,
cl.link,
cl.tagovi,
cl.metaTitle,
cl.metaDescription,
p.permalink as pagePermalink,
cl.menuModuleId,
cl.menuId
FROM nb_news_category c
left JOIN nb_page_lang p ON p.pageId = c.pageId and p.lang = 'ba'
left JOIN nb_news_category_lang cl ON cl.categoryId = c.id AND cl.lang = 'ba'
WHERE c.id IN (39) AND c.del = -1 AND c.status = 1
ORDER BY c.levelDepth ASC
"
[17]=>
string(421) "SELECT a.*,
nl.name as articleName
FROM nb_activity a
INNER JOIN nb_news n ON n.id = a.objectId
INNER JOIN nb_news_lang nl ON nl.newsId = n.id
INNER JOIN nb_news_category nc ON nc.id = n.categoryId
WHERE a.typeObject = 'news' AND nc.parentId = '0' AND a.status = 1 AND a.del = -1
ORDER BY a.sort ASC "
[18]=>
string(1138) "SELECT c.*,
cl.id as categoryLangId,
cl.categoryId,
cl.mid,
cl.lang,
cl.name,
cl.subtitle,
cl.description,
cl.shortDescription,
cl.permalink,
cl.link,
cl.tagovi,
cl.metaTitle,
cl.metaDescription,
p.permalink as pagePermalink,
cl.menuModuleId,
cl.menuId
FROM nb_news_category c
left JOIN nb_page_lang p ON p.pageId = c.pageId and p.lang = 'ba'
left JOIN nb_news_category_lang cl ON cl.categoryId = c.id AND cl.lang = 'ba'
WHERE c.id IN (39) AND c.del = -1 AND c.status = 1
ORDER BY c.levelDepth ASC
"
[19]=>
string(1138) "SELECT c.*,
cl.id as categoryLangId,
cl.categoryId,
cl.mid,
cl.lang,
cl.name,
cl.subtitle,
cl.description,
cl.shortDescription,
cl.permalink,
cl.link,
cl.tagovi,
cl.metaTitle,
cl.metaDescription,
p.permalink as pagePermalink,
cl.menuModuleId,
cl.menuId
FROM nb_news_category c
left JOIN nb_page_lang p ON p.pageId = c.pageId and p.lang = 'ba'
left JOIN nb_news_category_lang cl ON cl.categoryId = c.id AND cl.lang = 'ba'
WHERE c.id IN (39) AND c.del = -1 AND c.status = 1
ORDER BY c.levelDepth ASC
"
[20]=>
string(469) "SELECT i.id,
i.typeObject,
i.objectId,
i.template,
i.sort,
i.sortTemplate
FROM nb_items i
WHERE i.status = 1 AND i.del = -1
AND i.typeObject='news_category' AND i.objectId = '39' GROUP BY i.template ORDER BY i.sortTemplate ASC, i.template ASC "
[21]=>
string(1022) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[22]=>
string(1022) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[23]=>
string(1023) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category2' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[24]=>
string(826) "SELECT i.*,
CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(i.imageUrl, '-', -1), '_',1), '.', 1) AS SIGNED) as sortImageByImageUrl,
it.id as translateId,
it.imagesId,
it.mid,
it.lang,
it.name,
it.embedCode,
it.description,
it.map
FROM nb_images i
left JOIN nb_images_translate it ON (it.imagesId = i.id AND it.lang = 'ba')
WHERE i.status = 1 AND i.del = -1 AND i.objectId = '39' AND i.typeObject = 'news_category'
ORDER BY i.sort ASC, sortImageByImageUrl ASC, i.dateCreate DESC, it.name ASC
LIMIT 0,100;"
[25]=>
string(873) "SELECT c.*,
cl.id as categoryLangId,
cl.categoryId,
cl.mid,
cl.lang,
cl.name,
cl.subtitle,
cl.description,
cl.shortDescription,
cl.permalink,
cl.link,
cl.tagovi,
cl.metaTitle,
cl.metaDescription,
cl.menuModuleId,
cl.menuId
FROM nb_news_category c
INNER JOIN nb_news_category_lang cl ON (cl.categoryId = c.id AND cl.lang = 'ba' )
WHERE (c.status = '1' ) AND (c.del = '-1' ) AND (cl.lang = 'ba' ) AND (c.parentid = '39' ) ORDER BY cl.name ASC "
[26]=>
string(162) "SELECT *
FROM nb_news_category
WHERE id IN (39) AND del = -1 AND status = 1 AND checkPrivilegesForUserPublic = 1
"
[27]=>
string(1091) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 7 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[28]=>
string(1092) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 60 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[29]=>
string(1092) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 61 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[30]=>
string(1092) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 62 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[31]=>
string(694) "SELECT a.*,
al.id as atributesLangId,
al.atributesId,
al.mid,
al.lang,
al.name,
al.clear_name,
al.maleName,
al.femaleName,
al.childName,
al.description
FROM nb_atributes a
INNER JOIN nb_atributes_lang al ON (al.atributesId = a.id AND al.lang = 'ba') WHERE a.atributesGroupId=7 AND a.status=1 AND a.del=-1 AND a.image IS NOT NULL AND a.image != '' GROUP BY al.clear_name ORDER BY a.sort ASC, al.name ASC, a.id ASC "
[32]=>
string(682) "SELECT a.*,
al.id as atributesLangId,
al.atributesId,
al.mid,
al.lang,
al.name,
al.clear_name,
al.maleName,
al.femaleName,
al.childName,
al.description
FROM nb_atributes a
INNER JOIN nb_atributes_lang al ON (al.atributesId = a.id AND al.lang = 'ba') WHERE a.atributesGroupId=7 AND a.status=1 AND a.del=-1 AND a.image IS NOT NULL AND a.image != '' GROUP BY al.clear_name ORDER BY al.name ASC, a.id ASC "
[33]=>
string(1049) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.parentId = '239' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[34]=>
string(1049) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.parentId = '242' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[35]=>
string(1049) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.parentId = '245' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[36]=>
string(1049) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.parentId = '246' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[37]=>
string(1049) "SELECT i.*,
il.id as itemsLangId,
il.itemId,
il.mid,
il.lang,
il.name,
il.link,
il.shortName,
il.shortDescription,
il.description,
il.image2,
il.image2Mobile,
il.dateFrom,
il.dateTo,
il.styleJson,
il.duration,
il.video,
il.videoMob
FROM nb_items i
INNER JOIN nb_items_lang il ON (il.itemId = i.id AND (il.lang = 'ba'))
WHERE (i.typeObject = 'news_category' ) AND (i.objectId = '39' ) AND (i.status = '1' ) AND (i.del = '-1' ) AND (i.parentId = '248' ) AND (i.id >0 AND (IF(il.duration = -1, 1, IF('2024-10-23 12:11:16' BETWEEN il.dateFrom AND il.dateTo, 1, -1)) = 1) ) ORDER BY i.sort ASC LIMIT 0 , 100"
[38]=>
string(1092) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 12 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[39]=>
string(1091) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 2 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[40]=>
string(1091) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 3 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[41]=>
string(1091) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 4 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
[42]=>
string(771) "SELECT c.id,
c.shortName,
c.isoNumeric,
c.code,
c.logo,
c.zoneId,
c.status,
c.del,
c.sort,
cl.id as countryGeoLangId,
cl.countryGeoId,
cl.mid,
cl.lang,
cl.name,
cl.description
FROM nb_country_geo c
left JOIN nb_country_geo_lang cl ON (cl.countryGeoId = c.id AND (cl.lang = 'ba'))
WHERE c.id = '32'
"
[43]=>
string(1092) "SELECT
eb.*,
ebl.id as langId,
ebl.sliderItemId,
ebl.mid,
ebl.lang,
ebl.title,
ebl.subtitle,
ebl.link,
ebl.link2,
ebl.image,
ebl.image2,
ebl.video,
ebl.videoMob,
ebl.description,
ebl.utmCampaign,
ebl.html
FROM nb_slider_item eb
INNER JOIN nb_slider_item_lang ebl ON ebl.sliderItemId = eb.id AND ebl.lang = 'ba'
WHERE eb.sliderId = 32 AND eb.status = 1 AND eb.del = -1 AND IF(eb.catalogsIds = '' OR eb.catalogsIds IS NULL,1, FIND_IN_SET('1', eb.catalogsIds)) AND (IF(eb.unlimitedDuration = 1, 1, IF( '2024-10-23 12:11' BETWEEN eb.dateFrom AND eb.dateTo, 1, -1)) = 1)
AND eb.showOnAppWeb <> 'for_app' ORDER BY eb.sort ASC "
}
Memory Consumption is: 26.12 MB