SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251019 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251019 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238756,993124,698424,1012092,575182,482705,1025923,94852,661833,141076,217278,617704,171672,888764,309165,787939,332669,464158,730103,361744,840779,835518,664317,431913,71146,647355,33318,132717,548650,842042,914090,530160,1016710,113549,258799,25706,786365,979205,957620,488741,158949,788645,164379,386728,367660,891595,921595,180152,674947,736727,29873,377351,636156,935657,323768,860949,1016781,951873,697812,431754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]