SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011693 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011693 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875504,958074,212777,718166,46367,591526,692903,100073,385347,873907,325124,617795,312537,757169,76734,651082,907941,783759,464141,785794,851074,924416,166250,485263,986170,40065,496763,163075,429059,626283,152641,665634,737425,464078,855306,575218,965526,592933,960976,156958,198453,360684,3525,507355,291760,744295,342596,419092,940257,815333,658693,1014501,938992,992874,215885,183112,133153,135110,629580,321173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000992s ]