SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438903 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438903 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457977,216988,985656,780545,736700,631245,47885,440053,963184,706358,132296,740944,138126,216758,150847,644120,188183,1008385,43053,923534,17911,738423,678741,778036,626561,395789,904399,152580,273919,339837,824131,820993,80039,554615,968123,128059,499592,655217,674350,887651,972613,815150,253766,551399,258577,754772,302101,856556,38018,259897,1007741,813314,172243,270057,517305,93107,287351,315749,462771,805843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]