SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114028 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114028 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200866,952285,975983,37253,770651,967784,283533,212555,646887,362886,934534,506381,717110,516480,775400,94320,118407,519529,545624,910518,84920,18085,1041603,884804,472635,815800,727699,83334,725614,403682,551844,629690,205124,379285,556897,144353,676244,619020,749309,594654,1034011,481108,858312,950517,1048849,764679,939307,937531,869710,348042,201447,314869,763358,375023,275489,968036,838293,875211,553485,433804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001425s ]