SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691417 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691417 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534133,131277,1042548,648328,913938,610009,501047,159420,76600,80193,651032,85484,443154,191418,433992,672029,513276,919466,293062,1038566,208598,324624,906230,927823,1024843,676547,49479,770184,1022720,63404,409678,640816,463368,884341,77031,372967,959542,939004,682939,437324,203349,435464,92030,140635,928925,15545,483841,925920,802298,961303,774050,822990,840414,709171,180783,163556,756932,63891,563267,31258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]