SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047993 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047993 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717981,311937,944648,157849,106337,919658,187639,551441,849173,14206,600755,94886,560262,874,176161,834805,717110,298523,576131,197390,406702,545949,409969,679345,598500,819330,213861,269413,746496,868969,394451,974589,523805,204997,879034,96125,105430,382630,614701,375210,1010296,224239,118593,729441,82097,767090,986644,77172,271891,448988,88022,798426,513907,190602,82389,699961,646983,330259,671857,920737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]