كلمة السيد مدير التجارة

By master

تحت الرعاية السامية لفخامة رئيس الجمهورية السيـد عبـد العزيـز بوتفليقـة ، تنظـم وزارة التجارة يومـي 30 و31 مارس 2015 بقصر…

المزيد...

بســم اللــه الرحمــن الرحيــم

والصلاة والسلام على سيدنا محمد وعلى آله وصحبه أجمعين زوارنــــــــــا الأكـــــــــارم :

إننا نفخر ونعتز باستقبالكم على الموقع الالكتروني الخاص بمديرية التجارة لولاية باتنة

لقد أصبح التواصل الالكتروني قناعة و واقع يفرض نفسه على كل إنسان و همزة وصل بين الإدارة والمواطن يستطيع من خلاله كل عون اقتصادي أو مستهلك أو باحث أن يطلع على كل مستجدات قطاع التجارة.

إن موقعنا هذا جاء تلبية لمتطلبات العصرونافدة على قطاع التجارة بولاية باتنة من خلال:

- التعريف بالمديرية و مهامها و صلاحياتها وكذا نبذة عن الولاية

- النصوص و المراجع القانونية المنظمة لقطاع التجارة

- الحصائل الدورية المتعلقة بنشاطات الرقابة الميدانية

- التوصيات و التوجيهات المتعلقة بحماية المستهلك

إننا ندعو كل متصفح لهذا الفضاء الاكترونى أن لا يبخل علينا باقتراحاته و ملاحظاته و نقده البناء وسنكون ممنونين لكل مساهماتكم لتحسين هذا الموقع و بالتالي المساعدة على تطوير قطاع التجارة.

وفقنا الله جميعا لخير هذا الوطن و لما يحب و يرضى.

< السابق

وحدة تحكم تشخيص الأخطاء لجوملا!

Application 0.000 seconds (+0.000); 0.69 MB (+0.687) - afterLoad

Application 0.091 seconds (+0.091); 6.52 MB (+5.833) - afterInitialise

Application 0.131 seconds (+0.040); 8.02 MB (+1.502) - afterRoute

Application 0.317 seconds (+0.186); 11.69 MB (+3.672) - afterDispatch

Application 0.330 seconds (+0.013); 12.02 MB (+0.330) - beforeRenderModule mod_menu (Top Menu)

Application 0.338 seconds (+0.007); 12.13 MB (+0.110) - afterRenderModule mod_menu (Top Menu)

Application 0.338 seconds (+0.000); 12.13 MB (+0.000) - beforeRenderModule mod_pagepeel_banner (Page Peel Banner)

Application 0.345 seconds (+0.007); 12.40 MB (+0.261) - afterRenderModule mod_pagepeel_banner (Page Peel Banner)

Application 0.353 seconds (+0.008); 12.65 MB (+0.251) - beforeRenderModule mod_search (بحث بالموقع)

Application 0.359 seconds (+0.006); 12.67 MB (+0.027) - afterRenderModule mod_search (بحث بالموقع)

Application 0.359 seconds (+0.000); 12.67 MB (-0.007) - beforeRenderModule mod_custom (browsers)

Application 0.366 seconds (+0.006); 12.67 MB (+0.008) - afterRenderModule mod_custom (browsers)

Application 0.381 seconds (+0.016); 12.67 MB (-0.002) - beforeRenderModule mod_custom (Logo)

Application 0.383 seconds (+0.002); 12.68 MB (+0.011) - afterRenderModule mod_custom (Logo)

Application 0.405 seconds (+0.022); 12.68 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.443 seconds (+0.038); 12.86 MB (+0.175) - afterRenderModule mod_menu (Main Menu)

Application 0.460 seconds (+0.017); 12.89 MB (+0.033) - beforeRenderModule mod_fpss (Frontpage Slideshow (by JoomlaWorks))

Application 0.487 seconds (+0.026); 13.84 MB (+0.948) - afterRenderModule mod_fpss (Frontpage Slideshow (by JoomlaWorks))

Application 0.490 seconds (+0.003); 13.77 MB (-0.065) - beforeRenderModule mod_custom (كلمة السيد المدير)

Application 0.491 seconds (+0.001); 13.78 MB (+0.004) - afterRenderModule mod_custom (كلمة السيد المدير)

Application 0.491 seconds (+0.000); 13.78 MB (+0.002) - beforeRenderModule mod_mijopolls (استطــلاع الـــرأي)

Application 0.516 seconds (+0.025); 14.00 MB (+0.217) - afterRenderModule mod_mijopolls (استطــلاع الـــرأي)

Application 0.516 seconds (+0.000); 13.97 MB (-0.032) - beforeRenderModule mod_login (دخول الأعضاء)

Application 0.532 seconds (+0.016); 14.03 MB (+0.068) - afterRenderModule mod_login (دخول الأعضاء)

Application 0.533 seconds (+0.000); 14.04 MB (+0.006) - beforeRenderModule mod_vvisit_counter (زوار الموقع)

Application 0.545 seconds (+0.012); 14.13 MB (+0.088) - afterRenderModule mod_vvisit_counter (زوار الموقع)

Application 0.556 seconds (+0.011); 14.11 MB (-0.021) - beforeRenderModule mod_menu (القــائمـــة الرئيـسيـــة)

Application 0.566 seconds (+0.010); 14.13 MB (+0.027) - afterRenderModule mod_menu (القــائمـــة الرئيـسيـــة)

Application 0.566 seconds (+0.000); 14.13 MB (-0.004) - beforeRenderModule mod_menu (حصــــائل وإحصــــائات)

Application 0.581 seconds (+0.014); 14.16 MB (+0.029) - afterRenderModule mod_menu (حصــــائل وإحصــــائات)

Application 0.581 seconds (+0.000); 14.15 MB (-0.004) - beforeRenderModule mod_menu (الإعــلام والاتصـــــــال)

Application 0.587 seconds (+0.006); 14.17 MB (+0.017) - afterRenderModule mod_menu (الإعــلام والاتصـــــــال)

Application 0.587 seconds (+0.000); 14.17 MB (-0.005) - beforeRenderModule mod_articles_popular (المقالات الأكثر قراءة)

Application 0.625 seconds (+0.038); 14.58 MB (+0.416) - afterRenderModule mod_articles_popular (المقالات الأكثر قراءة)

Application 0.625 seconds (+0.000); 14.40 MB (-0.186) - beforeRenderModule mod_articles_latest (آخر المقالات والأخبار)

Application 0.661 seconds (+0.036); 14.61 MB (+0.215) - afterRenderModule mod_articles_latest (آخر المقالات والأخبار)

Application 0.697 seconds (+0.036); 14.47 MB (-0.143) - beforeRenderModule mod_custom (servmincom)

Application 0.701 seconds (+0.003); 14.47 MB (+0.004) - afterRenderModule mod_custom (servmincom)

Application 0.702 seconds (+0.002); 14.47 MB (-0.001) - beforeRenderModule mod_menu (Footer Menu)

Application 0.714 seconds (+0.011); 14.48 MB (+0.008) - afterRenderModule mod_menu (Footer Menu)

Application 0.715 seconds (+0.001); 14.47 MB (-0.006) - beforeRenderModule mod_custom (Copyright)

Application 0.718 seconds (+0.003); 14.48 MB (+0.004) - afterRenderModule mod_custom (Copyright)

Application 0.789 seconds (+0.072); 14.52 MB (+0.042) - afterRender

68 الاستعلامات المسجلة

SELECT `data` FROM `j8tjs_session` WHERE `session_id` = '677467080b3a2a587d9bb85086c03fef'
DELETE FROM `j8tjs_session` WHERE `time` < '1775763873'
SELECT `session_id` FROM `j8tjs_session` WHERE `session_id` = '677467080b3a2a587d9bb85086c03fef' LIMIT 0, 1
INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) VALUES ('677467080b3a2a587d9bb85086c03fef', 0, '1775764773')
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM j8tjs_usergroups AS a LEFT JOIN j8tjs_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `j8tjs_viewlevels`
SELECT folder AS type, element AS name, params FROM j8tjs_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_widgetkit'
SELECT time FROM j8tjs_vvisit_counter USE INDEX(time) ORDER BY time DESC LIMIT 1;
UPDATE j8tjs_vvisit_counter SET visits=visits+1, bots=bots+1 WHERE time=1775764800;
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM j8tjs_menu AS m LEFT JOIN j8tjs_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT id, home, template, s.params FROM j8tjs_template_styles as s LEFT JOIN j8tjs_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=27 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT alias, catid FROM j8tjs_content WHERE id = 27
SELECT a.rules FROM j8tjs_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS FROM `j8tjs_assets`
SELECT id FROM j8tjs_assets WHERE parent_id = 0
SELECT b.rules FROM j8tjs_assets AS a LEFT JOIN j8tjs_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_aclsfgpl'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_acymailing'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_adsmanager'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_comprofiler'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_easybookreloaded'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_kunena'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_mtree'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_phocaguestbook'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT extension_id FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_zoo'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j8tjs_modules AS m LEFT JOIN j8tjs_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j8tjs_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-04-09 19:59:33') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-09 19:59:33') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT * FROM j8tjs_languages WHERE published=1 ORDER BY ordering ASC
SELECT b.rules FROM j8tjs_assets AS a LEFT JOIN j8tjs_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM j8tjs_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM j8tjs_content AS a LEFT JOIN j8tjs_categories AS c on c.id = a.catid LEFT JOIN j8tjs_users AS u on u.id = a.created_by LEFT JOIN j8tjs_categories as parent ON parent.id = c.parent_id LEFT JOIN j8tjs_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 27 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-09 19:59:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 19:59:33') AND (a.state = 1 OR a.state =2)
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=8 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT b.rules FROM j8tjs_assets AS a LEFT JOIN j8tjs_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.27') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.language, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM j8tjs_content AS a LEFT JOIN j8tjs_categories AS cc ON cc.id = a.catid WHERE a.catid = 8 AND a.state = 1 AND a.access = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-04-09 19:59:33') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-04-09 19:59:33') ORDER BY a.ordering
UPDATE j8tjs_content SET hits = hits + 1 WHERE id = 27
SELECT params FROM j8tjs_extensions AS e WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_media'
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM j8tjs_banners as a LEFT JOIN j8tjs_banner_clients AS cl ON cl.id = a.cid WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) ORDER BY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM j8tjs_banners as a LEFT JOIN j8tjs_banner_clients AS cl ON cl.id = a.cid WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) ORDER BY a.sticky DESC,a.ordering LIMIT 0, 1
SELECT `session_id` FROM `j8tjs_session` WHERE `session_id` = '677467080b3a2a587d9bb85086c03fef' LIMIT 0, 1
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
SELECT slide.*, ` group`.title AS groupname, category.name AS categoryName, category.params AS categoryParams, author.name AS authorName, moderator.name AS moderatorName FROM j8tjs_fpss_slides AS slide JOIN j8tjs_fpss_categories AS category ON slide.catid = category.id JOIN j8tjs_viewlevels AS ` group` ON ` group`.id = slide.access LEFT JOIN j8tjs_users AS author ON author.id = slide.created_by LEFT JOIN j8tjs_users AS moderator ON moderator.id = slide.modified_by WHERE slide.published = 1 AND slide.access IN (1,1) AND (slide.publish_up = '0000-00-00 00:00:00' OR slide.publish_up <= '2026-04-09 19:59:33') AND (slide.publish_down = '0000-00-00 00:00:00' OR slide.publish_down >= '2026-04-09 19:59:33') AND slide.language IN ('ar-AA','*') AND category.published = 1 ORDER BY id DESC
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_fpss'
SELECT article.title, article.introtext, article.catid, article.alias, category.title AS categoryName, category.alias AS categoryAlias FROM j8tjs_content AS article INNER JOIN j8tjs_categories AS category ON article.catid = category.id WHERE article.id = 112 AND article.state = 1 AND article.access IN(1,1) AND ( article.publish_up = '0000-00-00 00:00:00' OR article.publish_up <= '2026-04-09 19:59:33' ) AND ( article.publish_down = '0000-00-00 00:00:00' OR article.publish_down >= '2026-04-09 19:59:33' ) AND category.published = 1 AND category.access IN(1,1)
SHOW FULL COLUMNS FROM `j8tjs_users`
SELECT * FROM `j8tjs_users` WHERE `id` = 353
SELECT `g`.`id`,`g`.`title` FROM `j8tjs_usergroups` AS g INNER JOIN `j8tjs_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 353
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=10 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT o.*, COUNT(v.id) AS hits, (SELECT COUNT(id) FROM j8tjs_mijopolls_votes WHERE poll_id=1) AS votes FROM j8tjs_mijopolls_options AS o LEFT JOIN j8tjs_mijopolls_votes AS v ON (o.id = v.option_id AND v.poll_id = 1) WHERE o.poll_id=1 AND o.text <> '' GROUP BY o.id ORDER BY o.ordering
SHOW FULL COLUMNS FROM `j8tjs_mijopolls_polls`
SELECT * FROM j8tjs_mijopolls_polls WHERE `id` = '1'
SELECT date FROM j8tjs_mijopolls_votes WHERE poll_id=1 AND user_id=0
SELECT ip FROM j8tjs_mijopolls_votes WHERE poll_id=1 AND ip = '168823421'
SELECT o.id, o.text, o.ordering FROM j8tjs_mijopolls_options AS o WHERE o.poll_id = 1 AND o.text <> '' ORDER BY o.ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_mijopolls'
SELECT alias, catid FROM j8tjs_content WHERE id = 27
SELECT SUM(visits) AS visits FROM j8tjs_vvisit_counter WHERE '1=1' AND time > 1775692800
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j8tjs_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j8tjs_content AS a LEFT JOIN j8tjs_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j8tjs_categories AS c ON c.id = a.catid LEFT JOIN j8tjs_users AS ua ON ua.id = a.created_by LEFT JOIN j8tjs_users AS uam ON uam.id = a.modified_by LEFT JOIN j8tjs_categories as parent ON parent.id = c.parent_id LEFT JOIN j8tjs_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-09 19:59:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 19:59:33') ORDER BY a.hits DESC LIMIT 0, 5
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=9 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=13 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j8tjs_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j8tjs_content AS a LEFT JOIN j8tjs_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j8tjs_categories AS c ON c.id = a.catid LEFT JOIN j8tjs_users AS ua ON ua.id = a.created_by LEFT JOIN j8tjs_users AS uam ON uam.id = a.modified_by LEFT JOIN j8tjs_categories as parent ON parent.id = c.parent_id LEFT JOIN j8tjs_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-09 19:59:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 19:59:33') ORDER BY a.created DESC LIMIT 0, 5
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
UPDATE `j8tjs_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775764773;s:18:\"session.timer.last\";i:1775764773;s:17:\"session.timer.now\";i:1775764773;s:24:\"session.client.forwarded\";s:14:\"216.73.216.167\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"d78a07e1b0a41d98b6b3b2d930b5ed26\";}' , `time` = '1775764774' WHERE `session_id` = '677467080b3a2a587d9bb85086c03fef'

40 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً

تحديد الجداول:

11 × SELECT extension_id FROM j8tjs_extensions
8 × SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions
6 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j8tjs_categories as c LEFT JOIN j8tjs_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
3 × SELECT b.rules FROM j8tjs_assets AS a LEFT JOIN j8tjs_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
2 × SELECT `session_id` FROM `j8tjs_session`
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM j8tjs_banners as a LEFT JOIN j8tjs_banner_clients AS cl ON cl.id = a.cid
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j8tjs_contact_details AS contact
2 × SELECT alias, catid FROM j8tjs_content
1 × SELECT * FROM `j8tjs_users`
1 × SELECT article.title, article.introtext, article.catid, article.alias, category.title AS categoryName, category.alias AS categoryAlias FROM j8tjs_content AS article INNER JOIN j8tjs_categories AS category ON article.catid = category.id
1 × SELECT slide.*, ` group`.title AS groupname, category.name AS categoryName, category.params AS categoryParams, author.name AS authorName, moderator.name AS moderatorName FROM j8tjs_fpss_slides AS slide JOIN j8tjs_fpss_categories AS category ON slide.catid = category.id JOIN j8tjs_viewlevels AS ` group` ON ` group`.id = slide.access LEFT JOIN j8tjs_users AS author ON author.id = slide.created_by LEFT JOIN j8tjs_users AS moderator ON moderator.id = slide.modified_by
1 × SELECT SUM(visits) AS visits FROM j8tjs_vvisit_counter
1 × SELECT o.id, o.text, o.ordering FROM j8tjs_mijopolls_options AS o
1 × SELECT ip FROM j8tjs_mijopolls_votes
1 × SELECT params FROM j8tjs_extensions AS e
1 × SELECT date FROM j8tjs_mijopolls_votes
1 × SELECT o.*, COUNT(v.id) AS hits, (SELECT COUNT(id) FROM j8tjs_mijopolls_votes
1 × SELECT `g`.`id`,`g`.`title` FROM `j8tjs_usergroups` AS g INNER JOIN `j8tjs_user_usergroup_map` AS m ON m.group_id = g.id
1 × SELECT * FROM j8tjs_mijopolls_polls
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j8tjs_modules AS m LEFT JOIN j8tjs_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j8tjs_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT time FROM j8tjs_vvisit_counter USE INDEX(time)
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM j8tjs_menu AS m LEFT JOIN j8tjs_extensions AS e ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params FROM j8tjs_extensions
1 × SELECT id, rules FROM `j8tjs_viewlevels
1 × SELECT b.id FROM j8tjs_usergroups AS a LEFT JOIN j8tjs_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params FROM j8tjs_template_styles as s LEFT JOIN j8tjs_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT a.rules FROM j8tjs_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM j8tjs_contact_details AS contact
1 × SELECT * FROM j8tjs_languages
1 × SELECT `data` FROM `j8tjs_session`
1 × SELECT id FROM j8tjs_assets
1 × SELECT a.id, a.language, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM j8tjs_content AS a LEFT JOIN j8tjs_categories AS cc ON cc.id = a.catid

جداول أخرى:

1 × SHOW FULL COLUMNS FROM `j8tjs_users
1 × SHOW FULL COLUMNS FROM `j8tjs_mijopolls_polls
1 × UPDATE `j8tjs_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775764773;s:18:\"session.timer.last\";i:1775764773;s:17:\"session.timer.now\";i:1775764773;s:24:\"session.client.forwarded\";s:14:\"216.73.216.167\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"d78a07e1b0a41d98b6b3b2d930b5ed26\";}' , `time` = '1775764774'
1 × UPDATE j8tjs_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `j8tjs_assets
1 × INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) VALUES ('677467080b3a2a587d9bb85086c03fef', 0, '1775764773'
1 × UPDATE j8tjs_vvisit_counter SET visits=visits+1, bots=bots+1
1 × DELETE FROM `j8tjs_session`

الاجراءات المتخذة في اطار تحسين الخدمة العمومية

المديرية

By master

الندوة الوطنية حول التجارة الخارجية

الندوة الوطنية حول التجارة الخارجية

By master

معدلات الأسعار

معدلات الأسعار اليومية بالولاية

وحدة تحكم تشخيص الأخطاء لجوملا!

الدورة

__default

user

معلومات الملف الشخصي

الذاكرة المستخدمة

استعلامات قاعدة البيانات

68 الاستعلامات المسجلة

40 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً

تحديد الجداول:

جداول أخرى: