SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419458 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419458 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975821,293598,282587,647989,857547,408791,73712,1033870,98179,517299,778089,362067,863987,119239,169039,469710,228024,362072,371131,453784,269891,754198,747845,372661,248026,255234,601481,294824,447802,784143,512634,723633,131686,459126,757699,267042,474243,797691,504932,577639,384372,670995,780690,622519,560043,949434,974785,224399,225748,26105,979796,689280,859354,783636,264650,533193,11254,1032644,711850,307414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]