الفرقة تجارة-ضرائب

تأسست هذه الفرقة بموجب المرسوم تنفيذي رقم 97- 290‏ مؤرخ في 22 ‏ربيع الأول عام 1418 ‏ الموافق 27 ‏يوليو سنة 1997‏ يتضمن تأسيس لجان التنسيق والفرق المختلطة للرقابة بين مصالح وزارة المالية ووزارة التجارة وتنظيمها.

حصائل الرقابة للفرق المختلطة ممارسات تجارية وقمع الغش إبتداءا من 01/04/2013

إلى غاية 30/09/2013

الفرقة المختلطة ( تجارة – مصالح البيطرة )		الفرقة المشتركة ( جمارك ـ ضرائب ـ تجارة )
العدد الإجمالي للتدخلات	179	العدد الإجمالي للتدخلات	36
عدد المخالفات المسجلة	50	عدد المخالفات المسجلة	14
عدد محاضر المتابعات القضائية	50	عدد محاضر المتابعات القضائية	08
عدد قرارات الغلق الإداري	03	عدد قرارات الغلق الإداري	/
عددالعينات المحولة للمخبر	/	مبلغ عدم الفوترة	340.704.504,91
كمية المحجوزات (طن)	2,518745	مبلغ الفواتير غير المطابقة	13.791.200,00
أهم المحجوزات	لحوم ومشتقاتها
القيمة المالية للمحجوزات (دج)	856.188,30

< السابق

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

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

Application 0.263 seconds (+0.262); 6.52 MB (+5.832) - afterInitialise

Application 0.323 seconds (+0.061); 7.88 MB (+1.357) - afterRoute

Application 0.486 seconds (+0.162); 11.48 MB (+3.607) - afterDispatch

Application 0.501 seconds (+0.016); 11.81 MB (+0.329) - beforeRenderModule mod_menu (Top Menu)

Application 0.512 seconds (+0.011); 11.92 MB (+0.110) - afterRenderModule mod_menu (Top Menu)

Application 0.523 seconds (+0.011); 12.18 MB (+0.260) - beforeRenderModule mod_search (بحث بالموقع)

Application 0.530 seconds (+0.007); 12.21 MB (+0.026) - afterRenderModule mod_search (بحث بالموقع)

Application 0.531 seconds (+0.000); 12.20 MB (-0.007) - beforeRenderModule mod_custom (browsers)

Application 0.535 seconds (+0.004); 12.21 MB (+0.008) - afterRenderModule mod_custom (browsers)

Application 0.539 seconds (+0.004); 12.21 MB (-0.002) - beforeRenderModule mod_custom (Logo)

Application 0.541 seconds (+0.002); 12.22 MB (+0.011) - afterRenderModule mod_custom (Logo)

Application 0.542 seconds (+0.002); 12.22 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.586 seconds (+0.044); 12.40 MB (+0.177) - afterRenderModule mod_menu (Main Menu)

Application 0.614 seconds (+0.028); 12.42 MB (+0.025) - beforeRenderModule mod_menu (القــائمـــة الرئيـسيـــة)

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

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

Application 0.635 seconds (+0.011); 12.47 MB (+0.030) - afterRenderModule mod_menu (حصــــائل وإحصــــائات)

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

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

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

Application 0.687 seconds (+0.045); 12.99 MB (+0.512) - afterRenderModule mod_articles_popular (المقالات الأكثر قراءة)

Application 0.687 seconds (+0.001); 12.81 MB (-0.184) - beforeRenderModule mod_articles_latest (آخر المقالات والأخبار)

Application 0.722 seconds (+0.035); 13.03 MB (+0.223) - afterRenderModule mod_articles_latest (آخر المقالات والأخبار)

Application 0.744 seconds (+0.022); 12.88 MB (-0.156) - beforeRenderModule mod_custom (servmincom)

Application 0.746 seconds (+0.002); 12.88 MB (+0.004) - afterRenderModule mod_custom (servmincom)

Application 0.749 seconds (+0.003); 12.88 MB (0.000) - beforeRenderModule mod_menu (Footer Menu)

Application 0.755 seconds (+0.006); 12.89 MB (+0.008) - afterRenderModule mod_menu (Footer Menu)

Application 0.755 seconds (+0.000); 12.88 MB (-0.006) - beforeRenderModule mod_custom (Copyright)

Application 0.757 seconds (+0.002); 12.89 MB (+0.004) - afterRenderModule mod_custom (Copyright)

Application 0.786 seconds (+0.029); 12.87 MB (-0.016) - afterRender

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

SELECT `data` FROM `j8tjs_session` WHERE `session_id` = '069a1bc130adcd72e9e586a8e0eeb266'
DELETE FROM `j8tjs_session` WHERE `time` < '1775093709'
SELECT `session_id` FROM `j8tjs_session` WHERE `session_id` = '069a1bc130adcd72e9e586a8e0eeb266' LIMIT 0, 1
INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) VALUES ('069a1bc130adcd72e9e586a8e0eeb266', 0, '1775094609')
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=1775095200;
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 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-02 01:50:09') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-02 01:50:09') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 201 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 = 33 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-02 01:50:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-02 01:50:09') 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=12 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.33') 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 = 12 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-02 01:50:09') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-04-02 01:50:09') ORDER BY a.ordering
UPDATE j8tjs_content SET hits = hits + 1 WHERE id = 33
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'
DELETE FROM `j8tjs_session` WHERE `time` < '1775093709'
SELECT `session_id` FROM `j8tjs_session` WHERE `session_id` = '069a1bc130adcd72e9e586a8e0eeb266' LIMIT 0, 1
SELECT extension_id AS id, element AS "option", params, enabled FROM j8tjs_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
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-02 01:50:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-02 01:50:09') 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=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 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-02 01:50:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-02 01:50:09') 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=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 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:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775094609;s:18:\"session.timer.last\";i:1775094609;s:17:\"session.timer.now\";i:1775094609;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";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;}}' , `time` = '1775094610' WHERE `session_id` = '069a1bc130adcd72e9e586a8e0eeb266'

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

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

11 × SELECT extension_id FROM j8tjs_extensions
6 × 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 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 `session_id` FROM `j8tjs_session`
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 * FROM j8tjs_languages
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 × SELECT params FROM j8tjs_extensions AS e
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 a.rules FROM j8tjs_assets AS a
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 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 `data` FROM `j8tjs_session`
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 id FROM j8tjs_assets

جداول أخرى:

2 × DELETE FROM `j8tjs_session`
1 × UPDATE `j8tjs_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775094609;s:18:\"session.timer.last\";i:1775094609;s:17:\"session.timer.now\";i:1775094609;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";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;}}' , `time` = '1775094610'
1 × UPDATE j8tjs_content SET hits = hits + 1
1 × UPDATE j8tjs_vvisit_counter SET visits=visits+1, bots=bots+1
1 × INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) VALUES ('069a1bc130adcd72e9e586a8e0eeb266', 0, '1775094609'
1 × SHOW FULL COLUMNS FROM `j8tjs_assets

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

الدورة

__default

user

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

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

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

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

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

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

جداول أخرى: