SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105985 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105985 [ RunTime:0.001342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539453,108546,871290,198972,633094,7183,885562,1022083,142534,750724,1030862,283777,10747,126209,362874,394185,832232,140343,234856,968027,950971,670356,671094,944173,622401,932666,84367,13585,68744,283511,7774,541678,705316,113188,188343,1036912,20839,790040,130901,202838,158140,923457,810839,1367,258229,902094,595840,162006,167765,382551,62605,192391,54118,457631,446506,1013540,35508,989482,574777,523955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]