SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281801 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281801 [ RunTime:0.006188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228004,768587,507442,534028,143791,69196,56015,755943,619772,598939,290979,878145,830356,578627,389238,245941,576285,876043,520433,748929,569696,25723,570057,40876,32732,1013625,677056,816276,765844,29581,414142,772976,444967,22542,90166,797357,55631,987673,590143,213959,16992,376867,776549,47295,2061,23205,510841,235964,670334,857528,603689,19208,269068,204017,787006,466997,348616,221218,436185,537144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001508s ]