SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84151 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84151 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974346,529412,957091,140709,1047244,328628,841859,250519,269348,957276,1042600,630137,1042442,730441,501105,911813,681357,180975,364102,680209,225514,714735,753810,361797,593491,900096,150721,835725,901884,84102,672724,979032,94987,279045,66029,293431,317703,189310,1030045,127980,1031526,407964,242203,572341,1011116,892678,65192,991425,181155,160991,17680,21224,741700,630793,411366,367309,302649,648084,975064,630495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]