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` = 648180 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648180 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48456,521209,179124,31986,226343,229110,605637,593938,247440,661004,545086,15933,61176,355935,858324,666714,734576,260232,432067,134266,753447,343288,502740,145463,174659,943563,306813,510062,285940,786460,19774,993254,370723,200917,492330,127576,336473,756736,977514,782347,774058,814990,108142,385198,32388,599464,1037002,52082,909346,557601,430608,369305,719251,352839,896075,603426,742933,362709,127544,109805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]