SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106092 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106092 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616703,37852,711450,149684,903288,1043805,39845,148282,795118,50225,2185,916451,31448,216830,660582,956293,813866,772230,298992,147113,713788,574955,449283,617946,900352,202662,562601,530746,652184,594853,403554,586133,4170,846207,5855,106895,65661,928708,66595,623617,587019,986671,516309,826950,756231,1022254,320744,76002,893286,102533,930093,958109,778359,426080,739599,195920,877610,174358,669719,408983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001584s ]