SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261598 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261598 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313088,133207,235801,409401,517572,66983,50309,165465,205066,310545,867990,356402,416382,582737,754037,519108,543172,853417,619175,129625,986336,191302,436877,465741,172270,754314,499556,131315,208367,1017074,722371,139623,492992,934946,165763,639300,507619,576559,123284,870434,466084,194838,843424,445327,248083,971234,989377,259160,68263,131945,634392,991150,300358,724801,786611,746241,11776,553483,754501,471470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]