SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513680 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513680 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454339,365139,328072,294169,445106,165686,509236,153542,707509,329618,103618,702602,747453,270166,556335,377798,742420,588539,986766,29003,927546,792055,1015866,617523,288139,901373,196872,573656,608500,485945,631636,201181,146106,277999,59016,1030539,694839,909960,151790,702848,238993,26848,1031972,713812,563445,581265,44844,975437,953434,426567,207997,979945,378401,738436,953853,634023,980118,915838,389243,867425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]