SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491945 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491945 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022867,371436,626854,56215,920213,20678,953184,1036422,350095,281493,253041,700938,908095,419094,866855,873556,34596,839051,378179,71478,409359,733939,317479,607030,666936,991074,482944,858763,547261,357775,121664,277171,110295,358383,789312,752511,55933,956660,704454,153122,878712,149747,321213,449975,431177,569466,319000,15695,85978,420633,392107,219265,899905,1020778,934372,581658,285621,751037,335412,467068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000916s ]